d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
: Schedule P-7
   Database Profile   Data Tables   Table Profile
Latest Available Data: September 2017All Rows Shown
Field NameDescription
Direct Operating Expense - Aircraft Operating Expense
AirOpExpense00020 - Total Aircraft Operating Expense (Direct Operating Expense) (000)Analysis
Indirect Operating Expense - Passenger Service Expense
FlAttExpense00050 - Flight Attendant (000)Analysis
FoodExpense00060 - Food (000)Analysis
OthInFlExpense00070 - Other Inflight (000)Analysis
PaxSvcExpense00080 - Total Passenger Service Expense (000)Analysis
Indirect Operating Expense - Aircraft Servicing Expense
LineSvcExpense00100 - Line Servicing (000)Analysis
ControlExpense00110 - Control (000)Analysis
LandingFees00120 - Landing Fees (000)Analysis
AirSvcExpense00130 - Total Aircraft Servicing Expense (000)Analysis
Indirect Operating Expense - Traffic Servicing Expense
TrafficExpPax00150 - Directly Assignable To Passenger (000)Analysis
TrafficExpCargo00160 - Directly Assignable To Baggage And Cargo (000)Analysis
TrafficExpOth00170 - Not Directly Assignable (000)Analysis
TrafficExpense00180 - Total Traffic Servicing Expense (000)Analysis
Indirect Operating Expense - Reservation And Sales Expense
ResExpPax00200 - Directly Assignable To Passenger (000)Analysis
ResExpCargo00210 - Directly Assignable To Cargo (000)Analysis
ResExpOth00220 - Not Directly Assignable (000)Analysis
ResExpense00230 - Total Reservation And Sales Expense (000)Analysis
Indirect Operating Expense - Advertising And Publicity Expense
AdExpPax00250 - Directly Assignable To Passenger (000)Analysis
AdExpCargo00260 - Directly Assignable To Cargo (000)Analysis
AdExpInst00270 - Institutional Advertising (000)Analysis
AdExpense00280 - Total Advertising And Publicity Expense (000)Analysis
Indirect Operating Expense - General And Administrative Expense
AdminExpense00290 - General And Administrative Expense (000)Analysis
Indirect Operating Expense - Depreciation Expense - Maintenance Equipment
DeprExpMaint00340 - Depreciation Expense - Maintenance Equipment (000)Analysis
Indirect Operating Expense - Amortization - Other Than Flight Equipment
Amortization00350 - Amortization (Other Than Flight Equipment) (000)Analysis
Transport Related Expense
TransportExp00370 - Transport Related Expense (000)Analysis
Total Operating Expense
TotalOpExpense00380 - Total Operating Expense (000)Analysis
Other
MaintPropEquip00310 - Maintenance-Ground Property And Equipment (000)Analysis
DeprPropEquip00320 - Depreciation-Ground Property And Equipment (000)Analysis
MaintDepr00330 - Total Maintenance And Depreciation - Ground (000)Analysis
SvcSalesOpExp00360 - Total Servicing, Sales And General Operating Expenses (000)Analysis
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 RegionAnalysis
CarrierGroupNewCarrier Group NewAnalysis
CarrierGroupCarrier Group Code. Used in Legacy AnalysisAnalysis
Time Period Information
YearYear 
QuarterQuarter (1-4)Analysis
All Rows Shown