d o t logoUnited States Department of Transportation
transtats logo
Advanced Search
Data Tools
: Schedule P-5.1
   Database Profile   Data Tables   Table Profile
Latest Available Data: September 2017All Rows Shown
Field NameDescription
Flying Operations - Less Rentals
Pilotexpense00030 - Flying Operations - Pilot And Copilot (000)Analysis
AircraftFuel00040 - Flying Operations - Aircraft Fuel And Oil (000)Analysis
OtherExpenses00050 - Flying Operations - Other (000)Analysis
TotalDirectLessRent00060 - Total Flying Operations - Less Rentals (000)Analysis
Maintenance00070 - Maintenance - Flight Equipment (000)Analysis
Depreciation And Rental
DepandRental00080 - Depreciation And Rental - Flight Equipment (000)Analysis
Direct Expense (Aircraft Operating Expense )
TotalDirect00090 - Total Direct Expense (Aircraft Operating Expense) (000)Analysis
Indirect Expense
FlightAttendants00110 - Flight Attendant Expense (000)Analysis
Traffic00120 - Traffic Related Expense (000)Analysis
Departure00130 - Departure Related Expense (Station) (000)Analysis
Capacity00140 - Capacity Related Expense (000)Analysis
TotalIndirect00150 - Total Indirect Expense (000)Analysis
Total Operating Expense
TotalOpExpense00160 - Total Operating Expense (000)Analysis
Traffic Elements
TotalAirHoursZ6500 - Total Aircraft Airborne Hours (000) - The time the aircraft leaves the ground until the time it touches the ground again.Analysis
AirDaysAssignZ8100 - Aircraft Days Assigned (000) - The number of days the aircraft (owned or leased) is available for service.Analysis
AirFuelIssuedZ9210 - Aircraft Fuel Issued in gallons (000) - The amount of fuel issued during the reporting period for revenue and non-revenue flights.Analysis
Aircraft Information
AircraftConfigAircraft ConfigurationAnalysis
AircraftGroupAircraft GroupAnalysis
AircraftTypeAircraft TypeAnalysis
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.Analysis
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.Analysis
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. 
CarrierNameCarrier Name 
UniqCarrierEntityUnique Entity for a Carrier's Operation Region.Analysis
CarrierRegionCarrier's Operation Region. Carriers Report Data by Operation Region 
CarrierGroupNewCarrier Group NewAnalysis
CarrierGroupCarrier Group Code. Used in Legacy AnalysisAnalysis
Time Period Information
QuarterQuarter (1-4)Analysis
All Rows Shown