Field Name Description Support Table
Flying Operations - Less Rentals
Pilotexpense 00030 - Flying Operations - Pilot And Copilot (000)
AircraftFuel 00040 - Flying Operations - Aircraft Fuel And Oil (000)
OtherExpenses 00050 - Flying Operations - Other (000)
TotalDirectLessRent 00060 - Total Flying Operations - Less Rentals (000)
Maintenance
Maintenance 00070 - Maintenance - Flight Equipment (000)
Depreciation And Rental
DepandRental 00080 - Depreciation And Rental - Flight Equipment (000)
Direct Expense (Aircraft Operating Expense )
TotalDirect 00090 - Total Direct Expense (Aircraft Operating Expense) (000)
Indirect Expense
FlightAttendants 00110 - Flight Attendant Expense (000)
Traffic 00120 - Traffic Related Expense (000)
Departure 00130 - Departure Related Expense (Station) (000)
Capacity 00140 - Capacity Related Expense (000)
TotalIndirect 00150 - Total Indirect Expense (000)
Total Operating Expense
TotalOpExpense 00160 - Total Operating Expense (000)
Traffic Elements
TotalAirHours Z6500 - Total Aircraft Airborne Hours (000) - The time the aircraft leaves the ground until the time it touches the ground again.
AirDaysAssign Z8100 - Aircraft Days Assigned (000) - The number of days the aircraft (owned or leased) is available for service.
AirFuelIssued Z9210 - Aircraft Fuel Issued in gallons (000) - The amount of fuel issued during the reporting period for revenue and non-revenue flights.
Aircraft Information
AircraftConfig Aircraft Configuration Get Lookup Table
AircraftGroup Aircraft Group Get Lookup Table
AircraftType Aircraft Type Get Lookup Table
Carrier Information
AirlineID An 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
UniqueCarrier Unique 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
UniqueCarrierName Unique 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).
Carrier Code 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
CarrierName Carrier Name
UniqCarrierEntity Unique Entity for a Carrier's Operation Region. Get Lookup Table
CarrierRegion Carrier's Operation Region. Carriers Report Data by Operation Region Get Lookup Table
CarrierGroupNew Carrier Group New Get Lookup Table
CarrierGroup Carrier Group Code. Used in Legacy Analysis Get Lookup Table
Time Period Information
Year Year
Quarter Quarter (1-4) Get Lookup Table
