Emissions Status: Data Fields Explained

Refer to the below for a list of field names and their corresponding description in the Emissions Status table.

Field Name

Name in Database

Type

Description

Carrier Code

CARRIER_CODE

VARCHAR (16777216)

This field contains a carrier designator code assigned by either:

·       IATA (International Air Transport Association)

·       ICAO (International Civil Aviation Organization)

·       OAG (Controlled duplicate designators)

Service Suffix

SERVICE_SUFFIX

VARCHAR (16777216)

A code assigned by the administrating carrier for operational purposes.

Flight Number

FLIGHT_NUMBER

VARCHAR (16777216)

The four-digit flight number of the leg.

Departure Airport

DEPARTURE_AIRPORT

VARCHAR (16777216)

The departure port code as assigned by IATA e.g. JFK.

 

Arrival Airport

ARRIVAL_AIRPORT

VARCHAR (16777216)

The arrival port code as assigned by IATA e.g. LAX.

 

Schedule Departure Date

SCHEDULED_DEPARTURE_DATE

VARCHAR (16777216)

The schedule departure date that the operation departs in YYYY-MM-DD

Aircraft Type

AIRCRAFT_TYPE

VARCHAR (16777216)

IATA 3-character designator for the aircraft/equipment type code. E.g. CR1

 

Aircraft Registration Number

AIRCRAFT_REGISTRATION_NUMBER

VARCHAR (16777216)

The registration number of the aircraft e.g. N153PQ

Estimated Fuel Burn Taxi Out Tonnes

ESTIMATED_FUEL_BURN_TAXI_OUT_TONNES

FLOAT

An estimation in of the m the terminal

Estimated Fuel Burn Takeoff Tonnes

ESTIMATED_FUEL_BURN_TAKEOFF_TONNES

FLOAT

 

An estimation of the amount of fuel consumed in tonnes when the aircraft is taking off from the runway

Estimated Fuel Burn Climb Out Tonnes

ESTIMATED_FUEL_BURN_CLIMBOUT_TONNES

FLOAT

 

An estimation of the amount of fuel consumed in tonnes when the aircraft is climbing to cruising altitude after take-off

Estimated Fuel Burn Cruise Tonnes

ESTIMATED_FUEL_BURN_CRUISE_TONNES

FLOAT

 

An estimation of the amount of fuel consumed in tonnes when the aircraft is at cruising altitude after climbing out

Estimated Fuel Burn Approach Tonnes

ESTIMATED_FUEL_BURN_APPROACH_TONNES

FLOAT

 

An estimation of the amount of fuel consumed in tonnes when the aircraft is dropping from cruising altitude to landing

Estimated Fuel Burn Taxi in Tonnes

 

ESTIMATED_FUEL_BURN_TAXI_IN_TONNES

FLOAT

 

An estimation of the amount of fuel consumed in tonnes when the aircraft is taxing from the runway to the terminal

Estimated Fuel Burn Total Tonnes

ESTIMATED_FUEL_BURN_TOTAL_TONNES

FLOAT

 

The total estimated fuel consumed in tonnes during the flight operation

Estimated CO2 Taxi Out Tonnes

ESTIMATED_CO2_TAXI_OUT_TONNES

FLOAT

An estimation of the amount of CO2 in tonnes emitted when the aircraft is taxing out to the runway from the terminal

Estimated CO2 Take Off Tonnes

ESTIMATED_CO2_TAKEOFF_TONNES

FLOAT

An estimation of the amount of CO2 in tonnes emitted when the aircraft is taking off from the runway

Estimated CO2 Climb Out Tonnes

ESTIMATED_CO2_CLIMBOUT_TONNES

FLOAT

An estimation of the amount of CO2 in tonnes emitted when the aircraft is climbing to cruising altitude after take-off

Estimated CO2 Cruise Tonnes

ESTIMATED_CO2_CRUISE_TONNE

FLOAT

An estimation of the amount of CO2 in tonnes emitted when the aircraft is at cruising altitude after climbing out

Estimated CO2 Approach Tonnes

ESTIMATED_CO2_APPROACH_TONNES

FLOAT

An estimation of the amount of CO2 in tonnes emitted when the aircraft is dropping from cruising altitude to landing

Estimated CO2 Taxi in Tonnes

ESTIMATED_CO2_TAXI_IN_TONNE

FLOAT

An estimation of the amount of CO2 in tonnes emitted when the aircraft is taxing in from the runway to the terminal

Estimated CO2 Total Tonnes

ESTIMATED_CO2_TOTAL_TONNES

FLOAT

The total estimated CO2 emitted in tonnes during the flight operation

 

Missing Reference Flight Times

MISSING_REFERENCE_FLIGHT_TIMES

BOOLEAN

Indicates when the flight instance is missing the historic flight times on this route needed for the fuel burn consumption and CO2 emission calculation.