d o t logoUnited States Department of Transportation
transtats logo
Advanced Search
Data Tools
: Schedule P-5.2
   Database Profile   Data Tables   Table Profile
Latest Available Data: September 2017All Rows Shown
Field NameDescription
Flying Operations
PilotFlyOps51230 - Pilots And Copilots (000)Analysis
OthFltFlyOps51240 - Other Flight Personnel (000)Analysis
TrainFlyOps51281 - Trainees And Instructors (000)Analysis
PersExpFlyOps51360 - Personnel Expenses (000)Analysis
ProFlyOps51410 - Professional And Technical Fees And Expenses (000)Analysis
InterchgFlyOps51437 - Aircraft Interchange Charges (000)Analysis
FuelFlyOps51451 - Aircraft Fuel (000)Analysis
OilFlyOps51452 - Aircraft Oil (000)Analysis
RentalFlyOps51470 - Rentals (000)Analysis
OtherFlyOps51530 - Other Supplies (000)Analysis
InsFlyOps51551 - Insurance Purchased - General (000)Analysis
BenefitsFlyOps51570 - Employee Benefits And Pensions (000)Analysis
IncidentFlyOps51580 - Injuries, Loss, And Damage (000)Analysis
PayTaxFlyOps51680 - Taxes - Payroll (000)Analysis
OthTaxFlyOps51690 - Taxes - Other Than Payroll (000)Analysis
OtherExpFlyOps51710 - Other Expenses (000)Analysis
TotFlyOps51990 - Total Flying Operations (000)Analysis
Direct Maintenance - Flight Equipment
AirframeLabor52251 - Labor - Airframes (000)Analysis
EngineLabor52252 - Labor - Aircraft Engines (000)Analysis
AirframeRepair52431 - Airframe Repairs (000)Analysis
EngineRepairs52432 - Aircraft Engine Repairs (000)Analysis
InterchgCharg52437 - Aircraft Interchange Charges (000)Analysis
AirframeMaterials52461 - Materials - Airframes (000)Analysis
EngineMaterials52462 - Materials - Aircraft Engines (000)Analysis
AirframeAllow52721 - Airworthiness Allowance Provisions - Airframes (000)Analysis
AirframeOverhauls52723 - Airframe Overhauls Deferred, Credit (-) (000)Analysis
EngineAllow52726 - Airworthiness Allowance Provisions - Aircraft Engines (000)Analysis
EngineOverhauls52728 - Aircraft Engine Overhauls Deferred, Credit (-) (000)Analysis
TotDirMaint52780 - Total Direct Maintenance - Flight Equipment (000)Analysis
Applied Maintenance Burden - Flight Equipment
ApMtBurden52796 - Applied Maintenance Burden - Flight Equipment (000)Analysis
TotFltMaintMemo52990 - Total Flight Equipment Maintenance (000)Analysis
Net Obsolescence And Deterioration - Expendable Parts
NetObsolParts70739 - Net Obsolescence And Deterioration - Expendable Parts (000)Analysis
Depreciation - Flight Equipment
AirframeDep70751 - Airframes (000)Analysis
EngineDep70752 - Aircraft Engines (000)Analysis
PartsDep70753 - Airframe Parts (000)Analysis
EngPartsDep70754 - Aircraft Engine Parts (000)Analysis
OthFltEquipDep70755 - Other Flight Equipment (000)Analysis
OthFltEquipDepGrpI70756 - Total Depreciation (7075.1 - 7075.5) (000)Analysis
Amortization Flight Equipment
FltEquipAExp70761 - Amortization Expense - Capital Leases - Flight Equipment (000)Analysis
Expense Of Interchange Aircraft
FlyOpsExpIA70981 - Flying Operations (000)Analysis
Aircraft Operating Expense (Direct Operating Expense)
TotAirOpExpenses70989 - Total Aircraft Operating Expense (Direct Operating Expense) (000)Analysis
Other Depreciation and Amortization (Non-Flight Equipment)
DevNPreopExp70741 - Amortization - Developmental And Preop. Expense (000)Analysis
OthIntangibles70742 - Amortization - Other Intangibles (000)Analysis
EquipNHangarDep70758 - Depreciation - Maintenance Equipment And Hangars (000)Analysis
GPropDep70759 - Depreciation - General Ground Property (000)Analysis
CapLeasesDep70762 - Amortization - Capital Leases (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