d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
Air Carrier Financial : Schedule P-5.1
   Data Tables   Table Contents
Download Instructions  
Latest Available Data: June 2018
Select all fields   % Missing in table Documentation Terms
Field Name  Description  Support Table 
Flying Operations - Less Rentals
Pilotexpense00030 - Flying Operations - Pilot And Copilot (000) 
AircraftFuel00040 - Flying Operations - Aircraft Fuel And Oil (000) 
OtherExpenses00050 - Flying Operations - Other (000) 
TotalDirectLessRent00060 - Total Flying Operations - Less Rentals (000) 
Maintenance
Maintenance00070 - Maintenance - Flight Equipment (000) 
Depreciation And Rental
DepandRental00080 - Depreciation And Rental - Flight Equipment (000) 
Direct Expense (Aircraft Operating Expense )
TotalDirect00090 - Total Direct Expense (Aircraft Operating Expense) (000) 
Indirect Expense
FlightAttendants00110 - Flight Attendant Expense (000) 
Traffic00120 - Traffic Related Expense (000) 
Departure00130 - Departure Related Expense (Station) (000) 
Capacity00140 - Capacity Related Expense (000) 
TotalIndirect00150 - Total Indirect Expense (000) 
Total Operating Expense
TotalOpExpense00160 - Total Operating Expense (000) 
Traffic Elements
TotalAirHoursZ6500 - Total Aircraft Airborne Hours (000) - The time the aircraft leaves the ground until the time it touches the ground again. 
AirDaysAssignZ8100 - Aircraft Days Assigned (000) - The number of days the aircraft (owned or leased) is available for service. 
AirFuelIssuedZ9210 - Aircraft Fuel Issued in gallons (000) - The amount of fuel issued during the reporting period for revenue and non-revenue flights. 
Aircraft Information
AircraftConfigAircraft ConfigurationGet Lookup Table
AircraftGroupAircraft GroupGet Lookup Table
AircraftTypeAircraft TypeGet Lookup Table
Carrier Information
AirlineIDAn identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation.Get Lookup Table
UniqueCarrierUnique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years.Get Lookup Table
UniqueCarrierNameUnique Carrier Name. When the same name has been used by multiple carriers, a numeric suffix is used for earlier users, for example, Air Caribbean, Air Caribbean (1). 
CarrierCode assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code.Get Lookup Table
CarrierNameCarrier Name 
UniqCarrierEntityUnique Entity for a Carrier's Operation Region.Get Lookup Table
CarrierRegionCarrier's Operation Region. Carriers Report Data by Operation RegionGet Lookup Table
CarrierGroupNewCarrier Group NewGet Lookup Table
CarrierGroupCarrier Group Code. Used in Legacy AnalysisGet Lookup Table
Time Period Information
YearYear 
QuarterQuarter (1-4)Get Lookup Table