d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
Air Carrier Financial : Schedule P-7
   Data Tables   Table Contents
Download Instructions  
Latest Available Data: September 2017
Select all fields   % Missing in table Documentation Terms
Field Name  Description  Support Table 
Direct Operating Expense - Aircraft Operating Expense
AirOpExpense00020 - Total Aircraft Operating Expense (Direct Operating Expense) (000) 
Indirect Operating Expense - Passenger Service Expense
FlAttExpense00050 - Flight Attendant (000) 
FoodExpense00060 - Food (000) 
OthInFlExpense00070 - Other Inflight (000) 
PaxSvcExpense00080 - Total Passenger Service Expense (000) 
Indirect Operating Expense - Aircraft Servicing Expense
LineSvcExpense00100 - Line Servicing (000) 
ControlExpense00110 - Control (000) 
LandingFees00120 - Landing Fees (000) 
AirSvcExpense00130 - Total Aircraft Servicing Expense (000) 
Indirect Operating Expense - Traffic Servicing Expense
TrafficExpPax00150 - Directly Assignable To Passenger (000) 
TrafficExpCargo00160 - Directly Assignable To Baggage And Cargo (000) 
TrafficExpOth00170 - Not Directly Assignable (000) 
TrafficExpense00180 - Total Traffic Servicing Expense (000) 
Indirect Operating Expense - Reservation And Sales Expense
ResExpPax00200 - Directly Assignable To Passenger (000) 
ResExpCargo00210 - Directly Assignable To Cargo (000) 
ResExpOth00220 - Not Directly Assignable (000) 
ResExpense00230 - Total Reservation And Sales Expense (000) 
Indirect Operating Expense - Advertising And Publicity Expense
AdExpPax00250 - Directly Assignable To Passenger (000) 
AdExpCargo00260 - Directly Assignable To Cargo (000) 
AdExpInst00270 - Institutional Advertising (000) 
AdExpense00280 - Total Advertising And Publicity Expense (000) 
Indirect Operating Expense - General And Administrative Expense
AdminExpense00290 - General And Administrative Expense (000) 
Indirect Operating Expense - Depreciation Expense - Maintenance Equipment
DeprExpMaint00340 - Depreciation Expense - Maintenance Equipment (000) 
Indirect Operating Expense - Amortization - Other Than Flight Equipment
Amortization00350 - Amortization (Other Than Flight Equipment) (000) 
Transport Related Expense
TransportExp00370 - Transport Related Expense (000) 
Total Operating Expense
TotalOpExpense00380 - Total Operating Expense (000) 
Other
MaintPropEquip00310 - Maintenance-Ground Property And Equipment (000) 
DeprPropEquip00320 - Depreciation-Ground Property And Equipment (000) 
MaintDepr00330 - Total Maintenance And Depreciation - Ground (000) 
SvcSalesOpExp00360 - Total Servicing, Sales And General Operating Expenses (000) 
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