General

You are here

Number 288 - Electronic Submission of Air Carrier Reports

PDF

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

No. 288
Issue Date: 12/8/08
Effective Date: Immediately
Parts: 217, 234, 241, and 298

This Accounting and Reporting Directive reminds carriers that they can meet their reporting obligation to submit financial, traffic and operating statistical reports to the Bureau of Transportation Statistics (BTS) by transmitting their files via e-mail until BTS establishes an e-filing system over the internet.

Attaching records to e-mails should save the carriers mailing costs and from having to print large number of pages, especially for their Schedule B-7 Airframe and Aircraft Engines Acquisitions and Retirements and Schedule B-43 Inventory of Airframes and Aircraft Engines. For those carriers electing to submit Schedules B-7 or B-43 via electronic means, BTS has added columns to identify owned, capitalized, operating leases, and nonoperating equipment. B-7 and B-43 submissions would be e-mailed to F41financials.support@dot.gov(link sends e-mail)

The e-mail accounts for submitting the various reports are:

T100.support@dot.gov(link sends e-mail)
T100f.support@dot.gov(link sends e-mail)
Ontime.support@dot.gov(link sends e-mail)
Odsurvey.support@dot.gov(link sends e-mail)
F41financials.support@dot.gov(link sends e-mail)
298c.support@dot.gov(link sends e-mail)
Form251.support@dot.gov(link sends e-mail)

Anne Suissa

Anne Suissa
Director
Office of Airline Information

Below are the file formats for submitting Schedules B-7 and B-43.

BTS FORM 41, SCHEDULE B-7, AIRFRAME AND AIRCRAFT ENGINE ACQUISITIONS AND RETIREMENTS

File Description

FIELD NAMEDATA TYPEFIELD LENGTH
B-7Alpha/Numeric3
Air Carrier NameAlphaUnlimited
YearNumeric4
Month EndedNumeric2
 DATA COLUMNS 
Year of First Delivery (airframe)Numeric4
Airframe Manufacturers serial NumberAlpha/NumericUnlimited
Date Acquired or RetiredMMDDYYYY8
Acquisition or Retirement A or RAlpha1
Airframe License NumberAlpha/NumericUnlimited
Number of Engines Acquired/RetiredNumericup to 4
Type, Model, and Cabin DesignAlpha/NumericUnlimited
Maximum Seating CapacityNumericup to 4
CostNumericUnlimited
Amortized/Depreciation CostNumericUnlimited
RealizationNumericUnlimited
Acquired From/DispositionAlphaUnlimited
Type of Ownership/LeaseAlpha1
Operating StatusAlpha1

Codes for Type of Ownership
O - Owned
a - Capital Lease
b - Operating Lease

Codes for Operating Status
N - Nonoperating Equipment
Y Operating Equipment

The data stream listed above shall be reported for each individual airframe.

Data pertaining to aircraft engines are reported in aggregate for each type or model. Leased aircraft engines are reported separately as either Capital Leases or Operating Leases.

File Type: .csv - comma separated variable; all fields must be comma separated.

BTS FORM 41, SCHEDULE B-43, INVENTORY OF AIRFRAMES AND AIRCRAFT ENGINES

File Description

FIELD NAMEDATA TYPEFIELD LENGTH
B-43Alpha/Numeric4
Air Carrier NameAlphaunlimited
DateMMDDYYYY8
 DATA COLUMNS 
Year of First Delivery (airframe)Numeric4
Airframe Manufacturers Serial NumberAlpha/NumericUnlimited
Airframe License NumberAlpha/NumericUnlimited
Date AcquiredMMDDYYYY8
Usual Seat ConfigurationNumericup to 4
Number of Aircraft Engines (By Type)Numericup to 5
ManufacturerAlphaUnlimited
Type, Model, and Cabin DesignAlpha/NumericUnlimited
Available Capacity (Weight)NumericUnlimited
Acquired Cost or Capitalized ValueNumericUnlimited
Allowance for Depreciation or AmortizationNumericUnlimited
Depreciated Cost or Amortized ValueNumberUnlimited
Estimated Residual ValueNumericUnlimited
Estimated Depreciable or Amortizable Life Expressed in MonthsNumeric3
Type of Ownership/LeaseAlpha1
Operating StatusAlpha1

Codes for Type of Ownership
O - Owned
a - Capital Lease
b - Operating Lease

Codes for Operating Status
N - Nonoperating Equipment
Y Operating Equipment

The data stream listed above shall be reported for each individual airframe. Data pertaining to aircraft engines are reported in aggregate for each type or model. Leased aircraft engines are reported separately as either Capital Leases or Operating Leases.

File Type: .csv comma separated variable; all fields must be comma separated.