d o t logoUnited States Department of Transportation

  OST-R > BTS
ESubmit User Guide Report Formats Manage Profile Contact OAI FAQ Log Out

Part 241 - Form 41 P-12a Fuel Cost and Consumption

PDF

OMB NO: 2138-0013

EXPIRATION DATE: 08/31/2018

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, 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, 0014B
Frequency Numeric 1 1, 2, 3 or 4 see below 2
Year Character 4 ccyy 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,0002A,1,2010,06,213786
P12A,3Z,S,0000,0008A,1,2010,06,212454
P12A,3Z,S,0000,0014A,1,2010,06,5456676
P12A,3Z,S,0000,0002B,1,2010,06,78695
P12A,3Z,S,0000,0008B,1,2010,06,2208410
P12A,3Z,S,0000,0014B,1,2010,06,594856
P12A,3Z,S,0000,0002C,1,2010,06,12293
P12A,3Z,S,0000,0008C,1,2010,06,820818
P12A,3Z,S,0000,0014C,1,2010,06,59608

Account Code

A = Gallons
B = Cost
C = Gallons not Paid for

Frequency definitions:

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