BTS | e-Submit | FORM 41 FINANCIAL DATA B-1, B1-1, P1.1, P1.2, P5.1, P5.2, P6, P7

United States Department of Transportation

ESubmit User Guide

FORM 41 FINANCIAL DATA B-1, B1-1, P1.1, P1.2, P5.1, P5.2, P6, P7

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – Ivy.Harrison@dot.gov.

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – ivy.harrison@dot.gov.

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – ivy.harrison@dot.gov.

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – ivy.harrison@dot.gov.

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – ivy.harrison@dot.gov.

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – ivy.harrison@dot.gov.

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – ivy.harrison@dot.gov.

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2024

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, Ivy Harrison, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – ivy.harrison@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 and Configuration	Character	4	Reported on P-5.1, P-5.2 Only	0000, 9999
Account Code	Character	5		0014A, 10100
Frequency	Numeric	1	1, 2, 3 or 4 see below	2
Quarter Ending Year	Character	4	ccyy	2010
Quarter Ending Month	Character	2	mm = month of quarter ending 1^st Quarter =03 2^ndQuarter =06 3^rd Quarter =09 4^th Quarter =12	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

Frequency definitions:

1 = monthly filing
2 = quarterly filing
3 = semi-annual filing
4 = annual filing