E-Filing Instructions

Directive 307 E-filing financials instructions.doc

Report of Financial and Operation Statistics for Large Certified Air Carriers

E-Filing Instructions

OMB: 2138-0013

Document [doc]
Download: doc | pdf




Part 241 - Form 41

P-1a Interim Operations Report


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-1(a), Interim Operations Report, is estimated to be approximately 1 hour per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


REQUIREMENTS


RECORD DESCRIPTION: P-1a Interim Operations Report - Group I+, II & III



Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4


P01A

Carrier Code

Character

3


3Z

Entity Region

Character

1


D

Aircraft Type

Character

4

P-5.1, P-5.2

0000, 9999

Account Code

Character

5


0014A, 10100

Frequency

Numeric

1


2

Year

Character

4


2010

Month

Character

2


12

Gain or Loss

Numeric

---


2282243, -5645


RECORD FORMAT:

The P-1a Interim Operations reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003-F41-P-1a.csv


Sample Record Format:


P01A,YV,S,0000,39010,1,2010,06,-68401383


Part 241 - Form 41

P-12a Fuel Cost and Consumption


OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-12(a), Fuel Consumption by Type of Service and Entity, is estimated to be approximately 4 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


REQUIREMENTS


RECORD DESCRIPTION: P-12a – Fuel Cost and Consumption Report - Group I+, II & III




Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4


P12A

Carrier Code

Character

3


3Z

Entity Region

Character

1


D

Aircraft Type

Character

4

Reported on P-5.1, P-5.2 only

0000

Account Code

Character

5


0014A, 10100

Frequency

Numeric

1


2

Year

Character

4


2010

Month

Character

2


12

Gain or Loss

Numeric

---


2282243, -5645



RECORD FORMAT:

The P-12a – Fuel Cost and Consumption reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003-F41-P-12A.csv


Sample Record Format:


P-12a Fuel Cost and Consumption

P12A,3Z,S,0000,0008A,1,2010,06,213786

P12A,3Z,S,0000,0008B,1,2010,06,2208410

P12A,3Z,S,0000,0008C,1,2010,06,820818


Account Code

A = Gallons

B = Cost

C = Gallons not Paid for




PART 241 – Form 41

Form A Certification


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule A, Certification is estimated to be approximately 15 minutes per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


REQUIREMENTS


RECORD DESCRIPTION/INSTRUCTIONS: Form A Certification


A certification statement is required identifying an appropriate official of the reporting carrier. The certification statement will read:


Period ended:


I, (Name) and (Title), of (Carrier Name), do certify that all schedules and supporting documents which are submitted herewith or have been submitted heretofore as parts of this report filed for the indicated period, have been prepared under my direction; that I have carefully examined them and declare that they correctly reflect the accounts and records of the company, and to the best of my knowledge and belief are a complete and accurate statement, after adjustments to reflect full accruals, of the operating revenues and expenses, income items, assets, liabilities, capital, retained earnings, and operating statistics for the periods reported in the financial schedules, the Schedule T-100 Traffic, and if applicable, the Passenger Origin-Destination Survey; that the various items herein reported were determined in accordance with the Code of Federal Regulations for Large Certificated Air Carriers as prescribed by the Department of Transportation; and that the data contained herein are reported on a basis consistent with that of the preceding report except as specifically noted in the financial and statistical statements.


Date:


Signature:


Name (Please Print or Type):


Title 18 U.S.C. Sec. 1001, Crimes and Criminal Procedures, makes it a criminal offense subject-to a maximum fine of $10,000 or imprisonment for not more than 5 years, or both, to knowingly and willfully make or cause to be made any false or fraudulent statements or representation in any matter within jurisdiction of any agency of the United States.


The Confidential Information Protection and Statistical Efficiency Act 2002 (44 USC 3501), requires a statistical agency to clearly identify information it collects for non-statistical purposes. BTS hereby notifies the respondents and the public that BTS uses the information it collects under this OMB approval for non-statistical purposes including, publication of both respondent’s identity and it’s data, submission of the information to agencies outside BTS for review, analysis and possible use in regulatory and other administrative matters.


Per quarter, it can take each air carrier between 30 and 300 hours to complete the required financial reports and between 6 and 18 hours to complete the required T-100 monthly traffic reports.




RECORD FORMAT:


Once signed, the Form A Certification must be published as an electronic “portable document format” file format, for uploading to the eSubmit application.


The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension. You must have Adobe Reader software downloaded on your computer in order to “save as/print” your document as a ‘pdf’ file.


While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


Suggested file name: XX201003- F41-A-Cert.pdf



FORM 41 FINANCIAL DATA

B-1, B1-1, P1.1, P1.2, P5.1, P5.2, P6, P7



OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule B-1.1, Balance Sheet is estimated to be approximately 2 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule B-1, Balance Sheet is estimated to be approximately 7 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


OMB NO: 2138-0013

EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-1.1, Statement of Operations, is estimated to be approximately 2 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.







OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-1.2 Statement of Operations, is estimated to be approximately 7 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.



OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-5.1, Aircraft Operating Expenses, is estimated to be approximately 2 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-5.2, Aircraft Operating Expenses, is estimated to be approximately 15 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-6, Operating Expenses by Objective Grouping, is estimated to be approximately 7 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.

OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-7, Operating Expenses by Functional Grouping, is estimated to be approximately 10 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.



REQUIREMENTS


RECORD DESCRIPTION: Form 41 Financials – DB10 Collection



Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4


B010

Carrier Code

Character

3


3Z

Entity Region

Character

1


D

Aircraft Type

Character

4

(P-5.1, P-5.2)

0000, 9999

Account Code

Character

5


0014A, 10100

Frequency

Numeric

1


2

Year

Character

4


2010

Month

Character

2


12

Gain or Loss

Numeric

---


2282243, -5645


RECORD FORMAT:

The Form 41 Financials – DB10 Collection reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003-DB10.csv




Sample Record Format:


B-1 B010 Balance Sheet – Liabilities & Stockholders Equity - Group I+, II & III

B010,3Z,D,0000,20250,2,2010,12,-461395


B-1.1 B011 Balance Sheet – Group I-

B011,SI,D,0000,00230,3,2010,12,54232


P-1.1 P011 Profit and Loss Statement – Group I-

P011,SI,D,0000,00130,3,2010,12,54232


P-1.2 P012 Profit and Loss Statement - Group I+, II & III

P012,3Z,D,0000,39190,2,2010,12,-850


P-5.1 P051 Aircraft Operating Expenses – Group I+, I-

P051,XP,D,9999,Z9210,2,2010,03,399134


P-5.2 P052 Aircraft Operating Expenses – Group II & III

P052,AA,D,6171,51990,2,2010,03,2986314


P-6 P060 Operating Expenses by Objective Grouping - Group I+, II & III

P060,3Z,D,0000,00320,2,2010,12,359199


P-7 P070 Operating Expenses by Functional Grouping - Group III

P070,AA,D,0000,00130,2,2010,12,359199



PART 241 – Form 41

B-12 Statement of Changes in Financial Position


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule B-12, Statement of Changes in Financial Position, is estimated to be approximately 5 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


REQUIREMENTS


RECORD DESCRIPTION/INSTRUCTIONS: B-12 Statement of Changes in Financial Position


For the B-12, Cash Flow Statement, it is freeform depending on each carrier’s operations and is a bridge between the B-1 Balance Sheet and the P-1.2 Statement of Operations (Income Statement).


RECORD FORMAT:


The PART 241 – B-12 Statement of Changes in Financial Position must be published as an electronic “portable document format” file format, for uploading to the eSubmit application.


The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension. You must have Adobe Reader software downloaded on your computer in order to “save as/print” your document as a ‘pdf’ file.


While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


Suggested file name: XX201003- F41-B-12.pdf




Part 241 - Form 41

B-7 Airframe and Aircraft Engine Acquisitions and Retirements


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule B-7, Airframe and Aircraft Engine Acquisitions and Retirements, is estimated to be approximately 7 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


REQUIREMENTS


RECORD DESCRIPTION: B-7 – Airframe and Aircraft Engine Acquisitions and Retirements - Group II & III



Field Description

Data Type

Length

Comments

Sample Data

Form Type

Character

3


B-7

Air Carrier Code

Character

3


UA

Year

Numeric

ccyy

2010

Month Ended

Numeric

mm


12

Year of First Airframe Delivery

Numeric

ccyy

1989

Airframe Manufacturer Serial no.

Character

20


87654321

Date Acquired or Retired

Numeric

ccyymmdd


20090131

Acquisition or Retirement Code

Character

1


R or A

Airframe License Number

Character

8


N000XX

Number of Aircraft Engines Acquired/Retired

Character

5


2 GE

Aircraft Type Code

Numeric

4


6141

Type, Model and Cabin Design

Character

25


Boeing B-737-8 PAX

Usual Seat Configuration

Numeric

4


76

Acquired Cost or Capitalized Value

Numeric

15


12345678

Depr. Cost or Amortized Value

Numeric

15


23232323

Realization Value

Numeric

15


45454545

Acquired From / Disposition

Character

50


Sold to ABC Leasing Inc

Owned/Lease Type

Character

1


O

Operating Status

Character

1


Y


RECORD FORMAT:

The B-7 – Airframe and Aircraft Engine Acquisitions and Retirements reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003-B7.csv


Sample Record Format:


B-7,UA,2010,12,198990131,87654321,20090131,R,N000XX,2 GE,6141,Boeing B-737-8 PAX,76,12345678,23232323,45454545,Sold to ABC Leasing Inc,O,Y


Leased Type: a = Capital Lease, b = Operating Lease, O = Owned


Operating Status: Y = Yes, N = Not operating



Part 241 - Form 41

B-43 Inventory of Airframes and Aircraft Engines


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule B-43, Inventory of Airframes and Aircraft Engines, is estimated to be approximately 8 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.



REQUIREMENTS


RECORD DESCRIPTION: B43 – Inventory of Airframes and Aircraft Engines - Group I-, I+, II & III



Field Description

Data Type

Length

Comments

Sample Data

Form Type

Character

4


B-43

Air Carrier Code

Character

3


UA

Year

Numeric

ccyy


2011

Month Ended

Numeric

mm


12

Year of First Airframe Delivery

Numeric

ccyy

2010

Airframe Manufacturer Serial no.

Character

20


1191

Airframe License Number

Character

8


N000XX

Date Acquired or Placed in Service

Numeric

ccyymmdd


20100101

Usual Seat Configuration

Numeric

4


124

Number of Aircraft Engines

Character

5

Engines by Type

2 GE

Manufacturer

Character

50


Airbus Industrie

Aircraft Type Code

Numeric

4


6981

Type, Model and Cabin Design

Character

25


A-319-PSGR

Available Capacity

Numeric

12

Capacity in pounds

35100

Acquired Cost or Capitalized Value

Numeric

15


12345678

Allowance for Depr. or Amortization

Numeric

15


123456

Depr. Cost or Amortized Value

Numeric

15


23232323

Estimated Residual Value

Numeric

15


45454545

Est. Depreciation or Amortizable Life

Numeric

3


300

Owned/Lease Type

Character

1


O

Operating Status

Character

1


Y


RECORD FORMAT:

The B43 – Inventory of Airframes and Aircraft Engines reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003-B43.csv


Sample Record Format:


B-43,UA,2011,12,2010,1191,N000XX,20100101,124,2GE,Airbus Industries,6981,A-319 PSGR,35100,12345678,123456,23232323,

45454545,300,O,Y



Leased Type: a = Capital Lease, b = Operating Lease, O = Owned


Operating Status: Y = Yes, N = Not operating




Part 241 - Form 41

P-2 Notes to BTS Form 41 Reports


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-2, Notes to BTS Form 41 Report, is estimated to be approximately 4 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


REQUIREMENTS


RECORD DESCRIPTION/INSTRUCTIONS: P-2 Notes to BTS Form 41 Report


For the P-2 Notes, this report is a narrative document that explains the Air Carrier’s Form 41 Financials.



RECORD FORMAT:


The P-2 Notes to BTS Form 41 Report must be published as an electronic “portable document format” file format, for uploading to the eSubmit application.


The portable document format file MUST BE indicated when naming the file, by using the letters [PDF] or [pdf] following the file name, as the file name extension. You must have Adobe Reader software downloaded on your computer in order to “save as/print” your document as a ‘pdf’ file.


While the file name is flexible and may be determined by the individual air carrier, the portable document format (pdf) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


Suggested file name: XX201003- F41-P-2notes.pdf


Part 241 - Form 41

P-2 Passenger Facility Charge Report


REQUIREMENTS


RECORD DESCRIPTION: P-2 Passenger Facility Charge Report



Field Description

Data Type

Length

Comments

Sample Data

Airline ID

Character

5

DOT Assigned

12345

Carrier Code

Character

3

IATA or DOT Assigned

XX

Year of Data

Included in the Report

Numeric

4

Year (CCYY)

2010

Month of Quarter Ending Data Included in the Report

Numeric

2

Month (MM)

Qtr 1 = 03 Qtr 3 = 09

Qtr 2 = 06 Qtr 4 = 12

03

Total PFC Liability at Beginning of Period

Numeric

50


9999

Total Amount Collected in Trust for Public Agencies

Numeric

50


9999

Total Amount Remitted to Public Agencies

Numeric

50


9999

Adjustments

Numeric

50

Collection Compensation, PFC Refunds

9999

Total PFC Liability at End of Period

Numeric

50


9999


RECORD FORMAT:

The P-2 Passenger Facility Charge reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003- F41-P-2pfc.csv


Sample Record Format:


12345,XX,2010,03,9999,9999,9999,9999,9999



FORM 41 FINANCIAL DATA

P-10 – Employee Statistics by Labor Category


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule P-10, Employment Statistics by Labor Category, is estimated to be approximately 2 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.



REQUIREMENTS


RECORD DESCRIPTION: P-10 – Employee Statistics by Labor Category Report - Group I+, II & III




Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

4


P100

Carrier Code

Character

3


3Z

Entity Region

Character

1


D

Aircraft Type

Character

4

(P-5.1, P-5.2)

0000

Account Code

Character

5


0014A, 10100

Frequency

Numeric

1


2

Year

Character

4


2010

Month

Character

2


12

Gain or Loss

Numeric

---


2282243, -5645


RECORD FORMAT:

The P-10 – Employee Statistics by Labor Category reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003-F41-P-10.csv


Sample Record Format:


P100,3Z,D,0000,00310,4,2010,12,31


Part 241 - Form 41

T-8 Report of All-Cargo Operations Report


OMB NO: 2138-0013
EXPIRATION DATE: 7/31/2015


Paperwork Reduction Act Burden Statement


A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0013. Public reporting for Schedule T-8, Report of All-Cargo Operations, is estimated to be approximately 2 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.


REQUIREMENTS


RECORD DESCRIPTION: T-8 Report of All-Cargo Operations Report



Field Description

Data Type

Length

Comments

Sample Data

Schedule Item

Character

2

Name of Form

T8

Carrier code

Character

2

IATA code

XX

Airline ID

Numeric

5

Five digit Cardecode

10579

Region

Numeric

3

Certificate of Operations

418 or 401

Account Code

Numeric

5

Account

41990

Frequency

Numeric

1

Annual

4

Year of Data

Included in the Report

Numeric

4

Year (CCYY)

2010

Month of Data

Included in the Report

Numeric

2

Month (MM)

03

Data

Numeric

---

Actual data value

3938455


RECORD FORMAT:

The T-8 Report of All-Cargo Operations Report must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.


The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.


The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.


The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.


Suggested file name: XX201003-F41-T8.csv


Sample Record Format:


T8,JW,10548,418,39050,4,2010,12,4948301


13

File Typeapplication/msword
File TitleeSubmit Record formats for Directive
Authormarianne.seguin
Last Modified ByUSDOT_User
File Modified2015-01-22
File Created2015-01-22

© 2024 OMB.report | Privacy Policy