USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation

Number 301 - E-Filing of ICAO Reports

Friday, August 9, 2024
Document
number_301.pdf (43.18 KB)

Department of Transportation
Research and Innovative Technology Administration
Bureau of Transportation Statistics
Office of Airline Information
Accounting and Reporting Directive

No. 301
Issue Date: 2/22/2011
Effective Date: Immediately

As a party to the Convention on International Civil Aviation (Treaty), the United States is obligated to provide ICAO with financial and statistical data on operations of U.S. air carriers (Article 67). The Bureau of Transportation Statistics (BTS) Office of Airline Information (OAI) administers this program for the Department of Transportation (DOT).

To meet ICAO needs for electronic submissions and to eliminate the task of manually entering data (keypunching), BTS is requiring carriers to e-submit the ICAO Financial Supplement BTS Form EF using comma separated values (CVS) file formats. Each data element is separated by a comma. One thousand is reported as 1000 not as 1,000 as the comma indicates a new data element. To enter the BTS Form EF, carriers will go to the website https://esubmit.rita.dot.gov/ and following the instruction for e-submit.

The file format for CSV reporting of BTS form EF is attached.

This action is taken under authority delegated by 14 CFR 385.14(h).

Anne Suissa
Director
Office of Airline Information

COMMA SEPARATE VALUES RECORD LAYOUT

(BTS Form EF ICAO Financial Supplement)

Field Description Comments Sample Data
Air Carrier Code Code as of December 31 ZQ
Year of Data ccyy 2010
Allowance for depreciation Flight Equipment Excludes non operating equipment 20345700
Allowance for depreciation Ground Property and Equipment Excludes non operating Ground Property and Equipment 138675000
Flight Equipment Airworthiness Allowance From system Schedule P-5.2 Direct Maintenance 6450000
Flight Equipment under Capital Lease Total Amount Flight Equipment only 10346000
Flight Equipment under Capital Lease Accumulated Amortization Flight Equipment only 9458000
Total En-route Facilities Charges International Operation only 1/ 1534070
Equity in Income of Investor Controlled Companies See 14 CFR Sec 241.14 Account 87 1250800
Net Balance of Unappropriated Retained Earnings from prior Year Last years 4th Quarter Schedule B-1 Account 2900 minus 2990 1589000
Profit or Loss(-) after extraordinary items for this year This Years Net Income from System Schedule P-1.2 Account 9899 1658500
Adjustments to this Years Retained Earnings - Total Sum of Adjustments 1, 2, and 3 (below) 37034000
Adjustment 1: Transfer to Reserves   12345000
Adjustment 2: Amounts paid as bonus, dividends, etc. Can be either cash or stocks 23232000
Adjustment 3: Other Specify the adjustment Other comprehensive income
Amount of Adjustment 3: In dollars 1457000
Adjustment 4: Appropriations   2986000
Net Balance of Unappropriated Retained Earnings for Current Year This years 4th Quarter Schedule B-1 Account 2900 minus 2990 9815979
Personnel expenses (Salary) for Traffic Solicitors on P-10 Account 33 Broken out from system Schedule P-6, Line 7 8128000

1/ Includes charges for communications facilities, navigational aids, air traffic services, meteorological services and other ancillary aviation services provided by foreign governments or governmental associates such as Eurocontrol, ASECNA and COCESNA.

Note: The addition of the Allowances for Depreciation Flight Equipment and Ground Property and Equipment should equal Account 1668 on the 4th quarter Schedule B-1.

SAMPLE COMMA SEPARATE VALUES RECORD LAYOUT

ZQ,2010,20345700,138675000,6450000,10346000,9458000,1534070,1250800,1589000,1658500,37034000,12345000,23232000,Other comprehensive income, 1457000,2986000,9815979, 8128000