Number 288 - Electronic Submission of Air Carrier Reports
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
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 NAME | DATA TYPE | FIELD LENGTH |
---|---|---|
B-7 | Alpha/Numeric | 3 |
Air Carrier Name | Alpha | Unlimited |
Year | Numeric | 4 |
Month Ended | Numeric | 2 |
DATA COLUMNS | ||
Year of First Delivery (airframe) | Numeric | 4 |
Airframe Manufacturers serial Number | Alpha/Numeric | Unlimited |
Date Acquired or Retired | MMDDYYYY | 8 |
Acquisition or Retirement A or R | Alpha | 1 |
Airframe License Number | Alpha/Numeric | Unlimited |
Number of Engines Acquired/Retired | Numeric | up to 4 |
Type, Model, and Cabin Design | Alpha/Numeric | Unlimited |
Maximum Seating Capacity | Numeric | up to 4 |
Cost | Numeric | Unlimited |
Amortized/Depreciation Cost | Numeric | Unlimited |
Realization | Numeric | Unlimited |
Acquired From/Disposition | Alpha | Unlimited |
Type of Ownership/Lease | Alpha | 1 |
Operating Status | Alpha | 1 |
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 NAME | DATA TYPE | FIELD LENGTH |
---|---|---|
B-43 | Alpha/Numeric | 4 |
Air Carrier Name | Alpha | unlimited |
Date | MMDDYYYY | 8 |
DATA COLUMNS | ||
Year of First Delivery (airframe) | Numeric | 4 |
Airframe Manufacturers Serial Number | Alpha/Numeric | Unlimited |
Airframe License Number | Alpha/Numeric | Unlimited |
Date Acquired | MMDDYYYY | 8 |
Usual Seat Configuration | Numeric | up to 4 |
Number of Aircraft Engines (By Type) | Numeric | up to 5 |
Manufacturer | Alpha | Unlimited |
Type, Model, and Cabin Design | Alpha/Numeric | Unlimited |
Available Capacity (Weight) | Numeric | Unlimited |
Acquired Cost or Capitalized Value | Numeric | Unlimited |
Allowance for Depreciation or Amortization | Numeric | Unlimited |
Depreciated Cost or Amortized Value | Number | Unlimited |
Estimated Residual Value | Numeric | Unlimited |
Estimated Depreciable or Amortizable Life Expressed in Months | Numeric | 3 |
Type of Ownership/Lease | Alpha | 1 |
Operating Status | Alpha | 1 |
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.