wiki

Scope - Flight

Overview

The Flight scope covers individual flight records. Each record represents a single flight leg — one scheduled or operated sector between a departure airport (ADEP) and a destination airport (ADES). The scope captures planned and actual schedule data, aircraft, crew assignments, passenger and cargo loads, fuel, Journey Log entries, Flight Watch updates, and commercial trip information.

This scope is the primary source for operational reporting. Operators use it to monitor on-time performance, analyse route activity, produce crew utilisation summaries, track fuel consumption, and generate invoicing or compliance data at the flight level.


What reports can you build with this scope?

Examples of typical reports operators build with this scope:

  • Flight schedule report — all planned departures and arrivals by date, route, or aircraft

  • On-time performance report — comparison of planned vs. actual BLOFF/BLON times

  • Crew utilisation report — who flew what route, with which aircraft, in a given period

  • Fuel consumption report — actual vs. planned fuel per flight or route

  • Passenger load report — PAX counts, load factors, and gender/infant breakdown per flight

  • Cargo and payload report — cargo, baggage, mail, and total load weights per flight

  • Cancelled/delayed flights report — CNL status, delay codes and reasons

  • Carbon emissions report — estimated CO₂, EU ETS data, and country-specific aviation taxes


Available columns

Columns are the data fields that can appear in your report. When building a report, select the columns most relevant to your analysis.

Many columns share a common naming convention:

  • [Plan] — planned/scheduled value · [JL] — actual value from the Journey Log · [FW] — value from Flight Watch (live tracking) · [Chkl] — checklist item · [W&B] — from Weight & Balance · [Quote] — from the sales Quote

  • [UTC] / [LT] — time zone (UTC or local time) · [DEC] — decimal hours · weight/volume/distance units appear in brackets too ([kg], [lbs], [L], [US Gal], [NM], [km])

  • ADEP — departure airport · ADES — destination airport · ALTN / ALTN2 — alternate airports


Flight identification

Column

Column key

Description

Scope row unique ID

scope_row_unique_id

Internal unique identifier of the report row

Unique ID

unique_id

Unique flight identifier (flight nid)

Trip nid

trip_nid

Internal identifier of the trip

Flight number

flightNo

Flight number

ICAO flight number

flight_no_iaco

Flight number in ICAO format

IATA flight number

flight_no_iata

Flight number in IATA format

Trip number

tripNumber

Trip number this flight belongs to

Trip type

trip_type

Type of trip (e.g. charter, owner, training)

ICAO flight type

ICAOType

ICAO flight type indicator (e.g. scheduled, non-scheduled)

Commercial Flight Number

commercialFlightNo

Commercial (marketing) flight number

Leg No.

leg_no

Leg number within the trip

Commercial trip

commercial

Whether the trip is commercial

Route ICAO

route_icao

Full route of the trip in ICAO format

Trip link

trip_link

Direct link to the trip in Leon

Number of legs in a trip [Plan]

number_of_legs_in_a_trip

Number of legs in the trip, planned

Number of not cancelled legs in a trip

jl_number_of_not_cnl_legs_in_a_trip

Number of non-cancelled legs in the trip

Leg No. without cancelled flights

not_cnl_leg_no_in_a_trip

Leg number within the trip, ignoring cancelled flights

Rule

flight_rules

Flight rules (e.g. IFR, VFR)

Unique leg number

unique_leg_number

Unique leg number

ARCID

arcid

Aircraft identification (ARCID) used in the ATC flight plan

Route / airports

Column

Column key

Description

ADEP ICAO [Plan]

ADEPICAO

ICAO code of the departure airport, planned

ADEP ICAO [JL]

ADEP_ICAO_log

ICAO code of the departure airport, from the Journey Log (actual)

ADEP IATA [Plan]

ADEPIATA

IATA code of the departure airport, planned

ADEP IATA [JL]

ADEP_IATA_log

IATA code of the departure airport, from the Journey Log (actual)

ADEP FAA [Plan]

ADEP_FAA

FAA code of the departure airport, planned

ADEP FAA [JL]

ADEP_FAA_log

FAA code of the departure airport, from the Journey Log (actual)

ADES FAA [Plan]

ADES_FAA

FAA code of the destination airport, planned

ADES FAA [JL]

ADES_FAA_log

FAA code of the destination airport, from the Journey Log (actual)

ADEP [Available Code] [Plan]

ADEP_available_code

Best available code of the departure airport, planned

ADES [Available Code] [Plan]

ADES_available_code

Best available code of the destination airport, planned

ADEP [Available Code] [JL]

ADEP_available_code_log

Best available code of the departure airport, from the Journey Log (actual)

ADES [Available Code] [JL]

ADES_available_code_log

Best available code of the destination airport, from the Journey Log (actual)

ADEP city [Plan]

ADEPCity

City of the departure airport, planned

ADEP city [JL]

ADEP_City_log

City of the departure airport, from the Journey Log (actual)

ADEP name [Plan]

ADEPName

Name of the departure airport, planned

ADEP name [JL]

ADEP_Name_log

Name of the departure airport, from the Journey Log (actual)

ADES ICAO [Plan]

ADESICAO

ICAO code of the destination airport, planned

ADES ICAO [JL]

ADES_ICAO_log

ICAO code of the destination airport, from the Journey Log (actual)

ADES IATA [Plan]

ADESIATA

IATA code of the destination airport, planned

ADES IATA [JL]

ADES_IATA_log

IATA code of the destination airport, from the Journey Log (actual)

ADES city [Plan]

ADESCity

City of the destination airport, planned

ADES city [JL]

ADES_City_log

City of the destination airport, from the Journey Log (actual)

ADES name [Plan]

ADESName

Name of the destination airport, planned

ADES name [JL]

ADES_Name_log

Name of the destination airport, from the Journey Log (actual)

ADEP tags

adepTags

Airport tags of the departure airport

ADES tags

adesTags

Airport tags of the destination airport

ADEP category for aircraft

ADEPCategoryForAircraft

Airport category for this aircraft of the departure airport

ADES category for aircraft

ADESCategoryForAircraft

Airport category for this aircraft of the destination airport

ALTN category for aircraft

ALTNCategoryForAircraft

Airport category for this aircraft of the alternate airport

ALTN2 category for aircraft

ALTN2CategoryForAircraft

Airport category for this aircraft of the second alternate airport

ADEP Category Expiry Date for Aircraft

ADEPCategoryExpiryDateForAircraft

Airport category expiry date for this aircraft of the departure airport

ADES Category Expiry Date for Aircraft

ADESCategoryExpiryDateForAircraft

Airport category expiry date for this aircraft of the destination airport

ADEP Category Expiry Date

ADEPCategoryExpiryDate

Airport category expiry date of the departure airport

ADES Category Expiry Date

ADESCategoryExpiryDate

Airport category expiry date of the destination airport

ALTN Category Expiry Date for Aircraft

ALTNCategoryExpiryDateForAircraft

Airport category expiry date for this aircraft of the alternate airport

ALTN Category Expiry Date

ALTNCategoryExpiryDate

Airport category expiry date of the alternate airport

ALTN2 Category Expiry Date for Aircraft

ALTN2CategoryExpiryDateForAircraft

Airport category expiry date for this aircraft of the second alternate airport

ALTN2 Category Expiry Date

ALTN2CategoryExpiryDate

Airport category expiry date of the second alternate airport

ADEP in Europe Union [Plan]

adep_plan_in_european_union

Whether the airport is in the European Union of the departure airport, planned

ADES in Europe Union [Plan]

ades_plan_in_european_union

Whether the airport is in the European Union of the destination airport, planned

ADEP country code [Plan]

adep_plan_country_code

Country code of the departure airport, planned

ADES country code [Plan]

ades_plan_country_code

Country code of the destination airport, planned

ADEP country name [Plan]

adep_plan_country_name

Country name of the departure airport, planned

ADES country name [Plan]

ades_plan_country_name

Country name of the destination airport, planned

ADEP in Europe Union [JL]

adep_log_in_european_union

Whether the airport is in the European Union of the departure airport, from the Journey Log (actual)

ADES in Europe Union [JL]

ades_log_in_european_union

Whether the airport is in the European Union of the destination airport, from the Journey Log (actual)

ADEP country code [JL]

adep_log_country_code

Country code of the departure airport, from the Journey Log (actual)

ADES country code [JL]

ades_log_country_code

Country code of the destination airport, from the Journey Log (actual)

ADEP country name [JL]

adep_log_country_name

Country name of the departure airport, from the Journey Log (actual)

ADES country name [JL]

ades_log_country_name

Country name of the destination airport, from the Journey Log (actual)

DIV ICAO [FW]

diverted_icao

Diversion airport in ICAO format, from Flight Watch (live movement tracking)

DIV IATA [FW]

diverted_iata

Diversion airport in IATA format, from Flight Watch (live movement tracking)

ADEP fuel supplier

adep_fuel_supplier

Fuel supplier of the departure airport

ADES fuel supplier

ades_fuel_supplier

Fuel supplier of the destination airport

ADEP custom code [Plan]

ADEP_custom_code

Custom code of the departure airport, planned

ADES custom code [Plan]

ADES_custom_code

Custom code of the destination airport, planned

ADEP preferred code [Plan]

ADEP_preferred_code

Preferred code of the departure airport, planned

ADES preferred code [Plan]

ADES_preferred_code

Preferred code of the destination airport, planned

ADEP fuel provider

adep_fuel_provider

Fuel provider of the departure airport

ADES fuel provider

ades_fuel_provider

Fuel provider of the destination airport

Diversion reason [JL]

jl_diversion_reason

Reason for the diversion, from the Journey Log (actual)

Continent ADEP[JL]

jl_start_airport_continent

Continent of the departure airport, from the Journey Log (actual)

Continent ADES[JL]

jl_end_airport_continent

Continent of the destination airport, from the Journey Log (actual)

ALTN ICAO

altn_icao

ICAO code of the alternate airport

ALTN IATA

altn_iata

IATA code of the alternate airport

ALTN [Available Code]

altn_available_code

Best available code of the alternate airport

ALTN city

altn_city

City of the alternate airport

ALTN name

altn_name

Name of the alternate airport

ALTN country code

altn_country_code

Country code of the alternate airport

ALTN country name

altn_country_name

Country name of the alternate airport

Latitude dec ALTN

altn_airport_latitude_dec

Latitude of the alternate airport in decimal degrees

Longitude dec ALTN

altn_airport_longitude_dec

Longitude of the alternate airport in decimal degrees

Latitude ALTN

altn_airport_latitude

Latitude of the alternate airport

Longitude ALTN

altn_airport_longitude

Longitude of the alternate airport

ALTN custom code

altn_custom_code

Custom code of the alternate airport

ALTN preferred code

altn_preferred_code

Preferred code of the alternate airport

ALTN2 ICAO

altn2_icao

ICAO code of the second alternate airport

ALTN2 IATA

altn2_iata

IATA code of the second alternate airport

ALTN2 [Available Code]

altn2_available_code

Best available code of the second alternate airport

ALTN2 city

altn2_city

City of the second alternate airport

ALTN2 name

altn2_name

Name of the second alternate airport

ALTN2 country code

altn2_country_code

Country code of the second alternate airport

ALTN2 country name

altn2_country_name

Country name of the second alternate airport

Latitude dec ALTN2

altn2_airport_latitude_dec

Latitude of the second alternate airport in decimal degrees

Longitude dec ALTN2

altn2_airport_longitude_dec

Longitude of the second alternate airport in decimal degrees

Latitude ALTN2

altn2_airport_latitude

Latitude of the second alternate airport

Longitude ALTN2

altn2_airport_longitude

Longitude of the second alternate airport

ALTN2 custom code

altn2_custom_code

Custom code of the second alternate airport

ALTN2 preferred code

altn2_preferred_code

Preferred code of the second alternate airport

ADEP group [Plan]

adep_airport_group

Airport group of the departure airport, planned

ADES group [Plan]

ades_airport_group

Airport group of the destination airport, planned

ALTN group [Plan]

altn_airport_group

Airport group of the alternate airport, planned

ALTN2 group [Plan]

altn2_airport_group

Airport group of the second alternate airport, planned

T/O ALTN group [Plan]

to_altn_airport_group

Take-off alternate airport group, planned

Latitude ADEP[JL]

jl_start_airport_latitude

Latitude of the departure airport, from the Journey Log (actual)

Latitude ADES[JL]

jl_end_airport_latitude

Latitude of the destination airport, from the Journey Log (actual)

Longitude ADEP[JL]

jl_start_airport_longitude

Longitude of the departure airport, from the Journey Log (actual)

Longitude ADES[JL]

jl_end_airport_longitude

Longitude of the destination airport, from the Journey Log (actual)

Latitude ADEP[Plan]

start_airport_latitude

Latitude of the departure airport, planned

Latitude ADES[Plan]

end_airport_latitude

Latitude of the destination airport, planned

Longitude ADEP[Plan]

start_airport_longitude

Longitude of the departure airport, planned

Longitude ADES[Plan]

end_airport_longitude

Longitude of the destination airport, planned

ADEP preferred code [JL]

jl_adep_preferred_code

Displays the airport code according to the format set in the preferences of the logged-in user.

ADES preferred code [JL]

jl_ades_preferred_code

Displays the airport code according to the format set in the preferences of the logged-in user.

ADEP approved handlers

adep_approved_handlers

Approved handling agents of the departure airport

ADES approved handlers

ades_approved_handlers

Approved handling agents of the destination airport

ADEP RefuelEU

refuel_eu_adep

ReFuelEU regulation applicability of the departure airport

ADES RefuelEU

refuel_eu_ades

ReFuelEU regulation applicability of the destination airport

Aircraft

Column

Column key

Description

Aircraft

registration

Aircraft registration

PAX Capacity

pax_capacity

Passenger seating capacity of the aircraft

Aircraft type

acftType

Aircraft type

ICAO aircraft type

ICAOAcftType

Aircraft type in ICAO format

IATA aircraft type

IATAAcftType

Aircraft type in IATA format

Aircraft handover report [JL]

jl_aircraft_handover_report

Aircraft handover report as recorded in the Journey Log

Aircraft opened defects [JL]

jl_aircraft_opened_defects

Open defects on the aircraft, from the Journey Log (actual)

Aircraft deferred defects [JL]

jl_aircraft_deferred_defects

Deferred defects on the aircraft, from the Journey Log (actual)

Aircraft cover fitted [JL]

jl_aircraft_cover_fitted

Aircraft cover fitted as recorded in the Journey Log

Aircraft cover fitted note [JL]

jl_aircraft_cover_fitted_note

Aircraft cover fitted note as recorded in the Journey Log

Aircraft labels

aircraft_tags

Labels assigned to the aircraft

Aircraft Serial No

aircraft_serial_number

Aircraft serial number

Aircraft Flight Time Target Annual

aircraft_flight_time_target_annual

Annual flight-time target for the aircraft

Aircraft Flight Time Target Monthly

aircraft_flight_time_target_monthly

Monthly flight-time target for the aircraft

Aircraft Engine 1 Serial No

aircraft_engine_1_serial_number

Serial number of engine 1

Aircraft Engine 2 Serial No

aircraft_engine_2_serial_number

Serial number of engine 2

Aircraft Engine 3 Serial No

aircraft_engine_3_serial_number

Serial number of engine 3

Aircraft Engine 4 Serial No

aircraft_engine_4_serial_number

Serial number of engine 4

APU Serial No

aircraft_apu_serial_number

Serial number of the APU

Aircraft prepared Status[Chkl]

checklist_item_aircraft_prepared_status

Checklist record: Aircraft prepared Status

Initial aircraft registration

initial_aircraft_registration

Aircraft registration originally assigned before any change

Initial aircraft type

initial_aircraft_type

Aircraft type originally assigned before any change

Last aircraft change [UTC]

last_aircraft_change

Timestamp of the last aircraft change, in UTC

Aircraft MTOW [kg]

aircraft_mtow_kg

Maximum take-off weight of the aircraft, in kilograms

Aircraft MTOW [lbs]

aircraft_mtow_lbs

Maximum take-off weight of the aircraft, in pounds

Aircraft ICAO Noise Category

aircraft_icao_noise_category

ICAO noise category of the aircraft

Home Base ICAO

acft_home_base_icao

Home base of the aircraft in ICAO format

Aircraft Operator/ICAO code

acft_buyer_name

Displays the content of the 'Operator/ICAO Code' field from the BASIC tab in the aircraft edit section.

Aircraft Table view colour

acft_table_view_colour

Colour of the aircraft in the table view

Scheduled times (Plan)

Column

Column key

Description

Date ADEP [Plan][UTC]

dateUTC

Departure date, planned, in UTC

Date ADEP [Plan][LT]

date_STD_LT

Departure date, planned, in local time

Date ADES [Plan][UTC]

date_STA_UTC

Arrival date, planned, in UTC

Date ADES [Plan][LT]

date_STA_LT

Arrival date, planned, in local time

Day ADEP [Plan][UTC]

dayOfWeekUTC

Day of week of departure, planned, in UTC

Day ADEP [Plan][LT]

day_of_week_STD_LT

Day of week of departure, planned, in local time

Day ADES [Plan][UTC]

day_of_week_STA_UTC

Day of week of arrival, planned, in UTC

Day ADES [Plan][LT]

day_of_week_STA_LT

Day of week of arrival, planned, in local time

STD [UTC]

STDUTC

Scheduled time of departure (off-block), in UTC

STD [LT]

STDLT

Scheduled time of departure (off-block), in local time

STA [UTC]

STAUTC

Scheduled time of arrival (on-block), in UTC

STA [LT]

STALT

Scheduled time of arrival (on-block), in local time

Slots ADEP Time STD [Chkl]

checklist_item_slots_adep_time

Departure slot time (STD)

Slots ADES Time STA [Chkl]

checklist_item_slots_ades_time

Arrival slot time (STA)

Ground time after [Plan]

plan_ground_time_after

Ground time after this flight before the next one, planned

Ground time after [JL]

jl_ground_time_after

Ground time after this flight before the next one, from the Journey Log (actual)

Ground time after [FW]

fw_ground_time_after

Ground time after this flight before the next one, from Flight Watch (live movement tracking)

Ground time before [Plan]

plan_ground_time_before

Ground time before this flight after the previous one, planned

Ground time before [JL]

jl_ground_time_before

Ground time before this flight after the previous one, from the Journey Log (actual)

Ground time before [FW]

fw_ground_time_before

Ground time before this flight after the previous one, from Flight Watch (live movement tracking)

Sunrise ADEP [UTC]

sunrise_adep_utc

Sunrise time at the departure airport, in UTC

Sunset ADEP [UTC]

sunset_adep_utc

Sunset time at the departure airport, in UTC

Sunrise ADEP [LT]

sunrise_adep_lt

Sunrise time at the departure airport, in local time

Sunset ADEP [LT]

sunset_adep_lt

Sunset time at the departure airport, in local time

Sunrise ADES [UTC]

sunrise_ades_utc

Sunrise time at the destination airport, in UTC

Sunset ADES [UTC]

sunset_ades_utc

Sunset time at the destination airport, in UTC

Sunrise ADES [LT]

sunrise_ades_lt

Sunrise time at the destination airport, in local time

Sunset ADES [LT]

sunset_ades_lt

Sunset time at the destination airport, in local time

Actual times (JL & Flight Watch)

Column

Column key

Description

BLOFF [JL][UTC]

JL_STD_UTC

Actual block-off (off-block / departure) time, from the Journey Log (actual), in UTC

BLOFF [JL][LT]

JL_STD_LT

Actual block-off (off-block / departure) time, from the Journey Log (actual), in local time

BLOFF [FW][UTC]

FW_STD_UTC

Actual block-off (off-block / departure) time, from Flight Watch (live movement tracking), in UTC

BLOFF [FW][LT]

FW_STD_LT

Actual block-off (off-block / departure) time, from Flight Watch (live movement tracking), in local time

BLON [JL][UTC]

JL_STA_UTC

Actual block-on (on-block / arrival) time, from the Journey Log (actual), in UTC

BLON [JL][LT]

JL_STA_LT

Actual block-on (on-block / arrival) time, from the Journey Log (actual), in local time

BLON [FW][UTC]

FW_STA_UTC

Actual block-on (on-block / arrival) time, from Flight Watch (live movement tracking), in UTC

BLON [FW][LT]

FW_STA_LT

Actual block-on (on-block / arrival) time, from Flight Watch (live movement tracking), in local time

T/O [JL][UTC]

JL_ATD_UTC

Take-off time, from the Journey Log (actual), in UTC

LDG [JL][UTC]

JL_ATA_UTC

Landing time, from the Journey Log (actual), in UTC

T/O [JL][LT]

JL_ATD_LT

Take-off time, from the Journey Log (actual), in local time

LDG [JL][LT]

JL_ATA_LT

Landing time, from the Journey Log (actual), in local time

T/O [FW][UTC]

FW_ATD_UTC

Take-off time, from Flight Watch (live movement tracking), in UTC

LDG [FW][UTC]

FW_ATA_UTC

Landing time, from Flight Watch (live movement tracking), in UTC

T/O [FW][LT]

FW_ATD_LT

Take-off time, from Flight Watch (live movement tracking), in local time

LDG [FW][LT]

FW_ATA_LT

Landing time, from Flight Watch (live movement tracking), in local time

ETA [FW][UTC]

FW_ETA_UTC

Estimated time of arrival, from Flight Watch (live movement tracking), in UTC

ETA [FW][LT]

FW_ETA_LT

Estimated time of arrival, from Flight Watch (live movement tracking), in local time

ETD [FW][UTC]

FW_ETD_UTC

Estimated time of departure, from Flight Watch (live movement tracking), in UTC

ETD date [FW][UTC]

FW_ETD_DATE_UTC

Estimated date of departure, from Flight Watch (live movement tracking), in UTC

ETD [FW][LT]

FW_ETD_LT

Estimated time of departure, from Flight Watch (live movement tracking), in local time

CTOT [FW][UTC]

FW_CTOT_UTC

Calculated take-off time (ATC slot), from Flight Watch (live movement tracking), in UTC

CTOT [FW][LT]

FW_CTOT_LT

Calculated take-off time (ATC slot), from Flight Watch (live movement tracking), in local time

Delay code [FW]

FW_delay_code

Delay code, from Flight Watch (live movement tracking)

Delay reason [FW]

FW_delay_reason

Reason for the delay, from Flight Watch (live movement tracking)

Internal notes [FW]

FW_internal_notes

Internal free-text notes, from Flight Watch (live movement tracking)

Taxi out [JL]

taxiOut

Taxi-out time, from the Journey Log (actual)

Taxi in [JL]

taxiIn

Taxi-in time, from the Journey Log (actual)

Hobbs off [JL]

jl_hobbs_off

Hobbs meter reading at shutdown, from the Journey Log (actual)

Hobbs on [JL]

jl_hobbs_on

Hobbs meter reading at start-up, from the Journey Log (actual)

Tach off [JL]

jl_tah_off

Tachometer reading at shutdown, from the Journey Log (actual)

Tach on [JL]

jl_tah_on

Tachometer reading at start-up, from the Journey Log (actual)

Push back [JL]

jl_push_back

Push-back performed, from the Journey Log (actual)

Fuel BLOFF [FW]

fw_fuel_bloff

Fuel on board at block-off, from Flight Watch (live movement tracking)

Fuel T/O [FW]

fw_fuel_to

Fuel on board at take-off, from Flight Watch (live movement tracking)

Fuel LDG [FW]

fw_fuel_ldg

Fuel on board at landing, from Flight Watch (live movement tracking)

Fuel BLON [FW]

fw_fuel_blon

Fuel on board at block-on, from Flight Watch (live movement tracking)

Flight & block times

Column

Column key

Description

Block time [Plan]

blockTimePlan

Block time (off-block to on-block), planned

Block time [Plan][DEC]

block_time_plan_decimal

Block time (off-block to on-block), planned, in decimal hours

Estimated flight time [Plan]

estimated_flight_time_plan

Estimated flight time, planned

Block time [FW]

blockTimeFlightWatch

Block time (off-block to on-block), from Flight Watch (live movement tracking)

Block time [FW][DEC]

block_time_flight_watch_decimal

Block time (off-block to on-block), from Flight Watch (live movement tracking), in decimal hours

Block time [JL]

blockTimeJourneyLog

Block time (off-block to on-block), from the Journey Log (actual)

Block time [JL][DEC]

block_time_journey_log_decimal

Block time (off-block to on-block), from the Journey Log (actual), in decimal hours

Block Time Difference [JL - Plan]

block_time_difference_jl_plan

Difference between block time from JL and block time from plan

Block Time Difference Decimal[JL - Plan][DEC]

block_time_difference_jl_plan_decimal

Difference between block time from JL and block time from plan

Flight Time Difference [JL - Plan]

flight_time_difference_jl_plan

Difference between flight time from JL and flight time from plan

Flight time [FW]

FW_flight_time

Flight time (airborne, take-off to landing), from Flight Watch (live movement tracking)

Flight time [FW][DEC]

FW_flight_time_decimal

Flight time (airborne, take-off to landing), from Flight Watch (live movement tracking), in decimal hours

EET [FW]

fw_eet

Estimated elapsed time en route, from Flight Watch (live movement tracking)

EET [FW][DEC]

fw_eet_decimal

Estimated elapsed time en route, from Flight Watch (live movement tracking), in decimal hours

Flight time [JL]

flightTime

Flight time (airborne, take-off to landing), from the Journey Log (actual)

Flight time [JL][DEC]

flight_time_decimal

Flight time (airborne, take-off to landing), from the Journey Log (actual), in decimal hours

NVG flight time [JL]

jl_nvg_flight_time

Flight time flown using night-vision goggles, from the Journey Log (actual)

Instructor time [JL]

jl_instructor_time

Flight time logged as instructor, from the Journey Log (actual)

UK airspace time [JL]

jl_uk_airspace_time

Time spent within UK airspace, from the Journey Log (actual)

On task time [JL][UTC]

jl_on_task

Time spent on task, from the Journey Log (actual), in UTC

Off task time [JL][UTC]

jl_off_task

Time spent off task, from the Journey Log (actual), in UTC

Departure Diff [JL - Plan]

dep_diff

Difference between actual and planned departure time, difference between the actual (Journey Log) and planned value

T/O Diff [JL - Plan]

to_diff

Difference between actual and planned take-off time, difference between the actual (Journey Log) and planned value

LDG Diff [JL - Plan]

ldg_diff

Difference between actual and planned landing time, difference between the actual (Journey Log) and planned value

Arrival Diff [JL - Plan]

arr_diff

Difference between actual and planned arrival time, difference between the actual (Journey Log) and planned value

CO2 emission (block time) [JL][t]

co2_emission_block_time

Used fuel calculated based on an aircraft performance (in tons) and Block time from JL, multiplied by a constant factor: 3.16 for JET-A and 3.10 for AVGAS

Calculated climb time [JL][mins]

JL_calculated_climb_time

MAX FL / 'Aircraft climb rate'

Calculated descent time [JL][mins]

JL_calculated_descent_time

MAX FL / 'Aircraft descent rate'

Max FL flight time [JL]

JL_calculated_flight_time

'Flight time' - 'Calculated climb time' - 'Calculated descent time'

Night time [JL]

JL_night_time

Flight time flown at night, from the Journey Log (actual)

Block Time [Quote]

quote_block_time

Block time from Quote booked in Sales module

Block Time [Quote][DEC]

quote_block_time_decimal

Block time from Quote booked in Sales module

Flight Time Difference [Quote - JL]

quote_jl_flight_time_diff

Difference between flight time from Quote and flight time from JL

Block Time Difference [Quote - JL]

quote_jl_block_time_diff

Difference between block time from Quote and block time from JL

Block Time Difference [Quote - JL][DEC]

quote_jl_block_time_diff_decimal

Difference between block time from Quote and block time from JL

Planned trip flight time [JL]

jl_ofpl_flight_time

Planned total flight time for the trip, from the Journey Log (actual)

Instrument time [JL]

jl_instrument_time

Flight time logged on instruments, from the Journey Log (actual)

Crew

Column

Column key

Description

Crew Preflight Briefing [JL]

jl_crew_preflight_briefing

Crew Preflight Briefing as recorded in the Journey Log

Cosmic radiation dose [JL][µSv]

jl_cosmic_radiation_dose

Cosmic radiation dose received on the flight, from the Journey Log (actual), in microsieverts

Fatigue score description [JL]

jl_fatigue_score_description

Description of the fatigue score, from the Journey Log (actual)

Crew food [JL]

jl_crew_catering

Crew food arrangements, from the Journey Log (actual)

Crew food notes [JL]

jl_crew_catering_notes

Crew food notes as recorded in the Journey Log

Crew HOTAC [JL]

jl_crew_hotel

Crew hotel accommodation (HOTAC) arrangements, from the Journey Log (actual)

Crew HOTAC notes [JL]

jl_crew_hotel_notes

Notes on crew hotel accommodation, from the Journey Log (actual)

Pilot flying [JL]

pilotFlying

Crew code of the pilot flying (PF), from the Journey Log (actual)

Pilot flying full name [JL]

pilot_flying_full_name

Full name of the pilot flying (PF), from the Journey Log (actual)

Pilot monitoring [JL]

pilot_monitoring

Crew code of the pilot monitoring (PM), from the Journey Log (actual)

Pilot monitoring full name [JL]

pilot_monitoring_full_name

Full name of the pilot monitoring (PM), from the Journey Log (actual)

Number of crew

numberOfCrew

Total number of crew on the flight

Cockpit crew

cockpitCrew

Cockpit crew assigned to the flight

Cockpit Crew Full names

cockpit_crew_full_names

Full names of the cockpit crew

Cabin crew

cabinCrew

Cabin crew assigned to the flight

Crew codes

crew_codes

Crew codes of all assigned crew

Crew position names

crew_position_names

Position names of all assigned crew

Crew homebases

crew_home_bases

Home bases of the assigned crew

Positioning crew

positioning_crew

Positioning (deadhead) crew on the flight

Crew names

crew_names

Names of all assigned crew

Crew phones

crew_phones

Phone numbers of the assigned crew

Crew Notes [Chkl]

checklist_crew_notes

Free-text notes for the crew

Crew Transport Note [Chkl]

checklist_item_crew_transport_note

Checklist record: Crew Transport Note

Crew Transport ADEP Notes[Chkl]

checklist_item_crew_transport_adep_notes

Checklist record: Crew Transport departure Notes

Crew Transport ADES Notes[Chkl]

checklist_item_crew_transport_ades_notes

Checklist record: Crew Transport destination Notes

Commander code

crew_CMD

Crew code of the commander (PIC)

Commander name

crew_CMD_name

Full name of the commander (PIC) assigned to the flight

PIC [Cockpit]

crew_CPT

Crew code of the pilot in command (captain) assigned to the flight

CPT2 [Cockpit]

crew_CPT2

Crew code of the second captain assigned to the flight

CPT3 [Cockpit]

crew_CPT3

Crew code of the third captain assigned to the flight

CPT4 [Cockpit]

crew_CPT4

Crew code of the fourth captain assigned to the flight

CPT5 [Cockpit]

crew_CPT5

Crew code of the fifth captain assigned to the flight

FO [Cockpit]

crew_FO

Crew code of the first officer assigned to the flight

FO2 [Cockpit]

crew_FO2

Crew code of the second first officer assigned to the flight

FO3 [Cockpit]

crew_FO3

Crew code of the third first officer assigned to the flight

FO4 [Cockpit]

crew_FO4

Crew code of the fourth first officer assigned to the flight

SFE [Cockpit]

crew_FE

Crew code of the senior flight engineer assigned to the flight

INS [Cockpit]

crew_INS

Crew code of the instructor assigned to the flight

SP [Cockpit]

crew_SP

Crew code of the safety pilot assigned to the flight

LTC [Cockpit]

crew_LTC

Crew code of the line training captain assigned to the flight

TRI [Cockpit]

crew_TRI

Crew code of the type rating instructor assigned to the flight

OBS [Cockpit]

crew_OBS

Crew code of the observer assigned to the flight

OBS2 [Cockpit]

crew_OBS2

Crew code of the second observer assigned to the flight

TRE [Cockpit]

crew_TRE

Crew code of the type rating examiner assigned to the flight

LTI [Cockpit]

crew_LTI

Crew code of the line training instructor assigned to the flight

LTE [Cockpit]

crew_LTE

Crew code of the line training examiner assigned to the flight

STB [Cockpit]

crew_STB

Crew code of the standby pilot assigned to the flight

FM [Maintenance]

crew_FM

Crew code of the flight mechanic assigned to the flight

FM2 [Maintenance]

crew_FM2

Crew code of the second flight mechanic assigned to the flight

FM3 [Maintenance]

crew_FM3

Crew code of the third flight mechanic assigned to the flight

FM4 [Maintenance]

crew_FM4

Crew code of the fourth flight mechanic assigned to the flight

FA1 [Cabin]

crew_FA1

Crew code of the flight attendant 1 assigned to the flight

FA2 [Cabin]

crew_FA2

Crew code of the flight attendant 2 assigned to the flight

FA3 [Cabin]

crew_FA3

Crew code of the flight attendant 3 assigned to the flight

FA4 [Cabin]

crew_FA4

Crew code of the flight attendant 4 assigned to the flight

FA5 [Cabin]

crew_FA5

Crew code of the flight attendant 5 assigned to the flight

FA6 [Cabin]

crew_FA6

Crew code of the flight attendant 6 assigned to the flight

FA7 [Cabin]

crew_FA7

Crew code of the flight attendant 7 assigned to the flight

FA8 [Cabin]

crew_FA8

Crew code of the flight attendant 8 assigned to the flight

FA9 [Cabin]

crew_FA9

Crew code of the flight attendant 9 assigned to the flight

FA10 [Cabin]

crew_FA10

Crew code of the flight attendant 10 assigned to the flight

FA11 [Cabin]

crew_FA11

Crew code of the flight attendant 11 assigned to the flight

FA12 [Cabin]

crew_FA12

Crew code of the flight attendant 12 assigned to the flight

FA13 [Cabin]

crew_FA13

Crew code of the flight attendant 13 assigned to the flight

FA14 [Cabin]

crew_FA14

Crew code of the flight attendant 14 assigned to the flight

FA15 [Cabin]

crew_FA15

Crew code of the flight attendant 15 assigned to the flight

IFA [Cabin]

crew_IFA

Crew code of the in-flight attendant assigned to the flight

IFA2 [Cabin]

crew_IFA2

Crew code of the second in-flight attendant assigned to the flight

SFA [Cabin]

crew_SFA

Crew code of the senior flight attendant assigned to the flight

SFA2 [Cabin]

crew_SFA2

Crew code of the second senior flight attendant assigned to the flight

SFA3 [Cabin]

crew_SFA3

Crew code of the third senior flight attendant assigned to the flight

EFA [Cabin]

crew_EFA

Crew code of the extra flight attendant assigned to the flight

EFA2 [Cabin]

crew_EFA2

Crew code of the second extra flight attendant assigned to the flight

PIC name [Cockpit]

crew_CPT_name

Full name of the pilot in command (captain) assigned to the flight

CPT2 name [Cockpit]

crew_CPT2_name

Full name of the second captain assigned to the flight

CPT3 name [Cockpit]

crew_CPT3_name

Full name of the third captain assigned to the flight

CPT4 name [Cockpit]

crew_CPT4_name

Full name of the fourth captain assigned to the flight

CPT5 name [Cockpit]

crew_CPT5_name

Full name of the fifth captain assigned to the flight

FO name [Cockpit]

crew_FO_name

Full name of the first officer assigned to the flight

FO2 name [Cockpit]

crew_FO2_name

Full name of the second first officer assigned to the flight

FO3 name [Cockpit]

crew_FO3_name

Full name of the third first officer assigned to the flight

FO4 name [Cockpit]

crew_FO4_name

Full name of the fourth first officer assigned to the flight

INS name [Cockpit]

crew_INS_name

Full name of the instructor assigned to the flight

SP name [Cockpit]

crew_SP_name

Full name of the safety pilot assigned to the flight

LTC name [Cockpit]

crew_LTC_name

Full name of the line training captain assigned to the flight

TRI name [Cockpit]

crew_TRI_name

Full name of the type rating instructor assigned to the flight

OBS name [Cockpit]

crew_OBS_name

Full name of the observer assigned to the flight

OBS2 name [Cockpit]

crew_OBS2_name

Full name of the second observer assigned to the flight

TRE name [Cockpit]

crew_TRE_name

Full name of the type rating examiner assigned to the flight

LTI name [Cockpit]

crew_LTI_name

Full name of the line training instructor assigned to the flight

LTE name [Cockpit]

crew_LTE_name

Full name of the line training examiner assigned to the flight

STB name [Cockpit]

crew_STB_name

Full name of the standby pilot assigned to the flight

FM name [Maintenance]

crew_FM_name

Full name of the flight mechanic assigned to the flight

FM2 name [Maintenance]

crew_FM2_name

Full name of the second flight mechanic assigned to the flight

FM3 name [Maintenance]

crew_FM3_name

Full name of the third flight mechanic assigned to the flight

FM4 name [Maintenance]

crew_FM4_name

Full name of the fourth flight mechanic assigned to the flight

FA1 name [Cabin]

crew_FA1_name

Full name of the flight attendant 1 assigned to the flight

FA2 name [Cabin]

crew_FA2_name

Full name of the flight attendant 2 assigned to the flight

FA3 name [Cabin]

crew_FA3_name

Full name of the flight attendant 3 assigned to the flight

FA4 name [Cabin]

crew_FA4_name

Full name of the flight attendant 4 assigned to the flight

FA5 name [Cabin]

crew_FA5_name

Full name of the flight attendant 5 assigned to the flight

FA6 name [Cabin]

crew_FA6_name

Full name of the flight attendant 6 assigned to the flight

FA7 name [Cabin]

crew_FA7_name

Full name of the flight attendant 7 assigned to the flight

FA8 name [Cabin]

crew_FA8_name

Full name of the flight attendant 8 assigned to the flight

FA9 name [Cabin]

crew_FA9_name

Full name of the flight attendant 9 assigned to the flight

FA10 name [Cabin]

crew_FA10_name

Full name of the flight attendant 10 assigned to the flight

FA11 name [Cabin]

crew_FA11_name

Full name of the flight attendant 11 assigned to the flight

FA12 name [Cabin]

crew_FA12_name

Full name of the flight attendant 12 assigned to the flight

FA13 name [Cabin]

crew_FA13_name

Full name of the flight attendant 13 assigned to the flight

FA14 name [Cabin]

crew_FA14_name

Full name of the flight attendant 14 assigned to the flight

FA15 name [Cabin]

crew_FA15_name

Full name of the flight attendant 15 assigned to the flight

IFA name [Cabin]

crew_IFA_name

Full name of the in-flight attendant assigned to the flight

IFA2 name [Cabin]

crew_IFA2_name

Full name of the second in-flight attendant assigned to the flight

SFA name [Cabin]

crew_SFA_name

Full name of the senior flight attendant assigned to the flight

SFA2 name [Cabin]

crew_SFA2_name

Full name of the second senior flight attendant assigned to the flight

SFA3 name [Cabin]

crew_SFA3_name

Full name of the third senior flight attendant assigned to the flight

FAOBS name [Cabin]

crew_FA0BS_name

Full name of the flight attendant observer assigned to the flight

FAOBS2 name [Cabin]

crew_FA0BS2_name

Full name of the second flight attendant observer assigned to the flight

EFA name [Cabin]

crew_EFA_name

Full name of the extra flight attendant assigned to the flight

EFA2 name [Cabin]

crew_EFA2_name

Full name of the second extra flight attendant assigned to the flight

PIC [Cockpit]

crew_captains

Crew code of the pilot in command (captain) assigned to the flight

Captains

crew_opr_captain_list

List of captains assigned to the flight

Officers

crew_opr_officer_list

List of first officers assigned to the flight

Inflight service personnel

crew_opr_inflight_personnel_list

List of in-flight service personnel assigned to the flight

Flight attendants

crew_opr_fa_list

List of flight attendants assigned to the flight

Flight engineer

crew_opr_fe_list

List of flight engineers assigned to the flight

Senior flight attendants

crew_opr_sfa_list

List of senior flight attendants assigned to the flight

Fatigue score [JL]

fatigue_score

Crew fatigue score, from the Journey Log (actual)

Fatigue score - CPT [JL]

jl_fatigue_score_cpt

Fatigue score of the captain, from the Journey Log (actual)

Fatigue score - FO [JL]

jl_fatigue_score_fo

Fatigue score of the first officer, from the Journey Log (actual)

Fatigue score - other crew [JL]

jl_fatigue_score_other

Fatigue score of other crew, from the Journey Log (actual)

Crew transport [JL]

jl_crew_transport

Crew ground transport arrangements, from the Journey Log (actual)

Passengers

Column

Column key

Description

PAX number [FW]

FW_PAX_number

Number of passengers, from Flight Watch (live movement tracking)

PAX number [JL]

JL_PAX_number

Number of passengers, from the Journey Log (actual)

PAX heads [JL]

jl_pax_heads_number

Passenger head count, from the Journey Log (actual)

Load factor [FW]

fw_load_factor

Passenger load factor, from Flight Watch (live movement tracking)

Load factor [JL]

jl_load_factor

Passenger load factor, from the Journey Log (actual)

Load factor [Plan]

load_factor

Passenger load factor, planned

PAX number [Plan]

PAXNumber

Number of passengers, planned

PAX Names

PAX_names

Names of the passengers

PAX Text

PAX_text

Free-text passenger information

Boarded PAX Names

boarded_PAX_names

Names of passengers who boarded

Boarded PAX Number

boarded_PAX_number

Number of passengers who boarded

Males [JL]

males

Number of male passengers, from the Journey Log (actual)

Females [JL]

females

Number of female passengers, from the Journey Log (actual)

Children [JL]

children

Number of child passengers, from the Journey Log (actual)

Infants [JL]

infants

Number of infant passengers, from the Journey Log (actual)

Pets [JL]

pets

Number of pets on board, from the Journey Log (actual)

PAX transport [JL]

jl_pax_transport

Passenger ground transport arrangements, from the Journey Log (actual)

PAX terminal meet [JL]

jl_terminal_meet_pax

Terminal meet-and-greet arrangements, from the Journey Log (actual)

PAX happy with flight [JL]

jl_pax_flight_satisfactory

Whether passengers were satisfied with the flight, from the Journey Log (actual)

Adults [Plan]

pax_adult_count

Number of adult passengers, planned

Adults [JL]

jl_pax_adult_count

Number of adult passengers, from the Journey Log (actual)

PAX comments [JL]

jl_pax_comments

Comments about the passengers, from the Journey Log (actual)

PAX happy with catering [JL]

jl_pax_catering_satisfactory

Whether passengers were satisfied with catering, from the Journey Log (actual)

PAX catering notes [JL]

jl_pax_catering_notes

Catering notes for the passengers, from the Journey Log (actual)

Transit PAX [JL]

JL_pax_transit

Number of transit passengers, from the Journey Log (actual)

Economy class PAX [JL]

JL_pax_economy_class

Number of economy-class passengers, from the Journey Log (actual)

Business class PAX [JL]

JL_pax_business_class

Number of business-class passengers, from the Journey Log (actual)

UK APD Band

uk_apd_band

UK Air Passenger Duty band

Male [Plan]

male_plan

Number of male passengers, planned

Female [Plan]

female_plan

Number of female passengers, planned

Children [Plan]

children_plan

Number of child passengers, planned

Infants [Plan]

infants_plan

Number of infant passengers, planned

Revenue Passenger [JL][NM]

revenue_passenger_nm

Number of revenue passengers, from the Journey Log (actual), in nautical miles

Revenue Passenger [JL][km]

revenue_passenger_km

Number of revenue passengers, from the Journey Log (actual), in kilometres

ASK Available seats [JL][km]

available_seats_km

Number of available seats x distance flown in km

ASM Available seats [JL][NM]

available_seats_nm

Number of available seats x distance flown in nautical miles

PLF Passenger Load Factor %[JL]

passenger_load_factor

Revenue Passenger km / Available seats in km x 100

Italian BAND

italian_band

Italian tax band

Sum unique pax in a trip [Plan]

sum_unique_pax_in_a_trip

Number of unique passengers across the whole trip, planned

Adults [FW]

fw_load_adults_count

Number of adult passengers, from Flight Watch (live movement tracking)

Males [FW]

fw_load_male_count

Number of male passengers, from Flight Watch (live movement tracking)

Females [FW]

fw_load_female_count

Number of female passengers, from Flight Watch (live movement tracking)

Children [FW]

fw_load_child_count

Number of child passengers, from Flight Watch (live movement tracking)

Infants [FW]

fw_load_infant_count

Number of infant passengers, from Flight Watch (live movement tracking)

Pets [Plan]

pets_plan

Number of pets on board, planned

Animal Names

animal_names

Names of animals carried

UK Air Passenger Duty Tax GBP

uk_apd_tax

UK Air Passenger Duty Tax applied to the flight, in GBP

Customs Air Passenger User Fee (CUF) USD

customs_air_passenger_user_fee_tax

Customs Air Passenger User Fee (CUF) applied to the flight, in USD

Immigration Air Passenger User Fee (IUF) USD

immigration_air_passenger_user_fee_tax

Immigration Air Passenger User Fee (IUF) applied to the flight, in USD

Danish Passenger Tax DKK

danish_passenger_tax

Danish Passenger Tax applied to the flight, in DKK

UK Air Passenger Duty Tax Breakdown

uk_apd_tax_breakdown

Breakdown of the UK Air Passenger Duty Tax applied to the flight

Customs Air Passenger User Fee (CUF) Breakdown

customs_air_passenger_user_fee_tax_breakdown

Breakdown of the Customs Air Passenger User Fee (CUF) applied to the flight

Immigration Air Passenger User Fee (IUF) Breakdown

immigration_air_passenger_user_fee_tax_breakdown

Breakdown of the Immigration Air Passenger User Fee (IUF) applied to the flight

Danish Passenger Tax Breakdown

danish_passenger_tax_breakdown

Breakdown of the Danish Passenger Tax applied to the flight

Cargo, load & weight

Column

Column key

Description

Cargo [FW][lbs]

FW_cargo_lbs

Cargo weight, from Flight Watch (live movement tracking), in pounds

Cargo [FW][kg]

FW_cargo_kg

Cargo weight, from Flight Watch (live movement tracking), in kilograms

Baggage [FW][kg]

fw_baggage_kg

Baggage weight, from Flight Watch (live movement tracking), in kilograms

Baggage [FW][lbs]

fw_baggage_lbs

Baggage weight, from Flight Watch (live movement tracking), in pounds

Mail [FW][kg]

fw_mail_kg

Mail weight, from Flight Watch (live movement tracking), in kilograms

Mail [FW][lbs]

fw_mail_lbs

Mail weight, from Flight Watch (live movement tracking), in pounds

Total load [FW][kg]

fw_total_load_kg

Total load weight (passengers, cargo, baggage, mail), from Flight Watch (live movement tracking), in kilograms

Total load [FW][lbs]

fw_total_load_lbs

Total load weight (passengers, cargo, baggage, mail), from Flight Watch (live movement tracking), in pounds

Delay ADEP [JL][mins]

jl_delay_adep

Departure delay, from the Journey Log (actual), in minutes

Delay ADES [JL][mins]

jl_delay_ades

Arrival delay, from the Journey Log (actual), in minutes

Delay ADEP [FW][mins]

fw_delay_adep

Departure delay, from Flight Watch (live movement tracking), in minutes

Delay ADES [FW][mins]

fw_delay_ades

Arrival delay, from Flight Watch (live movement tracking), in minutes

Distance [JL][NM]

distanceNM

Flight distance, from the Journey Log (actual), in nautical miles

Distance [JL][km]

distance_log_km

Flight distance, from the Journey Log (actual), in kilometres

Distance [Plan][NM]

distance_plan_NM

Flight distance, planned, in nautical miles

Distance [Plan][km]

distance_plan_km

Flight distance, planned, in kilometres

Distance [JL][mi]

distance_miles

Flight distance, from the Journey Log (actual), in miles

Distance [Plan][mi]

distance_plan_miles

Flight distance, planned, in miles

GCD [NM]

GCDNM

Great-circle distance between departure and destination, in nautical miles

GCD [km]

GCD_km

Great-circle distance between departure and destination, in kilometres

MAX FL

MAXFL

Maximum flight level

Bags [lbs]

bagsLbs

Baggage weight, in pounds

Bags [kg]

bagsKg

Baggage weight, in kilograms

Bags [quantity] [JL]

jl_bags_quantity

Baggage weight, from the Journey Log (actual), as a quantity

Cargo [JL][lbs]

cargoLbs

Cargo weight, from the Journey Log (actual), in pounds

Cargo [JL][kg]

cargoKg

Cargo weight, from the Journey Log (actual), in kilograms

Underload [JL][lbs]

underload_lbs

Remaining payload capacity (underload), from the Journey Log (actual), in pounds

Underload [JL][kg]

underload_kg

Remaining payload capacity (underload), from the Journey Log (actual), in kilograms

Cargo loaded [JL][lbs]

jl_cargo_loaded_lbs

Cargo loaded onto the aircraft, from the Journey Log (actual), in pounds

Cargo loaded [JL][kg]

jl_cargo_loaded_kg

Cargo loaded onto the aircraft, from the Journey Log (actual), in kilograms

Cargo unloaded [JL][lbs]

jl_cargo_unloaded_lbs

Cargo unloaded from the aircraft, in pounds

Cargo unloaded [JL][kg]

jl_cargo_unloaded_kg

Cargo unloaded from the aircraft, in kilograms

Pallets loaded [JL]

jl_pallets_loaded

Number of pallets loaded, from the Journey Log (actual)

Pallets unloaded [JL]

jl_pallets_unloaded

Number of pallets unloaded, from the Journey Log (actual)

Carriage of dangerous goods [JL]

jl_carriage_of_dangerous_goods

Whether dangerous goods are carried, from the Journey Log (actual)

Traffic load [JL][lbs]

jl_traffic_load_lbs

Traffic load weight, from the Journey Log (actual), in pounds

Traffic load [JL][kg]

jl_traffic_load_kg

Traffic load weight, from the Journey Log (actual), in kilograms

Low level spray [JL]

jl_low_level_spray

Low-level spraying performed, from the Journey Log (actual)

Seal numbers [JL]

jl_seal_numbers

Cargo seal numbers, from the Journey Log (actual)

Payload [estimated][kg]

payload_kg

Payload weight, estimated, in kilograms

Payload [estimated][lbs]

payload_lbs

Payload weight, estimated, in pounds

Payload [estimated] / Distance [kmT]

payload_kmt

Payload-to-distance ratio, estimated, in tonne-kilometres

Water scoopes [JL]

jl_water_scoopes

Number of water scoops, from the Journey Log (actual)

Water landings [JL]

jl_water_landings

Number of water landings, from the Journey Log (actual)

Sling load [JL][lbs]

jl_sling_load_lbs

Sling (external) load weight, from the Journey Log (actual), in pounds

Sling load [JL][kg]

jl_sling_load_kg

Sling (external) load weight, from the Journey Log (actual), in kilograms

Take off weight [JL][lbs]

jl_take_off_weight_lbs

Take-off weight, from the Journey Log (actual), in pounds

Take off weight [JL][kg]

jl_take_off_weight_kg

Take-off weight, from the Journey Log (actual), in kilograms

Ballast [JL][lbs]

jl_ballast_lbs

Ballast weight, from the Journey Log (actual), in pounds

Ballast [JL][kg]

jl_ballast_kg

Ballast weight, from the Journey Log (actual), in kilograms

Mail weight [JL][lbs]

jl_mail_weight_lbs

Mail weight, from the Journey Log (actual), in pounds

Mail weight [JL][kg]

jl_mail_weight_kg

Mail weight, from the Journey Log (actual), in kilograms

Italian Tax Distance

italian_tax_distance

Distance used for Italian tax calculation

Payload [W&B][kg]

weight_and_balance_payload_kg

Payload weight, from Weight & Balance, in kilograms

Payload [W&B][lbs]

weight_and_balance_payload_lbs

Payload weight, from Weight & Balance, in pounds

Cargo Note [Chkl]

checklist_item_cargo_note

Free-text cargo note

Cargo Status [Chkl]

checklist_item_cargo_note_status

Cargo handling status

Cargo [Plan][kg]

cargo_plan_kg

Cargo weight, planned, in kilograms

Cargo [Plan][lbs]

cargo_plan_lbs

Cargo weight, planned, in pounds

ULD weight [kg]

uld_weight_kg

Unit load device (ULD) weight, in kilograms

ULD weight [lbs]

uld_weight_lbs

Unit load device (ULD) weight, in pounds

ULD number

uld_number

Unit load device (ULD) number

FTK [ton*km][PLAN]

FTK_plan

Freight tonne-kilometres (FTK), planned, in tonne-kilometres

FTK [ton*km][JL]

FTK_jl

Freight tonne-kilometres (FTK), from the Journey Log (actual), in tonne-kilometres

Fuel & consumables

Column

Column key

Description

Block fuel [Plan][lbs]

plan_block_fuel_lbs

Total block fuel loaded (trip plus reserves), planned, in pounds

Block fuel [Plan][kg]

plan_block_fuel_kg

Total block fuel loaded (trip plus reserves), planned, in kilograms

Block fuel [Plan][L]

plan_block_fuel_l

Total block fuel loaded (trip plus reserves), planned, in litres

Block fuel [Plan][t]

plan_block_fuel_t

Total block fuel loaded (trip plus reserves), planned, in tonnes

Block fuel difference [JL - Plan][%]

block_fuel_difference

Difference between planned and actual block fuel, difference between the actual (Journey Log) and planned value, as a percentage

Burn fuel [Plan][lbs]

plan_burn_fuel_lbs

Fuel burned, planned, in pounds

Burn fuel [Plan][kg]

plan_burn_fuel_kg

Fuel burned, planned, in kilograms

Burn fuel [Plan][L]

plan_burn_fuel_l

Fuel burned, planned, in litres

Burn fuel [Plan][t]

plan_burn_fuel_t

Fuel burned, planned, in tonnes

Trip fuel difference [JL - Plan][%]

trip_fuel_difference

Difference between planned and actual trip fuel, difference between the actual (Journey Log) and planned value, as a percentage

Fuel used difference [JL - Plan][%]

used_fuel_difference

Difference between planned and actual fuel used, difference between the actual (Journey Log) and planned value, as a percentage

Fuel used difference [JL][%]

planned_used_fuel_difference_lbs

Difference between burn fuel (from Flight Plan) and fuel used (from JL). Percentage difference of used fuel compared to planned burn fuel.

Fuel used [JL][lbs]

usedFuelLbs

Fuel used during the flight, from the Journey Log (actual), in pounds

Fuel used [JL][kg]

usedFuelKg

Fuel used during the flight, from the Journey Log (actual), in kilograms

Fuel used [JL][L]

used_fuel_l

Fuel used during the flight, from the Journey Log (actual), in litres

Fuel used [JL][US Gal]

used_fuel_usgal

Fuel used during the flight, from the Journey Log (actual), in US gallons

Fuel used [JL][t]

used_fuel_t

Fuel used during the flight, from the Journey Log (actual), in tonnes

Fuel density [JL]

log_fuel_density

Fuel density, from the Journey Log (actual)

Fuel uplift density [JL]

log_fuel_uplift_density

Density of the uplifted fuel, from the Journey Log (actual)

Fuel used per hour [JL][lbs]

usedFuelPerHourLbs

Fuel used per flight hour, from the Journey Log (actual), in pounds

Fuel used per hour [JL][kg]

usedFuelPerHourKg

Fuel used per flight hour, from the Journey Log (actual), in kilograms

Fuel used per hour [JL][L]

usedFuelPerHourL

Fuel used per flight hour, from the Journey Log (actual), in litres

Fuel used per hour [JL][US Gal]

used_fuel_per_hour_usg

Fuel used per flight hour, from the Journey Log (actual), in US gallons

Fuel used per hour [JL][t]

used_fuel_per_hour_t

Fuel used per flight hour, from the Journey Log (actual), in tonnes

Fuel used per block hour [JL][lbs]

used_fuel_per_block_hour_lbs

Fuel used per block hour, from the Journey Log (actual), in pounds

Fuel used per block hour [JL][kg]

used_fuel_per_block_hour_kg

Fuel used per block hour, from the Journey Log (actual), in kilograms

Fuel used per block hour [JL][L]

used_fuel_per_block_hour_l

Fuel used per block hour, from the Journey Log (actual), in litres

Fuel used per block hour [JL][US Gal]

used_fuel_per_block_hour_gal

Fuel used per block hour, from the Journey Log (actual), in US gallons

Fuel used per block hour [JL][t]

used_fuel_per_block_hour_t

Fuel used per block hour, from the Journey Log (actual), in tonnes

Fuel remaining [JL][lbs]

remainingFuelLbs

Fuel remaining on board, from the Journey Log (actual), in pounds

Fuel remaining [JL][kg]

remainingFuelKg

Fuel remaining on board, from the Journey Log (actual), in kilograms

Fuel remaining [JL][L]

remaining_fuel_l

Fuel remaining on board, from the Journey Log (actual), in litres

Fuel remaining [JL][US Gal]

remaining_fuel_usgal

Fuel remaining on board, from the Journey Log (actual), in US gallons

Fuel remaining [JL][t]

remaining_fuel_t

Fuel remaining on board, from the Journey Log (actual), in tonnes

Planned trip fuel [JL][lbs]

jl_planned_fuel_lbs

Planned trip fuel, from the Journey Log (actual), in pounds

Planned trip fuel [JL][kg]

jl_planned_fuel_kg

Planned trip fuel, from the Journey Log (actual), in kilograms

Planned trip fuel [JL][L]

jl_planned_fuel_l

Planned trip fuel, from the Journey Log (actual), in litres

Planned trip fuel [JL][US Gal]

jl_planned_fuel_usgal

Planned trip fuel, from the Journey Log (actual), in US gallons

Planned trip fuel [JL][t]

jl_planned_fuel_t

Planned trip fuel, from the Journey Log (actual), in tonnes

Fuel remaining from previous flight [JL][lbs]

prev_leg_remaining_fuel_lbs

Fuel carried over from the previous flight, in pounds

Fuel remaining from previous flight [JL][kg]

prev_leg_remaining_fuel_kg

Fuel carried over from the previous flight, in kilograms

Fuel remaining from previous flight [JL][L]

prev_leg_remaining_fuel_l

Fuel carried over from the previous flight, in litres

Fuel remaining from previous flight [JL][US Gal]

prev_leg_remaining_fuel_usgal

Fuel carried over from the previous flight, in US gallons

Fuel remaining from previous flight [JL][t]

prev_leg_remaining_fuel_t

Fuel carried over from the previous flight, in tonnes

Block fuel [JL][lbs]

blockFuelLbs

Total block fuel loaded (trip plus reserves), from the Journey Log (actual), in pounds

Block fuel [JL][kg]

blockFuelKg

Total block fuel loaded (trip plus reserves), from the Journey Log (actual), in kilograms

Block fuel [JL][L]

block_fuel_l

Total block fuel loaded (trip plus reserves), from the Journey Log (actual), in litres

Block fuel [JL][US Gal]

block_fuel_usgal

Total block fuel loaded (trip plus reserves), from the Journey Log (actual), in US gallons

Block fuel [JL][t]

block_fuel_t

Total block fuel loaded (trip plus reserves), from the Journey Log (actual), in tonnes

Fuel before uplift [JL][lbs]

fuel_before_uplift_lbs

Fuel on board before uplift, from the Journey Log (actual), in pounds

Fuel before uplift [JL][kg]

fuel_before_uplift_kg

Fuel on board before uplift, from the Journey Log (actual), in kilograms

Fuel before uplift [JL][L]

fuel_before_uplift_l

Fuel on board before uplift, from the Journey Log (actual), in litres

Fuel before uplift [JL][US Gal]

fuel_before_uplift_us_gal

Fuel on board before uplift, from the Journey Log (actual), in US gallons

Fuel before uplift [JL][t]

fuel_before_uplift_t

Fuel on board before uplift, from the Journey Log (actual), in tonnes

Fuel uplift [JL][lbs]

fuelUpliftLbs

Fuel uplifted (added) during refuelling, from the Journey Log (actual), in pounds

Fuel uplift [JL][kg]

fuelUpliftKg

Fuel uplifted (added) during refuelling, from the Journey Log (actual), in kilograms

Fuel uplift [JL][L]

fuelUpliftL

Fuel uplifted (added) during refuelling, from the Journey Log (actual), in litres

Fuel uplift [JL][US Gal]

fuel_uplift_usgal

Fuel uplifted (added) during refuelling, from the Journey Log (actual), in US gallons

Fuel uplift [JL][t]

fuel_uplift_t

Fuel uplifted (added) during refuelling, from the Journey Log (actual), in tonnes

APU fuel burn [JL][lbs]

fuel_apu_lbs

Fuel burned by the APU, from the Journey Log (actual), in pounds

APU fuel burn [JL][kg]

fuel_apu_kg

Fuel burned by the APU, from the Journey Log (actual), in kilograms

APU fuel burn [JL][L]

fuel_apu_l

Fuel burned by the APU, from the Journey Log (actual), in litres

APU fuel burn [JL][US Gal]

fuel_apu_usgal

Fuel burned by the APU, from the Journey Log (actual), in US gallons

APU fuel burn [JL][t]

fuel_apu_t

Fuel burned by the APU, from the Journey Log (actual), in tonnes

Fuel MRF [Plan][kg]

min_req_fuel_kg

Minimum required fuel (MRF), planned, in kilograms

Fuel MRF [Plan][lbs]

min_req_fuel_lbs

Minimum required fuel (MRF), planned, in pounds

Fuel MRF [Plan][L]

min_req_fuel_l

Minimum required fuel (MRF), planned, in litres

Fuel MRF [Plan][US Gal]

min_req_fuel_us_gal

Minimum required fuel (MRF), planned, in US gallons

Fuel MRF [Plan][t]

min_req_fuel_t

Minimum required fuel (MRF), planned, in tonnes

Fuel Requested [Plan][kg]

requested_fuel_kg

Fuel quantity requested, planned, in kilograms

Fuel Requested [Plan][lbs]

requested_fuel_lbs

Fuel quantity requested, planned, in pounds

Fuel Requested [Plan][L]

requested_fuel_l

Fuel quantity requested, planned, in litres

Fuel Requested [Plan][US Gal]

requested_fuel_us_gal

Fuel quantity requested, planned, in US gallons

Fuel Requested [Plan][t]

requested_fuel_t

Fuel quantity requested, planned, in tonnes

Trip fuel [Plan][kg]

trip_fuel_kg

Fuel planned to be burned during the trip, in kilograms

Trip fuel [Plan][lbs]

trip_fuel_lbs

Fuel planned to be burned during the trip, in pounds

Trip fuel [Plan][L]

trip_fuel_l

Fuel planned to be burned during the trip, in litres

Trip fuel [Plan][US Gal]

trip_fuel_us_gal

Fuel planned to be burned during the trip, in US gallons

Trip fuel [Plan][t]

trip_fuel_t

Fuel planned to be burned during the trip, in tonnes

Taxi fuel [Plan][kg]

plan_taxi_fuel_kg

Fuel allocated for taxiing, planned, in kilograms

Taxi fuel [Plan][lbs]

plan_taxi_fuel_lbs

Fuel allocated for taxiing, planned, in pounds

Taxi fuel [Plan][L]

plan_taxi_fuel_l

Fuel allocated for taxiing, planned, in litres

Taxi fuel [Plan][US Gal]

plan_taxi_fuel_us_gal

Fuel allocated for taxiing, planned, in US gallons

Taxi fuel [Plan][t]

plan_taxi_fuel_t

Fuel allocated for taxiing, planned, in tonnes

Contingency fuel [Plan][kg]

plan_contingency_fuel_kg

Contingency fuel reserve, planned, in kilograms

Contingency fuel [Plan][lbs]

plan_contingency_fuel_lbs

Contingency fuel reserve, planned, in pounds

Contingency fuel [Plan][L]

plan_contingency_fuel_l

Contingency fuel reserve, planned, in litres

Contingency fuel [Plan][US Gal]

plan_contingency_fuel_us_gal

Contingency fuel reserve, planned, in US gallons

Contingency fuel [Plan][t]

plan_contingency_fuel_t

Contingency fuel reserve, planned, in tonnes

Alternate fuel [Plan][kg]

plan_alternate_fuel_kg

Fuel reserved to reach the alternate airport, planned, in kilograms

Alternate fuel [Plan][lbs]

plan_alternate_fuel_lbs

Fuel reserved to reach the alternate airport, planned, in pounds

Alternate fuel [Plan][L]

plan_alternate_fuel_l

Fuel reserved to reach the alternate airport, planned, in litres

Alternate fuel [Plan][US Gal]

plan_alternate_fuel_us_gal

Fuel reserved to reach the alternate airport, planned, in US gallons

Alternate fuel [Plan][t]

plan_alternate_fuel_t

Fuel reserved to reach the alternate airport, planned, in tonnes

Additional fuel [Plan][kg]

plan_additional_fuel_kg

Additional fuel loaded, planned, in kilograms

Additional fuel [Plan][lbs]

plan_additional_fuel_lbs

Additional fuel loaded, planned, in pounds

Additional fuel [Plan][L]

plan_additional_fuel_l

Additional fuel loaded, planned, in litres

Additional fuel [Plan][US Gal]

plan_additional_fuel_us_gal

Additional fuel loaded, planned, in US gallons

Additional fuel [Plan][t]

plan_additional_fuel_t

Additional fuel loaded, planned, in tonnes

Final reserve fuel [Plan][kg]

plan_final_reserve_fuel_kg

Final reserve fuel, planned, in kilograms

Final reserve fuel [Plan][lbs]

plan_final_reserve_fuel_lbs

Final reserve fuel, planned, in pounds

Final reserve fuel [Plan][L]

plan_final_reserve_fuel_l

Final reserve fuel, planned, in litres

Final reserve fuel [Plan][US Gal]

plan_final_reserve_fuel_us_gal

Final reserve fuel, planned, in US gallons

Final reserve fuel [Plan][t]

plan_final_reserve_fuel_t

Final reserve fuel, planned, in tonnes

Discretionary fuel [Plan][kg]

plan_discretionary_fuel_kg

Discretionary fuel added by the crew, planned, in kilograms

Discretionary fuel [Plan][lbs]

plan_discretionary_fuel_lbs

Discretionary fuel added by the crew, planned, in pounds

Discretionary fuel [Plan][L]

plan_discretionary_fuel_l

Discretionary fuel added by the crew, planned, in litres

Discretionary fuel [Plan][US Gal]

plan_discretionary_fuel_us_gal

Discretionary fuel added by the crew, planned, in US gallons

Discretionary fuel [Plan][t]

plan_discretionary_fuel_t

Discretionary fuel added by the crew, planned, in tonnes

Extra fuel [Plan][kg]

plan_extra_fuel_kg

Extra fuel loaded, planned, in kilograms

Extra fuel [Plan][lbs]

plan_extra_fuel_lbs

Extra fuel loaded, planned, in pounds

Extra fuel [Plan][L]

plan_extra_fuel_l

Extra fuel loaded, planned, in litres

Extra fuel [Plan][US Gal]

plan_extra_fuel_us_gal

Extra fuel loaded, planned, in US gallons

Extra fuel [Plan][t]

plan_extra_fuel_t

Extra fuel loaded, planned, in tonnes

Plan remaining fuel [Plan][kg]

plan_remaining_fuel_kg

Planned remaining fuel, in kilograms

Plan remaining fuel [Plan][lbs]

plan_remaining_fuel_lbs

Planned remaining fuel, in pounds

Plan remaining fuel [Plan][L]

plan_remaining_fuel_l

Planned remaining fuel, in litres

Plan remaining fuel [Plan][US Gal]

plan_remaining_fuel_us_gal

Planned remaining fuel, in US gallons

Plan remaining fuel [Plan][t]

plan_remaining_fuel_t

Planned remaining fuel, in tonnes

SAF used [Plan]

plan_saf_used

Amount of Sustainable Aviation Fuel (SAF) used, planned

SAF fuel blend [Plan]

plan_saf_fuel_blend

Sustainable Aviation Fuel (SAF) blend percentage, planned

Oil uplift [JL][qt]

oilUplift

Engine oil uplift, from the Journey Log (actual), in quarts

Fuel delivery note [JL]

jl_adep_fuel_delivery_note

Fuel delivery note, from the Journey Log (actual)

Fuel invoice number [JL]

jl_adep_fuel_invoice_number

Fuel invoice number, from the Journey Log (actual)

Fuel provider [JL]

jl_adep_fuel_provider

Fuel provider, from the Journey Log (actual)

Oxygen [JL]

jl_oxygen

Oxygen status, from the Journey Log (actual)

Planned taxi fuel [JL][lbs]

jl_planned_taxi_fuel_lbs

Planned taxi fuel, from the Journey Log (actual), in pounds

Planned taxi fuel [JL][kg]

jl_planned_taxi_fuel_kg

Planned taxi fuel, from the Journey Log (actual), in kilograms

Planned taxi fuel [JL][L]

jl_planned_taxi_fuel_l

Planned taxi fuel, from the Journey Log (actual), in litres

Planned taxi fuel [JL][US Gal]

jl_planned_taxi_fuel_usgal

Planned taxi fuel, from the Journey Log (actual), in US gallons

Planned taxi fuel [JL][t]

jl_planned_taxi_fuel_t

Planned taxi fuel, from the Journey Log (actual), in tonnes

Indicated fuel [JL][lbs]

jl_indicated_fuel_lbs

Fuel quantity indicated by the aircraft gauges, from the Journey Log (actual), in pounds

Indicated fuel [JL][kg]

jl_indicated_fuel_kg

Fuel quantity indicated by the aircraft gauges, from the Journey Log (actual), in kilograms

Indicated fuel [JL][L]

jl_indicated_fuel_l

Fuel quantity indicated by the aircraft gauges, from the Journey Log (actual), in litres

Indicated fuel [JL][US Gal]

jl_indicated_fuel_usgal

Fuel quantity indicated by the aircraft gauges, from the Journey Log (actual), in US gallons

Indicated fuel [JL][t]

jl_indicated_fuel_t

Fuel quantity indicated by the aircraft gauges, from the Journey Log (actual), in tonnes

Additional fuel [JL][lbs]

jl_additional_fuel_lbs

Additional fuel loaded, from the Journey Log (actual), in pounds

Additional fuel [JL][kg]

jl_additional_fuel_kg

Additional fuel loaded, from the Journey Log (actual), in kilograms

Additional fuel [JL][L]

jl_additional_fuel_l

Additional fuel loaded, from the Journey Log (actual), in litres

Additional fuel [JL][US Gal]

jl_additional_fuel_usgal

Additional fuel loaded, from the Journey Log (actual), in US gallons

Additional fuel [JL][t]

jl_additional_fuel_t

Additional fuel loaded, from the Journey Log (actual), in tonnes

Alternate fuel [JL][lbs]

jl_alternate_fuel_lbs

Fuel reserved to reach the alternate airport, from the Journey Log (actual), in pounds

Alternate fuel [JL][kg]

jl_alternate_fuel_kg

Fuel reserved to reach the alternate airport, from the Journey Log (actual), in kilograms

Alternate fuel [JL][L]

jl_alternate_fuel_l

Fuel reserved to reach the alternate airport, from the Journey Log (actual), in litres

Alternate fuel [JL][US Gal]

jl_alternate_fuel_usgal

Fuel reserved to reach the alternate airport, from the Journey Log (actual), in US gallons

Alternate fuel [JL][t]

jl_alternate_fuel_t

Fuel reserved to reach the alternate airport, from the Journey Log (actual), in tonnes

Discretionary fuel [JL][lbs]

jl_discretionary_fuel_lbs

Discretionary fuel added by the crew, from the Journey Log (actual), in pounds

Discretionary fuel [JL][kg]

jl_discretionary_fuel_kg

Discretionary fuel added by the crew, from the Journey Log (actual), in kilograms

Discretionary fuel [JL][L]

jl_discretionary_fuel_l

Discretionary fuel added by the crew, from the Journey Log (actual), in litres

Discretionary fuel [JL][US Gal]

jl_discretionary_fuel_usgal

Discretionary fuel added by the crew, from the Journey Log (actual), in US gallons

Discretionary fuel [JL][t]

jl_discretionary_fuel_t

Discretionary fuel added by the crew, from the Journey Log (actual), in tonnes

Extra fuel [JL][lbs]

jl_extra_fuel_lbs

Extra fuel loaded, from the Journey Log (actual), in pounds

Extra fuel [JL][kg]

jl_extra_fuel_kg

Extra fuel loaded, from the Journey Log (actual), in kilograms

Extra fuel [JL][L]

jl_extra_fuel_l

Extra fuel loaded, from the Journey Log (actual), in litres

Extra fuel [JL][US Gal]

jl_extra_fuel_usgal

Extra fuel loaded, from the Journey Log (actual), in US gallons

Extra fuel [JL][t]

jl_extra_fuel_t

Extra fuel loaded, from the Journey Log (actual), in tonnes

Final reserve fuel [JL][lbs]

jl_final_reserve_fuel_lbs

Final reserve fuel, from the Journey Log (actual), in pounds

Final reserve fuel [JL][kg]

jl_final_reserve_fuel_kg

Final reserve fuel, from the Journey Log (actual), in kilograms

Final reserve fuel [JL][L]

jl_final_reserve_fuel_l

Final reserve fuel, from the Journey Log (actual), in litres

Final reserve fuel [JL][US Gal]

jl_final_reserve_fuel_usgal

Final reserve fuel, from the Journey Log (actual), in US gallons

Final reserve fuel [JL][t]

jl_final_reserve_fuel_t

Final reserve fuel, from the Journey Log (actual), in tonnes

Contingency fuel [JL][lbs]

jl_contingency_fuel_lbs

Contingency fuel reserve, from the Journey Log (actual), in pounds

Contingency fuel [JL][kg]

jl_contingency_fuel_kg

Contingency fuel reserve, from the Journey Log (actual), in kilograms

Contingency fuel [JL][L]

jl_contingency_fuel_l

Contingency fuel reserve, from the Journey Log (actual), in litres

Contingency fuel [JL][US Gal]

jl_contingency_fuel_usgal

Contingency fuel reserve, from the Journey Log (actual), in US gallons

Contingency fuel [JL][t]

jl_contingency_fuel_t

Contingency fuel reserve, from the Journey Log (actual), in tonnes

Tankered fuel [JL][lbs]

jl_tankered_fuel_lbs

Tankered fuel carried for economic reasons, from the Journey Log (actual), in pounds

Tankered fuel [JL][kg]

jl_tankered_fuel_kg

Tankered fuel carried for economic reasons, from the Journey Log (actual), in kilograms

Tankered fuel [JL][L]

jl_tankered_fuel_l

Tankered fuel carried for economic reasons, from the Journey Log (actual), in litres

Tankered fuel [JL][US Gal]

jl_tankered_fuel_usgal

Tankered fuel carried for economic reasons, from the Journey Log (actual), in US gallons

Tankered fuel [JL][t]

jl_tankered_fuel_t

Tankered fuel carried for economic reasons, from the Journey Log (actual), in tonnes

Fuel remarks [JL]

jl_fuel_remarks

Free-text fuel remarks, from the Journey Log (actual)

Oxygen remaining [JL][L]

jl_oxygen_remaining

Oxygen remaining on board, from the Journey Log (actual), in litres

Hydraulic System 1/A uplift [JL][qt]

jl_hydraulic_system1_uplift

Hydraulic fluid uplift for system 1/A, from the Journey Log (actual), in quarts

Hydraulic System 2/B uplift [JL][qt]

jl_hydraulic_system2_uplift

Hydraulic fluid uplift for system 2/B, from the Journey Log (actual), in quarts

Hydraulic System 3/C uplift [JL][qt]

jl_hydraulic_system3_uplift

Hydraulic fluid uplift for system 3/C, from the Journey Log (actual), in quarts

Refueling density [kg/dm3]

density_kg

In case of multiple refueling assignments to one flight, a list will be displayed, if none, default value will show

Refueling density [lbs/dm3]

density_lbs

In case of multiple refueling assignments to one flight, a list will be displayed, if none, default value will show

Refueling quantity [kg]

refueling_quantity_kg

Quantity of fuel added (refuelled), in kilograms

Refueling quantity [lbs]

refueling_quantity_lbs

Quantity of fuel added (refuelled), in pounds

Refueling quantity [L]

refueling_quantity_l

Quantity of fuel added (refuelled), in litres

Refueling quantity [US Gal]

refueling_quantity_usgal

Quantity of fuel added (refuelled), in US gallons

Refueling quantity [t]

refueling_quantity_t

Quantity of fuel added (refuelled), in tonnes

Defueling quantity [kg]

defueling_quantity_kg

Quantity of fuel removed (defuelled), in kilograms

Defueling quantity [lbs]

defueling_quantity_lbs

Quantity of fuel removed (defuelled), in pounds

Defueling quantity [L]

defueling_quantity_l

Quantity of fuel removed (defuelled), in litres

Defueling quantity [US Gal]

defueling_quantity_usgal

Quantity of fuel removed (defuelled), in US gallons

Defueling quantity [t]

defueling_quantity_t

Quantity of fuel removed (defuelled), in tonnes

Fuel Status[Chkl]

checklist_item_fuel_status

Fuel arrangement status

Fuel Notes [Chkl]

fuel_notes

Free-text fuel notes

Fuel Release Notes [Chkl]

fuel_release_notes

Fuel release notes

Refueling invoice no

refueling_invoice_numbers

Refuelling invoice number

Fuel price (Invoice)

fuel_price_invoice

Fuel price from the invoice

Fuel Price Supplier ADEP

fuel_price_supplier_ADEP

Fuel supplier at the departure airport

Fuel Price Supplier ADES

fuel_price_supplier_ADES

Fuel supplier at the destination airport

Fuel Price ADEP

fuel_price_ADEP

Fuel unit price at the departure airport

Fuel Price ADES

fuel_price_ADES

Fuel unit price at the destination airport

Fuel Price currency ADES

fuel_price_currency_ADES

User default fuel price currency

Fuel Price currency ADEP

fuel_price_currency_ADEP

User default fuel price currency

Fuel Cost based on Uplift ADEP

fuel_cost_ADEP

Fuel price * fuel uplift for 'show on tripsheet' fuel prices (ADEP)

Fuel Cost based on Uplift ADES

fuel_cost_ADES

Fuel price * fuel uplift for 'show on tripsheet' fuel prices (ADES)

Fuel Cost based on Used Fuel ADEP

fuel_cost_for_used_ADEP

Fuel price * used fuel for 'show on tripsheet' fuel prices (ADEP)

Fuel Cost based on Used Fuel ADES

fuel_cost_for_used_ADES

Fuel price * used fuel for 'show on tripsheet' fuel prices (ADES)

Ground fuel usage [JL][lbs]

ground_fuel_usage_lbs

Ground fuel usage = Fuel Before Uplift + Uplift - Block Fuel

Ground fuel usage [JL][kg]

ground_fuel_usage_kg

Ground fuel usage = Fuel Before Uplift + Uplift - Block Fuel

Ground fuel usage [JL][L]

ground_fuel_usage_l

Ground fuel usage = Fuel Before Uplift + Uplift - Block Fuel

Ground fuel usage [JL][US Gal]

ground_fuel_usage_usgal

Ground fuel usage = Fuel Before Uplift + Uplift - Block Fuel

Ground fuel usage [JL][t]

ground_fuel_usage_t

Ground fuel usage = Fuel Before Uplift + Uplift - Block Fuel

Block fuel SUM [JL][kg]

block_fuel_sum

Block fuel SUM = Fuel before uplift + Fuel uplift

Diff Block fuel SUM [JL][kg]

diff_block_fuel_sum

Diff block fuel SUM = Fuel before uplift + Block fuel

Diff Block fuel SUM %

diff_block_fuel_percent

Percentage difference in summed block fuel

Take off fuel [JL][lbs]

jl_take_off_fuel_lbs

Fuel on board at take-off, from the Journey Log (actual), in pounds

Take off fuel [JL][kg]

jl_take_off_fuel_kg

Fuel on board at take-off, from the Journey Log (actual), in kilograms

Take off fuel [JL][L]

jl_take_off_fuel_l

Fuel on board at take-off, from the Journey Log (actual), in litres

Take off fuel [JL][US Gal]

jl_take_off_fuel_usgal

Fuel on board at take-off, from the Journey Log (actual), in US gallons

Take off fuel [JL][t]

jl_take_off_fuel_t

Fuel on board at take-off, from the Journey Log (actual), in tonnes

Landing fuel [JL][lbs]

jl_landing_fuel_lbs

Fuel on board at landing, from the Journey Log (actual), in pounds

Landing fuel [JL][kg]

jl_landing_fuel_kg

Fuel on board at landing, from the Journey Log (actual), in kilograms

Landing fuel [JL][L]

jl_landing_fuel_l

Fuel on board at landing, from the Journey Log (actual), in litres

Landing fuel [JL][US Gal]

jl_landing_fuel_usgal

Fuel on board at landing, from the Journey Log (actual), in US gallons

Landing fuel [JL][t]

jl_landing_fuel_t

Fuel on board at landing, from the Journey Log (actual), in tonnes

Trip fuel [JL][lbs]

jl_trip_fuel_lbs

Difference between take off fuel and landing fuel

Trip fuel [JL][kg]

jl_trip_fuel_kg

Difference between take off fuel and landing fuel

Trip fuel [JL][L]

jl_trip_fuel_l

Difference between take off fuel and landing fuel

Trip fuel [JL][US Gal]

jl_trip_fuel_usgal

Difference between take off fuel and landing fuel

Trip fuel [JL][t]

jl_trip_fuel_t

Difference between take off fuel and landing fuel

Trip fuel difference [lbs]

jl_trip_fuel_diff_lbs

Trip fuel difference between journey log and plan

Trip fuel difference [kg]

jl_trip_fuel_diff_kg

Trip fuel difference between journey log and plan

Trip fuel difference [L]

jl_trip_fuel_diff_l

Trip fuel difference between journey log and plan

Trip fuel difference [US Gal]

jl_trip_fuel_diff_usgal

Trip fuel difference between journey log and plan

Trip fuel difference [t]

jl_trip_fuel_diff_t

Trip fuel difference between journey log and plan

Block fuel difference [lbs]

jl_block_fuel_diff_lbs

Block fuel difference between journey log and plan

Block fuel difference [kg]

jl_block_fuel_diff_kg

Block fuel difference between journey log and plan

Block fuel difference [L]

jl_block_fuel_diff_l

Block fuel difference between journey log and plan

Block fuel difference [US Gal]

jl_block_fuel_diff_usgal

Block fuel difference between journey log and plan

Block fuel difference [t]

jl_block_fuel_diff_t

Block fuel difference between journey log and plan

Remaining fuel difference [lbs]

jl_remaining_fuel_diff_lbs

Remaining fuel difference between journey log and plan

Remaining fuel difference [kg]

jl_remaining_fuel_diff_kg

Remaining fuel difference between journey log and plan

Remaining fuel difference [L]

jl_remaining_fuel_diff_l

Remaining fuel difference between journey log and plan

Remaining fuel difference [US Gal]

jl_remaining_fuel_diff_usgal

Remaining fuel difference between journey log and plan

Remaining fuel difference [t]

jl_remaining_fuel_diff_t

Remaining fuel difference between journey log and plan

SAF used [JL]

jl_saf_used

Amount of Sustainable Aviation Fuel (SAF) used, from the Journey Log (actual)

SAF fuel blend [JL]

jl_saf_fuel_blend

Sustainable Aviation Fuel (SAF) blend percentage, from the Journey Log (actual)

Fuel Prist [JL]

jl_fuel_prist

Fuel System Icing Inhibitor

Fuel uplift after [JL][lbs]

fuel_uplift_after_flight_lbs

Fuel uplifted after the flight, from the Journey Log (actual), in pounds

Fuel uplift after [JL][kg]

fuel_uplift_after_flight_kg

Fuel uplifted after the flight, from the Journey Log (actual), in kilograms

Fuel uplift after [JL][L]

fuel_uplift_after_flight_l

Fuel uplifted after the flight, from the Journey Log (actual), in litres

Fuel uplift after [JL][US Gal]

fuel_uplift_after_flight_usgal

Fuel uplifted after the flight, from the Journey Log (actual), in US gallons

Fuel uplift after [JL][t]

fuel_uplift_after_flight_t

Fuel uplifted after the flight, from the Journey Log (actual), in tonnes

Fuel uplift after density [JL]

fuel_uplift_after_flight_density

Density of fuel uplifted after the flight, from the Journey Log (actual)

Oil refilled [JL]

jl_oil_refilled

Whether engine oil was refilled, from the Journey Log (actual)

Oil uplift Engine 1 [JL][qt]

jl_oil_uplift_engine_1

Oil uplift for engine 1, from the Journey Log (actual), in quarts

Oil uplift Engine 2 [JL][qt]

jl_oil_uplift_engine_2

Oil uplift for engine 2, from the Journey Log (actual), in quarts

Oil uplift Engine 3 [JL][qt]

jl_oil_uplift_engine_3

Oil uplift for engine 3, from the Journey Log (actual), in quarts

Oil uplift Engine 4 [JL][qt]

jl_oil_uplift_engine_4

Oil uplift for engine 4, from the Journey Log (actual), in quarts

Oil uplift Engine 1 [JL][L]

jl_oil_uplift_engine_1_l

Oil uplift for engine 1, from the Journey Log (actual), in litres

Oil uplift Engine 2 [JL][L]

jl_oil_uplift_engine_2_l

Oil uplift for engine 2, from the Journey Log (actual), in litres

Oil uplift Engine 3 [JL][L]

jl_oil_uplift_engine_3_l

Oil uplift for engine 3, from the Journey Log (actual), in litres

Oil uplift Engine 4 [JL][L]

jl_oil_uplift_engine_4_l

Oil uplift for engine 4, from the Journey Log (actual), in litres

Fuel invoice [JL]

jl_fuel_invoice

Fuel invoice, from the Journey Log (actual)

Block fuel [W&B][lbs]

wb_block_fuel_lb

Total block fuel loaded (trip plus reserves), from Weight & Balance, in pounds

Block fuel [W&B][kg]

wb_block_fuel_kg

Total block fuel loaded (trip plus reserves), from Weight & Balance, in kilograms

Block fuel [W&B][L]

wb_block_fuel_l

Total block fuel loaded (trip plus reserves), from Weight & Balance, in litres

Block fuel [W&B][US Gal]

wb_block_fuel_usgal

Total block fuel loaded (trip plus reserves), from Weight & Balance, in US gallons

Block fuel [W&B][t]

wb_block_fuel_t

Total block fuel loaded (trip plus reserves), from Weight & Balance, in tonnes

Trip fuel [W&B][lbs]

wb_trip_fuel_lb

Fuel planned to be burned during the trip, from Weight & Balance, in pounds

Trip fuel [W&B][kg]

wb_trip_fuel_kg

Fuel planned to be burned during the trip, from Weight & Balance, in kilograms

Trip fuel [W&B][L]

wb_trip_fuel_l

Fuel planned to be burned during the trip, from Weight & Balance, in litres

Trip fuel [W&B][US Gal]

wb_trip_fuel_usgal

Fuel planned to be burned during the trip, from Weight & Balance, in US gallons

Trip fuel [W&B][t]

wb_trip_fuel_t

Fuel planned to be burned during the trip, from Weight & Balance, in tonnes

Taxi fuel [W&B][lbs]

wb_taxi_fuel_lb

Fuel allocated for taxiing, from Weight & Balance, in pounds

Taxi fuel [W&B][kg]

wb_taxi_fuel_kg

Fuel allocated for taxiing, from Weight & Balance, in kilograms

Taxi fuel [W&B][L]

wb_taxi_fuel_l

Fuel allocated for taxiing, from Weight & Balance, in litres

Taxi fuel [W&B][t]

wb_taxi_fuel_t

Fuel allocated for taxiing, from Weight & Balance, in tonnes

Taxi fuel [W&B][US Gal]

wb_taxi_fuel_usgal

Fuel allocated for taxiing, from Weight & Balance, in US gallons

Zero Fuel Weight [JL][lbs]

jl_zero_fuel_weight_lbs

Zero fuel weight (ZFW), from the Journey Log (actual), in pounds

Zero Fuel Weight [JL][kg]

jl_zero_fuel_weight_kg

Zero fuel weight (ZFW), from the Journey Log (actual), in kilograms

Taxi fuel [JL][L]

taxi_fuel_l

Fuel allocated for taxiing, from the Journey Log (actual), in litres

Taxi fuel [JL][US Gal]

taxi_fuel_usgal

Fuel allocated for taxiing, from the Journey Log (actual), in US gallons

Taxi fuel [JL][lbs]

taxi_fuel_lbs

Fuel allocated for taxiing, from the Journey Log (actual), in pounds

Taxi fuel [JL][kg]

taxi_fuel_kg

Fuel allocated for taxiing, from the Journey Log (actual), in kilograms

Fuel used difference amount[kg][JL - Plan]

used_fuel_difference_amount_kg

Amount of difference between planned and actual fuel used, difference between the actual (Journey Log) and planned value, in kilograms

Fuel used difference amount[lbs][JL - Plan]

used_fuel_difference_amount_lbs

Amount of difference between planned and actual fuel used, difference between the actual (Journey Log) and planned value, in pounds

Fuel used difference amount[lbs][JL]

planned_used_fuel_difference_amount_lbs

Amount of difference between planned and actual fuel used, from the Journey Log (actual), in pounds

Fuel used difference amount[kg][JL]

planned_used_fuel_difference_amount_kg

Amount of difference between planned and actual fuel used, from the Journey Log (actual), in kilograms

Journey Log & operational data

Column

Column key

Description

Date ADEP [JL][UTC]

date_STD_log_UTC

Departure date, from the Journey Log (actual), in UTC

Date ADES [JL][UTC]

date_STA_log_UTC

Arrival date, from the Journey Log (actual), in UTC

Date ADEP [JL][LT]

date_STD_log_LT

Departure date, from the Journey Log (actual), in local time

Date ADES [JL][LT]

date_STA_log_LT

Arrival date, from the Journey Log (actual), in local time

Landing No

JL_landing_no

Full stops + touch & go

Delay code [JL]

JL_delay_code

Delay code, from the Journey Log (actual)

Delay reason [JL]

JL_delay__reason

Reason for the delay, from the Journey Log (actual)

Feedback [JL]

jl_feedback

Feedback recorded for the flight, from the Journey Log (actual)

Holding [JL]

jl_holding

Holding performed, from the Journey Log (actual)

Price of uplift [JL][lbs]

jl_adep_fuel_price_of_uplift_lbs

Price of the fuel uplift, from the Journey Log (actual), in pounds

Price of uplift [JL][kg]

jl_adep_fuel_price_of_uplift_kg

Price of the fuel uplift, from the Journey Log (actual), in kilograms

Price of uplift [JL][L]

jl_adep_fuel_price_of_uplift_l

Price of the fuel uplift, from the Journey Log (actual), in litres

Price of uplift [JL][US Gal]

jl_adep_fuel_price_of_uplift_us_gal

Price of the fuel uplift, from the Journey Log (actual), in US gallons

Price of uplift [JL][t]

jl_adep_fuel_price_of_uplift_t

Price of the fuel uplift, from the Journey Log (actual), in tonnes

Price of uplift currency [JL]

jl_adep_fuel_price_of_uplift_unit

Currency of the fuel uplift price, from the Journey Log (actual)

Calculated price of uplift [JL]

jl_calculated_price_of_uplift

Calculated price of the fuel uplift, from the Journey Log (actual)

Calculated price of uplift currency [JL]

jl_calculated_price_of_uplift_currency

Currency of the calculated uplift price, from the Journey Log (actual)

Cost center [JL]

jl_adep_fuel_cost_center

Cost centre, from the Journey Log (actual)

Negotiated price currency [JL]

jl_fuel_provider_price_currency

Currency of the negotiated price, from the Journey Log (actual)

Negotiated price [JL][lbs]

jl_fuel_provider_price_lbs

Negotiated price, from the Journey Log (actual), in pounds

Negotiated price [JL][kg]

jl_fuel_provider_price_kg

Negotiated price, from the Journey Log (actual), in kilograms

Negotiated price [JL][L]

jl_fuel_provider_price_l

Negotiated price, from the Journey Log (actual), in litres

Negotiated price [JL][US Gal]

jl_fuel_provider_price_us_gal

Negotiated price, from the Journey Log (actual), in US gallons

Negotiated price [JL][t]

jl_fuel_provider_price_t

Negotiated price, from the Journey Log (actual), in tonnes

Congested area [JL]

jl_congested_area

Congested area as recorded in the Journey Log

ASU [JL]

jl_asu

ASU as recorded in the Journey Log

ASU Time [JL]

jl_asu_time

Air start unit (ASU) usage time, from the Journey Log (actual)

Stand number [JL]

jl_stand_number

Parking stand number, from the Journey Log (actual)

Takeoffs [JL]

jl_takeoffs

Number of take-offs, from the Journey Log (actual)

Go around [JL]

jl_go_around

Number of go-arounds, from the Journey Log (actual)

AWOPS [JL]

jl_awops

All Weather Operations

RAW DATA TKOF/DEP [JL]

jl_raw_data_takeoff

RAW DATA TKOF/DEP is the equivalent of an aircraft approach without a flight director, but applied to takeoff.

NVG sectors [JL]

jl_night_vision_flights

NVG sectors as recorded in the Journey Log

Low level time [JL]

jl_low_level_time

Time spent flying at low level, from the Journey Log (actual)

TOS start [JL]

jl_time_on_station_start

Time on station start

TOS end [JL]

jl_time_on_station_end

Time on station end

TOS [JL]

jl_time_on_station

Time on station

Planned trip time [JL]

jl_planned_trip_time

Planned total trip duration, from the Journey Log (actual)

L3Harris status

jl_l3harris_status

L3Harris data integration status

Dispatch feedback [JL]

jl_dispatch_feedback

Dispatch feedback recorded for the flight, from the Journey Log (actual)

Other feedback [JL]

jl_other_feedback

Other feedback recorded for the flight, from the Journey Log (actual)

Single Engine Taxi In [JL]

jl_single_engine_taxi_in

Single-engine taxi-in time, from the Journey Log (actual)

Single Engine Taxi Out [JL]

jl_single_engine_taxi_out

Single-engine taxi-out time, from the Journey Log (actual)

Approach

approach

Approach performed

Approach type

approach_type

Type of approach flown

Flight Log [JL]

flight_log

Techlog Number

Previous Flight Log [JL]

previous_flight_log

Tech log number of the previous flight, from the Journey Log (actual)

CO2 emission [JL][t]

co2_emission

Used fuel value inserted in Journey Log (divided by 1000 to show the value in tones) multiplied by a constant factor for 'JET-A' fuel (3.16) or 'AVGAS' fuel (3.10)

CO2 emission (FBU FR U) [JL][t]

co2_emission_method_b

Difference between Fuel before uplift and Fuel remaining, increased by Uplift value from JL (in tons), multiplied by a constant factor: 3.16 for JET-A and 3.10 for AVGAS

CO2 emission (BF FR) [JL][t]

co2_emission_block_on_block_off

Difference between Block fuel & Fuel remaining value from JL (in tons), multiplied by a constant factor: 3.16 for JET-A and 3.10 for AVGAS

CO2 emission (U) [JL][t]

co2_emission_uplift

Uplift fuel value from JL (in tons), multiplied by a constant factor: 3.16 for JET-A and 3.10 for AVGAS

Note [JL]

JL_note

Free-text note, from the Journey Log (actual)

Custom code [JL]

JL_custom_code

Custom code as recorded in the Journey Log

HUD/EVS [JL]

JL_hud_evs

HUD/EVS as recorded in the Journey Log

Status [JL]

jl_status

Status of the flight, from the Journey Log (actual)

Discretion for extension [JL]

jl_commanders_discretion

Discretion for extension as recorded in the Journey Log

Night take off [JL]

JL_night_take_off

Number of night take-offs, from the Journey Log (actual)

Night landing [JL]

JL_night_landing

Number of night landings, from the Journey Log (actual)

Runway [JL]

jl_runway

Runway used, from the Journey Log (actual)

End of flight reason [JL]

jl_end_of_flight_reason

Reason recorded for the end of the flight, from the Journey Log (actual)

VOR type [JL]

jl_vor_type

Type of VOR check, from the Journey Log (actual)

VOR ID [JL]

jl_vor_id

VOR identifier checked, from the Journey Log (actual)

VOR frequency [JL]

jl_vor_frequency

Frequency of the checked VOR, from the Journey Log (actual)

VOR deviation [JL]

jl_vor_deviation

Recorded VOR deviation, from the Journey Log (actual)

Voyage report number [JL]

voyage_report_number

Voyage report number, from the Journey Log (actual)

GPU [JL]

jl_gpu

GPU as recorded in the Journey Log

GPU Time [JL]

jl_gpu_time

Ground power unit (GPU) usage time, from the Journey Log (actual)

Client's satisfaction [JL]

jl_client_satisfaction

Recorded client satisfaction, from the Journey Log (actual)

ACU [JL]

jl_acu

ACU as recorded in the Journey Log

Autoland [JL]

jl_autoland

Whether an autoland was performed, from the Journey Log (actual)

LVTO < 150 m [JL]

jl_lvto_below_150m

Low visibility take-off (below 150 m)

LVTO 150 m - 500 m [JL]

jl_lvto_above_150m

Low visibility take-off (between 150 m)

CAT II APP/LND [JL]

jl_appr_lnd_cat_2

CAT II APP/LND as recorded in the Journey Log

APP/LND PERFO STATIS [JL]

jl_appr_lnd_perfo_statis

APP/LND PERFO STATIS as recorded in the Journey Log

Files links [JL]

jl_files_links

Links to files attached to the flight, from the Journey Log (actual)

CMT [JL]

log_cmt

Crew member comment, from the Journey Log (actual)

Latitude dec ADEP[JL]

jl_start_airport_latitude_dec

Latitude of the departure airport in decimal degrees, from the Journey Log (actual)

Latitude dec ADES[JL]

jl_end_airport_latitude_dec

Latitude of the destination airport in decimal degrees, from the Journey Log (actual)

Longitude dec ADEP[JL]

jl_start_airport_longitude_dec

Longitude of the departure airport in decimal degrees, from the Journey Log (actual)

Longitude dec ADES[JL]

jl_end_airport_longitude_dec

Longitude of the destination airport in decimal degrees, from the Journey Log (actual)

Is last leg in a trip? [JL]

is_last_leg_in_a_trip_jl

Whether this is the last leg of the trip, from the Journey Log (actual)

Route ICAO [JL]

jl_route_icao

Full route of the trip in ICAO format, from the Journey Log (actual)

Number of legs in a trip [JL]

jl_number_of_legs_in_a_trip

Number of legs in the trip, from the Journey Log (actual)

Last modified by [JL]

jl_last_modified_by

User who last modified the flight, from the Journey Log (actual)

Last modified date [JL][UTC]

jl_last_modified_date

Date the flight was last modified, from the Journey Log (actual), in UTC

ASR [JL]

asr_jl

ASR as recorded in the Journey Log

Flight has a log?

flight_has_log

Whether the flight has a Journey Log

REGCAUSE [FW]

fw_regcause

Regularity / delay cause code (REGCAUSE), from Flight Watch (live movement tracking)

Technical & maintenance

Column

Column key

Description

Tyre pressure check performed [JL]

jl_tire_pressure_check_performed

Tyre pressure check performed as recorded in the Journey Log

Tyre pressure note [JL]

jl_tyre_pressure_note

Tyre pressure note as recorded in the Journey Log

CAMO notes [JL]

jl_camo_notes

CAMO (continuing airworthiness) notes, from the Journey Log (actual)

HHO cycles [JL]

jl_hoist_mission

Helicopter hoist operation (HHO) cycles, from the Journey Log (actual)

Avionics database update [JL]

jl_avionics_database_update

Avionics database update as recorded in the Journey Log

TAH

tah

Total aircraft hours

TAC

tac

Total aircraft cycles

TAH Engines

tah_engines

Total hours for the engines

TAH Engine 1

tah_engine_1

Total hours for engine 1

TAH Engine 2

tah_engine_2

Total hours for engine 2

TAH Engine 3

tah_engine_3

Total hours for engine 3

TAH Engine 4

tah_engine_4

Total hours for engine 4

TAC Engines

tac_engines

Total cycles for the engines

TAC Engine 1

tac_engine_1

Total cycles for engine 1

TAC Engine 2

tac_engine_2

Total cycles for engine 2

TAC Engine 3

tac_engine_3

Total cycles for engine 3

TAC Engine 4

tac_engine_4

Total cycles for engine 4

APU hours [JL]

JL_APU_hours

APU operating hours, from the Journey Log (actual)

APU cycles [JL]

jl_total_apu_cycles

APU cycles, from the Journey Log (actual)

Maintenance log entry [JL]

jl_maintenance_log_entry

Maintenance log entry, from the Journey Log (actual)

Nav database update [JL]

jl_nav_database_update

Nav database update as recorded in the Journey Log

TAH limit

tah_limit

Total aircraft hours limit

TAC limit

tac_limit

Total aircraft cycles limit

Date limit

date_limit

Date limit for the next maintenance

Permits, slots & handling

Column

Column key

Description

Handling satisfactory [JL]

jl_handling_satisfactory

Handling satisfactory as recorded in the Journey Log

Handling satisfactory notes [JL]

jl_handling_satisfactory_notes

Handling satisfactory notes as recorded in the Journey Log

Handling rating [JL]

jl_handling_rating

Rating of the handling agent, from the Journey Log (actual)

Handling rating description [JL]

jl_handling_rating_description

Description of the handling rating, from the Journey Log (actual)

Handling rating ADEP [JL]

jl_handling_rating_adep

Rating of the handling agent at departure, from the Journey Log (actual)

Handling rating ADES [JL]

jl_handling_rating_ades

Rating of the handling agent at destination, from the Journey Log (actual)

Handler name [ADEP]

ADEPHandlerName

Name of the handling agent

Handler name [ADES]

ADESHandlerName

Name of the handling agent

Handler email [ADEP]

ADEPHandlerEmail

Email of the handling agent

Handler email [ADES]

ADESHandlerEmail

Email of the handling agent

Handler telephone [ADEP]

ADEP_handler_phone

Telephone of the handling agent

Handler telephone [ADES]

ADES_handler_phone

Telephone of the handling agent

Handler address [ADEP]

ADEP_handler_address1

Address of the handling agent

Handler address [ADES]

ADES_handler_address1

Address of the handling agent

Handler second address [ADEP]

ADEP_handler_address2

Second address of the handling agent

Handler second address [ADES]

ADES_handler_address2

Second address of the handling agent

Cargo handler name [ADEP]

ADEPCargoHandlerName

Name of the cargo handling agent

Cargo handler name [ADES]

ADESCargoHandlerName

Name of the cargo handling agent

Cargo handler email [ADEP]

ADEPCargoHandlerEmail

Email of the cargo handling agent

Cargo handler email [ADES]

ADESCargoHandlerEmail

Email of the cargo handling agent

Cargo handler telephone [ADEP]

ADEP_cargo_handler_phone

Telephone of the cargo handling agent

Cargo handler telephone [ADES]

ADES_cargo_handler_phone

Telephone of the cargo handling agent

Cargo handler address [ADEP]

ADEP_cargo_handler_address1

Address of the cargo handling agent

Cargo handler address [ADES]

ADES_cargo_handler_address1

Address of the cargo handling agent

Cargo handler second address [ADEP]

ADEP_cargo_handler_address2

Second address of the cargo handling agent

Cargo handler second address [ADES]

ADES_cargo_handler_address2

Second address of the cargo handling agent

Overflight Permit Number

overflight_permit_number

Overflight permit number

Landing Permit Number

landing_permit_number

Landing permit number

Overflight Permit Validity

overflight_permit_validity

Overflight permit validity

Landing Permit Validity

landing_permit_validity

Landing permit validity

Overflight Permit Revalidation

overflight_permit_revalidation

Overflight permit revalidation

Landing Permit Revalidation

landing_permit_revalidation

Landing permit revalidation

Overflight Permit Entry Point

overflight_permit_entry_point

Overflight permit entry point

Landing Permit Entry Point

landing_permit_entry_point

Landing permit entry point

Overflight Permit Exit Point

overflight_permit_exit_point

Overflight permit exit point

Landing Permit Exit Point

landing_permit_exit_point

Landing permit exit point

Overflight Permit Supplier

overflight_permit_supplier

Overflight permit supplier

Landing Permit Supplier

landing_permit_supplier

Landing permit supplier

Overflight Permit Short Notice (yes/no)

overflight_permit_short_notice

Whether the overflight permit was short notice

Landing Permit Short Notice (yes/no)

landing_permit_short_notice

Whether the landing permit was short notice

Overflight Permit Status

overflight_permit_status

Overflight permit status

Landing Permit Status

landing_permit_status

Landing permit status

Overflight Permit Country

overflight_permit_country

Country of the overflight permit

Overflight Permit Country Name

overflight_permit_country_name

Country name of the overflight permit

Landing Permit Country

landing_permit_country

Country of the landing permit

Handling payment method [ADEP]

adep_handling_payment_method

Handling payment method

Handling payment method [ADES]

ades_handling_payment_method

Handling payment method

Checklist & ground services

Column

Column key

Description

Route & area competency briefed [JL]

jl_route_area_competency_briefed

Route & area competency briefed as recorded in the Journey Log

A/C disinfected [JL]

jl_ac_disinfected

aircraft disinfected as recorded in the Journey Log

Wi-Fi [JL]

jl_wifi

In-flight Wi-Fi status, from the Journey Log (actual)

Security check [JL]

jl_security_check

Security check as recorded in the Journey Log

Safety/Security notes [JL]

jl_safety_notes

Safety/Security notes as recorded in the Journey Log

Schedule revision reason [JL]

jl_schedule_revision_reason

Schedule revision reason as recorded in the Journey Log

Ops interruptions [JL]

jl_ops_interruptions

Ops interruptions as recorded in the Journey Log

Ops interruptions details [JL]

jl_ops_interruptions_note

Ops interruptions details as recorded in the Journey Log

GNSS Issues Encountered [JL]

jl_gnss_issues_encourntered

GNSS Issues Encountered as recorded in the Journey Log

GNSS issues note [JL]

jl_gnss_issues_note

GNSS issues note as recorded in the Journey Log

Pre-Flight Documentation completed & Sent [JL]

jl_pre_flight_documentation_completed_sent

Pre-Flight Documentation completed & Sent as recorded in the Journey Log

Use of controlled rest in cockpit [JL]

jl_controlled_rest_in_cockpit

Use of controlled rest in cockpit as recorded in the Journey Log

Use of controlled rest in cockpit note [JL]

jl_controlled_rest_in_cockpit_note

Use of controlled rest in cockpit note as recorded in the Journey Log

Pre-Flight PIC KSS [JL]

jl_pre_flight_pic_kss

Pre-Flight PIC KSS as recorded in the Journey Log

Pre-Flight SIC KSS [JL]

jl_pre_flight_sic_kss

Pre-Flight SIC KSS as recorded in the Journey Log

Pre-Flight AUG1 KSS [JL]

jl_pre_flight_aug1_kss

Pre-Flight AUG1 KSS as recorded in the Journey Log

Pre-Flight AUG2 KSS [JL]

jl_pre_flight_aug2_kss

Pre-Flight AUG2 KSS as recorded in the Journey Log

Post-Flight PIC KSS [JL]

jl_post_flight_pic_kss

Post-Flight PIC KSS as recorded in the Journey Log

Post-Flight SIC KSS [JL]

jl_post_flight_sic_kss

Post-Flight SIC KSS as recorded in the Journey Log

Post-Flight AUG1 KSS [JL]

jl_post_flight_aug1_kss

Post-Flight AUG1 KSS as recorded in the Journey Log

Post-Flight AUG2 KSS [JL]

jl_post_flight_aug2_kss

Post-Flight AUG2 KSS as recorded in the Journey Log

Active Nav Log Signed & Completed [JL]

jl_active_nav_log_signed_completed

Active Nav Log Signed & Completed as recorded in the Journey Log

Catering [JL]

jl_catering

Catering as recorded in the Journey Log

Ice [JL]

jl_ice

Ice as recorded in the Journey Log

Hot water [JL]

jl_hot_water

Hot water as recorded in the Journey Log

Washing dishes [JL]

jl_washing_dishes

Washing dishes as recorded in the Journey Log

Laundry [JL]

jl_laundry

Laundry as recorded in the Journey Log

A/C cleaning [JL]

jl_ac_cleaning

aircraft cleaning as recorded in the Journey Log

Hangar [JL]

jl_hangar

Hangar arrangements, from the Journey Log (actual)

Hangar notes [JL]

jl_hangar_notes

Hangar notes as recorded in the Journey Log

Confirmation of data correctness [JL]

jl_confirmation_of_data_correctness

Confirmation of data correctness as recorded in the Journey Log

Confirmation of data correctness note [JL]

jl_confirmation_of_data_correctness_note

Confirmation of data correctness note as recorded in the Journey Log

Alcohol test [JL]

jl_alcohol_test

Alcohol test as recorded in the Journey Log

Deicing notes [JL]

jl_deicing_notes

Free-text de-icing notes, from the Journey Log (actual)

Deicing - type of fluid [JL]

jl_deicing_type_of_fluid

Type of de-icing fluid used, from the Journey Log (actual)

Cleaned [JL]

jl_aircraft_cleaned

Cleaned as recorded in the Journey Log

Re-Stocked [JL]

jl_aircraft_restocked

Re-Stocked as recorded in the Journey Log

Limousine ADEP supplier [Chkl]

ADEP_pax_transport_name

Limousine supplier at the departure airport

Limousine ADES supplier [Chkl]

ADES_pax_transport_name

Limousine supplier at the destination airport

Invoice Note [Chkl]

invoice_item_note

Free-text invoice note

Payments Status[Chkl]

checklist_payments_status

Checklist record: Payments Status

Payments Notes[Chkl]

checklist_payments_note

Checklist record: Payments Notes

Operational Flight Plan[Chkl]

checklist_operational_flight_plan

Checklist record: Operational Flight Plan

Operational Flight Plan Status [Chkl]

checklist_item_operational_flight_plan_status

Checklist record: Operational Flight Plan Status

Catering and ground transport Note [Chkl]

checklist_item_catering_and_ground_transport_note

Checklist record: Catering and ground transport Note

Catering Note [Chkl]

checklist_item_catering_note

Checklist record: Catering Note

Catering Status [Chkl]

checklist_item_catering_status

Checklist record: Catering Status

Catering Confirmation Code [Chkl]

checklist_item_catering_confirmation_code

Catering booking confirmation code

Caterer name

caterer_name

Name of the caterer

Duty Status [Chkl]

checklist_item_duty_status

Checklist record: Duty Status

Duty Note [Chkl]

checklist_item_note_note

Checklist record: Duty Note

Health Requirements Status [Chkl]

checklist_item_health_requirements_status

Checklist record: Health Requirements Status

Health Requirements (CREW) Status[Chkl]

checklist_item_health_requirements_crew_status

Checklist record: Health Requirements (CREW) Status

Pax Transport ADEP Note [Chkl]

checklist_item_pax_transport_adep_note

Checklist record: Pax Transport departure Note

Pax Transport ADES Note [Chkl]

checklist_item_pax_transport_ades_note

Checklist record: Pax Transport destination Note

Hotel Note [Chkl]

checklist_item_hotel_note

Checklist record: Hotel Note

Hotel Name [Chkl]

checklist_item_hotel_name

Name of the crew hotel

Hotel Status [Chkl]

checklist_item_hotel_status

Checklist record: Hotel Status

Hotel Confirmation Code [Chkl]

checklist_item_hotel_confirmation_code

Hotel booking confirmation code

Parking Notes [Chkl]

parking_notes

Checklist record: Parking Notes

Parking Status [Chkl]

checklist_item_parking_status

Checklist record: Parking Status

ATC flight plan Note [Chkl]

checklist_item_atc_flight_plan_note

Checklist record: ATC flight plan Note

EROPS [Chkl]

checklist_item_atc_flight_plan_erops

Checklist record: EROPS

PPR ADES Note [Chkl]

checklist_item_ppr_note

Checklist record: PPR destination Note

PPR ADES Status [Chkl]

checklist_item_ppr_status

Checklist record: PPR destination Status

PPR ADEP Note [Chkl]

checklist_item_ppr_adep_note

Checklist record: PPR departure Note

PPR ADEP Status [Chkl]

checklist_item_ppr_adep_status

Checklist record: PPR departure Status

Landing Permit status [Chkl]

checklist_item_landing_permit_status

Landing permit status

Landing Permit Note [Chkl]

checklist_item_landing_permit_note

Free-text landing permit note

Overflight Permit status [Chkl]

checklist_item_overflight_permit_status

Overflight permit status

Overflight Permit Note [Chkl]

checklist_item_overflight_permit_note

Free-text overflight permit note

API (ADEP) Status [Chkl]

checklist_item_api_adep_status

Checklist record: API (departure) Status

API (ADEP) Note [Chkl]

checklist_item_api_adep_note

Checklist record: API (departure) Note

API (ADES) Status [Chkl]

checklist_item_api_ades_status

Checklist record: API (destination) Status

API (ADES) Note [Chkl]

checklist_item_api_ades_note

Checklist record: API (destination) Note

Slots ADEP Note [Chkl]

checklist_item_slots_adep_note

Checklist record: Slots departure Note

Slots ADEP Status [Chkl]

checklist_item_slots_adep_status

Checklist record: Slots departure Status

Slots ADES Note [Chkl]

checklist_item_slots_ades_note

Checklist record: Slots destination Note

Slots ADES Status [Chkl]

checklist_item_slots_ades_status

Checklist record: Slots destination Status

Handling ADEP Note [Chkl]

checklist_item_handling_adep_note

Checklist record: Handling departure Note

Handling ADEP Status [Chkl]

checklist_item_handling_adep_status

Checklist record: Handling departure Status

Handling ADES Note [Chkl]

checklist_item_handling_ades_note

Checklist record: Handling destination Note

Handling ADES Status [Chkl]

checklist_item_handling_ades_status

Checklist record: Handling destination Status

Handling ADEP confirmation code [Chkl]

checklist_item_handling_adep_confirmation_code

Handling confirmation code at departure

Handling ADES confirmation code [Chkl]

checklist_item_handling_ades_confirmation_code

Handling confirmation code at destination

Limousine ADEP Note [Chkl]

checklist_item_limousine_adep_note

Checklist record: Limousine departure Note

Limousine ADES Note [Chkl]

checklist_item_limousine_ades_note

Checklist record: Limousine destination Note

Limousine ADEP Status [Chkl]

checklist_item_limousine_ADEP_status

Checklist record: Limousine departure Status

Limousine ADES Status [Chkl]

checklist_item_limousine_ADES_status

Checklist record: Limousine destination Status

Flight Risk Analysis Status [Chkl]

checklist_item_flight_risk_analysis_status

Checklist record: Flight Risk Analysis Status

Flight Risk Analysis Note [Chkl]

checklist_item_flight_risk_analysis_note

Checklist record: Flight Risk Analysis Note

Invoice Status [Chkl]

checklist_item_invoice_status

Invoice status

Plan RRLD [Chkl]

checklist_item_rrld_status

Reduced Required Landing Distance

Schedule revision reason [Chkl]

checklist_item_schedule_revision_reason

Checklist record: Schedule revision reason

Deicing [JL]

JL_deicing

Whether de-icing was performed, from the Journey Log (actual)

Deicing quantity [JL][L]

jl_deicing_quantity

Quantity of de-icing fluid used, from the Journey Log (actual), in litres

Cat B brief completed [JL]

cat_b_brief_completed_log

Cat B brief completed as recorded in the Journey Log

Radio communication report [JL]

jl_radio_communication_report

Radio communication report as recorded in the Journey Log

A/C disinsected [JL]

jl_ac_disinsected

aircraft disinsected as recorded in the Journey Log

Air conditioning [JL]

jl_air_conditioning

Air conditioning as recorded in the Journey Log

Waste [JL]

jl_waste

Waste as recorded in the Journey Log

Waste non EU [JL]

jl_waste_non_eu

Waste non EU as recorded in the Journey Log

Laundry note [JL]

jl_laundry_note

Laundry note as recorded in the Journey Log

Deicing - time of application [JL]

jl_deicing_time_of_application

Time of de-icing fluid application, from the Journey Log (actual)

SAFA Ramp check [JL]

jl_safe_ramp_check

European Programme regarding the performance of ramp inspections on aircraft used by third country operators (SAFA)

COR/MOR completed [JL]

jl_cor_mor_completed

Company occurrence report / mandatory occurrence report

EROPS [JL]

jl_erops

EROPS as recorded in the Journey Log

De-icing fluid check [JL]

jl_de_icing_fluid_check

De-icing fluid check as recorded in the Journey Log

Toilet service [JL]

jl_toilet_service

Toilet service as recorded in the Journey Log

RRLD [JL]

jl_reduced_required_landing_distance

Reduced Required Landing Distance

ETOPS [JL]

jl_etops

Extended Range Twin Engine Operations

Cabin defects [JL]

jl_cabin_defects

Cabin defects as recorded in the Journey Log

Cockpit handover notes [JL]

handover_notes

Cockpit handover notes as recorded in the Journey Log

Cabin handover notes [JL]

jl_cabin_handover_notes

Cabin handover notes as recorded in the Journey Log

Documentation completed according OM-A [JL]

jl_documentation_completed_according_oma

Documentation completed according OM-A as recorded in the Journey Log

PPR Alternate Note [Chkl]

checklist_item_ppr_alternate_note

Checklist record: PPR Alternate Note

PPR Alternate Status [Chkl]

checklist_item_ppr_alternate_status

Checklist record: PPR Alternate Status

PNR GO Note [Chkl]

checklist_item_pnr_go_note

Checklist record: PNR GO Note

PNR GO Status [Chkl]

checklist_item_pnr_go_status

Checklist record: PNR GO Status

Airspace requirements

checklist_item_airspace_requirements

Airspace requirements for the flight

VIP Lounge ADEP Status [Chkl]

checklist_item_vip_lounge_adep_status

Checklist record: VIP Lounge departure Status

VIP Lounge ADES Status [Chkl]

checklist_item_vip_lounge_ades_status

Checklist record: VIP Lounge destination Status

Contract Signed Note [Chkl]

checklist_contract_signed_note

Checklist record: Contract Signed Note

Contract Signed Status [Chkl]

checklist_contract_signed_status

Checklist record: Contract Signed Status

In-flight Rest Facility [JL]

jl_rest_facility

Type of in-flight rest facility available, from the Journey Log (actual)

Flight Package Sent Status [Chkl]

checklist_item_flight_package_sent_status

Checklist record: Flight Package Sent Status

Flight Package Sent Note [Chkl]

checklist_item_flight_package_sent_note

Checklist record: Flight Package Sent Note

ATC Flight Plan Status Status [Chkl]

checklist_item_atc_flight_plan_status_status

Checklist record: ATC Flight Plan Status Status

ATC Flight Plan Status Note [Chkl]

checklist_item_atc_flight_plan_status_note

Checklist record: ATC Flight Plan Status Note

Test Flight Plan Status [Chkl]

checklist_item_test_flight_plan_status

Checklist record: Test Flight Plan Status

Test Flight Plan Note [Chkl]

checklist_item_test_flight_plan_note

Checklist record: Test Flight Plan Note

Parking stand ADEP Status [Chkl]

checklist_item_parking_stand_adep_status

Checklist record: Parking stand departure Status

Parking stand ADEP Note [Chkl]

checklist_item_parking_stand_adep_note

Checklist record: Parking stand departure Note

Parking stand ADEP [Chkl]

checklist_item_parking_stand_adep

Parking stand at the departure airport

Parking stand ADES Status [Chkl]

checklist_item_parking_stand_ades_status

Checklist record: Parking stand destination Status

Parking stand ADES Note [Chkl]

checklist_item_parking_stand_ades_note

Checklist record: Parking stand destination Note

Parking stand ADES [Chkl]

checklist_item_parking_stand_ades

Parking stand at the destination airport

Sales & commercial

Column

Column key

Description

Client name

client_name

Name of the client

Client representative name

client_representative_name

Name of the client's representative

Client code

client_code

Code of the client

Client representative code

client_representative_code

Code of the client's representative

Client label

client_label

Label assigned to the client

Accounting projects

projects

Accounting projects assigned to the flight

Quotation Number (Trip tab)

legacy_offer_number

Quotation number from the trip tab

Trip price

offer_price

Total price of the trip

Trip VAT %

offer_vat

VAT rate applied to the trip

Trip VAT

offer_vat_amount

VAT amount on the trip

Offer currency

offer_currency

Currency of the offer

Sales Note

sales_note

Free-text sales note

Sales Supervisor

sales_supervisor

Sales supervisor responsible for the flight

Quote Request Unique ID

quote_request_unique_id

Unique identifier of the quote request

Quote Request ID

quote_number

Sales quote request identifier

Quote Unique ID

quote_unique_id

Unique identifier of the quote

Invoice Number

invoice_no

Invoice number

Flight Time [Quote]

quote_flight_time

Flight time from Quote booked in Sales module

Invoice Price

invoice_price

Invoiced price

Assignee

assignee

User assigned to the flight

Assignee code

assignee_code

Code of the user assigned to the flight

Customer Service Assignee

customer_service_assignee

Customer-service user assigned to the flight

Operator Billing Country

operator_billing_country

Billing country of the operator

Environmental & taxes

Column

Column key

Description

EU ETS Annex I exceptions

EU_ETS_exceptions

EU ETS Annex I exceptions applicable to the flight

Estimated CO2 emission [t]

co2_emission_estimated

Used fuel calculated based on aircraft performance model (divided by 1000 to show the value in tones) multiplied by a constant factor for 'JET-A' fuel (3.16) or 'AVGAS' fuel (3.10)

CO2 Offsetting name

carbon_offset_definition_name

Name of the CO₂ offsetting scheme

CO2 Offsetting price

carbon_offset_definition_price

Price of the CO₂ offset

CO2 Offsetting amount

carbon_offset_definition_amount

Amount of CO₂ offset

Risk scoring ADEP

risk_scoring_adep

Security risk score of the departure airport

Risk scoring ADES

risk_scoring_ades

Security risk score of the destination airport

Risk scoring country ADEP

risk_scoring_country_adep

Security risk score of the departure country

Risk scoring country ADES

risk_scoring_country_ades

Security risk score of the destination country

Italian Luxury Tax EUR

italian_luxury_tax

Italian Luxury Tax applied to the flight, in EUR

German Aviation Tax EUR

german_aviation_tax

German Aviation Tax applied to the flight, in EUR

Swedish Aviation Tax SEK

swedish_aviation_tax

Swedish Aviation Tax applied to the flight, in SEK

Austrian Air Transport Levy EUR

austrian_air_transport_levy

Austrian Air Transport Levy applied to the flight, in EUR

Belgium Embarkation Tax EUR

belgium_embarkation_tax

Belgium Embarkation Tax applied to the flight, in EUR

Portuguese Carbon Tax EUR

portuguese_carbon_tax

Portuguese Carbon Tax applied to the flight, in EUR

French Civil Aviation Tax EUR

french_civil_aviation_tax

French Civil Aviation Tax applied to the flight, in EUR

French Noise Tax EUR

french_noise_tax

French Noise Tax applied to the flight, in EUR

Dutch Aviation Tax EUR

dutch_aviation_tax

Dutch Aviation Tax applied to the flight, in EUR

US Segment Tax USD

us_segment_tax

US Segment Tax applied to the flight, in USD

French Solidarity Tax EUR

french_solidarity_tax

French Solidarity Tax applied to the flight, in EUR

Italian Luxury Tax Breakdown

italian_luxury_tax_breakdown

Breakdown of the Italian Luxury Tax applied to the flight

German Aviation Tax Breakdown

german_aviation_tax_breakdown

Breakdown of the German Aviation Tax applied to the flight

Swedish Aviation Tax Breakdown

swedish_aviation_tax_breakdown

Breakdown of the Swedish Aviation Tax applied to the flight

Austrian Air Transport Levy Breakdown

austrian_air_transport_levy_breakdown

Breakdown of the Austrian Air Transport Levy applied to the flight

Belgium Embarkation Tax Breakdown

belgium_embarkation_tax_breakdown

Breakdown of the Belgium Embarkation Tax applied to the flight

Portuguese Carbon Tax Breakdown

portuguese_carbon_tax_breakdown

Breakdown of the Portuguese Carbon Tax applied to the flight

French Civil Aviation Tax Breakdown

french_civil_aviation_tax_breakdown

Breakdown of the French Civil Aviation Tax applied to the flight

French Noise Tax Breakdown

french_noise_tax_breakdown

Breakdown of the French Noise Tax applied to the flight

Dutch Aviation Tax Breakdown

dutch_aviation_tax_breakdown

Breakdown of the Dutch Aviation Tax applied to the flight

US Segment Tax Breakdown

us_segment_tax_breakdown

Breakdown of the US Segment Tax applied to the flight

French Solidarity Tax Breakdown

french_solidarity_tax_breakdown

Breakdown of the French Solidarity Tax applied to the flight

Notes, tags & metadata

Column

Column key

Description

Note [FW]

FW_note

Free-text note, from Flight Watch (live movement tracking)

Tags

flightTags

Tags assigned to the flight

Flight Tags

flight_tags_only

Tags assigned to the flight

Trip Tags

trip_tags_only

Tags assigned to the trip

OPS Note

ops_note

Free-text operations note

Trip Note

trip_notes

Free-text trip note

AOC

aoc

Air Operator Certificate under which the flight is operated

MVT emails

mvt_emails

Take off and landing emails

Day note

day_note

Free-text note for the day

Trip Supplementary Info

trip_supplementary_info

Supplementary information about the trip

Flight status & metadata

Column

Column key

Description

Ferry

is_ferry

Whether the flight is a ferry flight

CNL [Plan]

cnl

Whether the flight is cancelled, planned

Domestic/International

domestic_or_international

Whether the flight is domestic or international

Flight status

flight_status

Current status of the flight

Initial flight status

initial_flight_status

Initial status of the flight

Created by [Plan]

flight_created_by

User who created the flight, planned

Creation date [Plan][UTC]

flight_created_date

Date the flight was created, planned, in UTC

CNL by [Plan]

flight_canceled_by

User who cancelled the flight, planned

CNL date [Plan][UTC]

flight_canceled_date

Date the flight was cancelled, planned, in UTC

Schedule last modified [Plan][UTC]

schedule_last_modified

Date the schedule was last modified, planned, in UTC

Ferry paid

ferry_paid

Whether the ferry flight is paid

Diff Creation - ADEP Date [Plan][UTC]

diff_creation_adep_date_plan_utc

Time between flight creation and the departure date, planned, in UTC

Flight is TBC?

flight_is_tbc

Whether the flight is to be confirmed (TBC)


Available filters

Filters let you narrow down the data to the specific subset you need. Every report is bounded by a date range (the source of the date — scheduled, Journey Log, or Flight Watch — is itself selectable via the Date range source type filter). All other filters below are optional and can be combined.

The same source/unit tags used by columns apply: [Plan] planned · [JL] Journey Log · [FW] Flight Watch · [UTC] / [LT] time zone · [mins] / [lbs] units.

There are 118 optional filters, grouped below.

Filter — Aircraft & fleet

Filter

Filter key

Description

Aircraft

acftList

Include only the selected aircraft

Excluded aircraft

excluded_operator_aircraft_list

Exclude the selected aircraft

Aircraft type

acftTypeList

Filter by aircraft type

Aircraft labels

operator_aircraft_label_list

Filter by labels assigned to the aircraft

Aircraft status

aircraft_status

Filter by aircraft status (e.g. active, inactive)

Aircraft Operating Certificate (AOC)

aircraftOperatingCertificate

Filter by whether the aircraft has an AOC

Aircraft base

aircraft_operator_base_nid_list

Filter by the aircraft home base

MTOW above [lbs]

MTOWAboveLbs

Only aircraft with MTOW above the given value (lbs)

MTOW below [lbs]

MTOWBelowLbs

Only aircraft with MTOW below the given value (lbs)

Exclude virtual fleet

excludeVirtualFleet

Exclude virtual (placeholder) aircraft

Filter — Operator & AOC

Filter

Filter key

Description

Operator

operator

Filter by operator

AOC

aoc_list

Filter by Air Operator Certificate (AOC)

Filter — Route & airports

Filter

Filter key

Description

ADEP

ADEPList

Filter by departure airport

ADES

ADESList

Filter by destination airport

ALTN

ALTNList

Filter by alternate airport

ALTN2

ALTN2List

Filter by second alternate airport

Airport

airport

Filter by any airport involved in the flight

Country (ADEP or ADES)

countryList

Filter by departure or destination country

ADEP Country [Plan]

country_adep_plan

Filter by planned departure country

ADES Country [Plan]

country_ades_plan

Filter by planned destination country

ADEP Country [JL]

country_adep_log

Filter by actual departure country (Journey Log)

ADES Country [JL]

country_ades_log

Filter by actual destination country (Journey Log)

Continent

continent_list

Filter by continent (departure or destination)

ADEP Continent [Plan]

ADEP_continent_plan

Filter by planned departure continent

ADEP Continent [JL]

ADEP_continent_journey_log

Filter by actual departure continent (Journey Log)

ADES Continent [Plan]

ADES_continent_plan

Filter by planned destination continent

ADES Continent [JL]

ADES_continent_journey_log

Filter by actual destination continent (Journey Log)

Airport category

airport_category

Filter by airport category (departure or destination)

ADEP category

adep_airport_category

Filter by departure airport category

ADES category

ades_airport_category

Filter by destination airport category

ADEP tags

adep_tag_list

Filter by tags on the departure airport

ADES tags

ades_tag_list

Filter by tags on the destination airport

Departure from RefuelEU airport

adep_refuel_eu

Only flights departing a ReFuelEU airport

Destination to RefuelEU airport

ades_refuel_eu

Only flights arriving at a ReFuelEU airport

ADEP Handling Agent

ADEPHandlingAgentList

Filter by handling agent at departure

ADES Handling Agent

ADESHandlingAgentList

Filter by handling agent at destination

Handling Agent

handling_agent_list

Filter by handling agent (any airport)

Handling Rating ADEP [JL]

handling_rating_adep_jl

Filter by handling rating at departure (Journey Log)

Handling Rating ADES [JL]

handling_rating_ades_jl

Filter by handling rating at destination (Journey Log)

ADEP fuel supplier

adep_fuel_supplier

Filter by whether a fuel supplier is set at departure

Filter — Flight identification & status

Filter

Filter key

Description

Flight No

flightNumberList

Filter by exact flight number(s)

Flight No (wildcard)

flight_number_wildcard

Filter by flight number matching a wildcard

Flight No exclude (wildcard)

flight_number_exclude_wildcard

Exclude flight numbers matching a wildcard

Trip no

trip_number_list

Filter by trip number(s)

Flight status

flightStatusList

Filter by flight status

Trip type

tripTypeList

Filter by trip type

ICAO flight type

ICAOFlightTypeList

Filter by ICAO flight type

Commercial

isCommercial

Only commercial / non-commercial flights

Is canceled

isCanceled

Show only cancelled, only active, or all flights

Is ferry

isFerry

Only ferry / non-ferry flights

Diverted

is_diverted

Only diverted flights

Flight traffic

flightTraffic

Filter by flight traffic type (domestic/international)

Europe flight traffic

europeFlightTraffic

Filter by European flight traffic type

Day of week [UTC]

dayOfWeekUTCList

Filter by day of week of departure (UTC)

Tags include

flightTagList

Only flights with the selected tags

Tags exclude

flightTagListExclude

Exclude flights with the selected tags

Filter — Times & delays

Filter

Filter key

Description

Date range source type

date_range_source_type

Choose which date the date range applies to (scheduled, JL, or FW)

Take off time after [LT]

ATDAfterLT

Only flights taking off after the given local time

Take off time before [LT]

ATDBeforeLT

Only flights taking off before the given local time

Take off time after [UTC]

ATDAfterUTC

Only flights taking off after the given UTC time

Take off time before [UTC]

ATDBeforeUTC

Only flights taking off before the given UTC time

Calculated delay ADEP [mins]

calculated_delay_adep

Filter by departure delay range (minutes)

Calculated delay ADES [mins]

calculated_delay_ades

Filter by arrival delay range (minutes)

Block time more than [JL]

block_time_jl_after

Only flights with Journey Log block time above the value

Block time less than [JL]

block_time_jl_before

Only flights with Journey Log block time below the value

Block time more than [FW]

block_time_fw_after

Only flights with Flight Watch block time above the value

Block time less than [FW]

block_time_fw_before

Only flights with Flight Watch block time below the value

Block time more than [Plan]

block_time_plan_after

Only flights with planned block time above the value

Block time less than [Plan]

block_time_plan_before

Only flights with planned block time below the value

Filter — Crew

Filter

Filter key

Description

Crew members

crewMemberList

Filter flights for specific crew members

Crew label

crew_label_list

Filter by labels assigned to crew members

Fatigue score [JL]

fatigue_score

Filter by recorded crew fatigue score (Journey Log)

Filter — Passengers

Filter

Filter key

Description

Passenger list

pax_contact_nid_list

Filter by specific passengers

Has zero PAX assigned [Plan]

has_zero_PAX

Only flights with no planned passengers

Has zero PAX assigned [JL]

has_zero_PAX_JL

Only flights with no passengers in the Journey Log

Boarding status

boarding_status

Filter by boarding status

Flights with Animals

flights_with_animals

Only flights carrying animals

UK APD Band

uk_apd_band

Filter by UK Air Passenger Duty band

Filter — Journey Log & operations

Filter

Filter key

Description

Journey log

journey_log

Filter by Journey Log presence/state

Status [JL]

jl_status

Filter by Journey Log status

Has flight watch

hasFlightWatch

Only flights that have Flight Watch data

Approach

Approach

Filter by approach performed

Approach Type

ApproachType

Filter by type of approach

Is ASR [JL]

is_jl_asr

Only flights with an Air Safety Report (Journey Log)

Is HUD/EVS

is_jl_hud_evs

Only flights flown with HUD/EVS

Is carriage of dangerous goods [JL]

is_jl_carriage_of_dangerous_goods

Only flights carrying dangerous goods

Autoland [JL]

log_autoland

Filter by autoland performed

Client's satisfaction [JL]

log_client_satisfaction

Filter by recorded client satisfaction

Has low level spray [JL]

has_low_level_spray

Only flights with low-level spraying

SAFA ramp check

log_safe_ramp_check

Only flights with a SAFA ramp check

Has added files [JL]

has_jl_with_files

Only flights with files attached to the Journey Log

Has congested area [JL]

log_has_congested_area

Only flights over a congested area

Has LVTO between 150-500m [JL]

is_lvto_above_150m

Only flights with low-visibility take-off (150–500 m)

Has voyage report number [JL]

has_voyage_report_number

Only flights with a voyage report number

GPU used [JL]

gpu_used

Only flights where a ground power unit was used

ACU used [JL]

acu_used

Only flights where an air conditioning unit was used

Has maintenance log entry [JL]

has_maintenance_log_entry

Only flights with a maintenance log entry

Include custom code [JL]

include_custom_code_journey_log

Only flights with the given Journey Log custom code

Exclude custom code [JL]

exclude_custom_code_journey_log

Exclude flights with the given Journey Log custom code

L3Harris status [JL]

l3harris_status

Filter by L3Harris integration status

SAF used [JL]

is_jl_saf_used

Only flights where Sustainable Aviation Fuel was used

Deicing [JL]

is_deicing_jl

Only flights where de-icing was performed

Discretion for extension

is_commanders_discretion

Only flights where commander discretion extended the FDP

Has dispatch feedback [JL]

has_dispatch_feedback

Only flights with dispatch feedback

Has other feedback [JL]

has_other_feedback

Only flights with other feedback

Has Pre-Flight Documentation completed & Sent [JL]

has_jl_pre_flight_documentation_completed_sent

Only flights with completed/sent pre-flight documentation

Flight KSS [JL]

journey_log_flight_kss

Filter by Karolinska Sleepiness Scale (KSS) flight score

Filter — Checklist

Filter

Filter key

Description

Checklist items on flight

checklist_definition_list

Only flights containing the selected checklist items

Checklist items statuses

checklist_definition_list_with_statuses

Filter by checklist items with specific statuses

Filter — Sales & commercial

Filter

Filter key

Description

Client

clientList

Filter by client

Client representative

clientRepresentative

Filter by client representative

Excluded client

excluded_client_list

Exclude the selected clients

Client labels

operator_client_label_list

Filter by labels assigned to clients

Sales Supervisor

sales_supervisor_list

Filter by sales supervisor

Booked from Sales module

is_flight_booked_from_sales

Only flights booked from the Sales module

Is an invoice defined

is_an_invoice_defined

Only flights with an invoice defined

Filter — Environmental

Filter

Filter key

Description

EU ETS Exception

is_EU_ETS_exception

Only flights with an EU ETS exception

Is CO2 offsetting filled

is_carbon_offset_filled

Only flights with CO₂ offsetting filled in