Scope - Crew Flights

Overview

The Crew Flights scope provides flight-level crew assignment data, with each record representing a single crew member on a specific flight. It brings together flight schedule and Journey Log information alongside crew identity, role, and duty details — giving a full picture of who flew, in what capacity, and when.

Operators use this scope to track individual crew flight history, analyse crew utilization across the fleet, verify position assignments, and support compliance reporting. Because each row corresponds to one crew member on one flight, the scope is well suited to per-person flight time summaries, training type breakdowns, and document expiry cross-checks.

What reports can you build with this scope?

Examples of typical reports operators build with this scope:

Individual crew flight log — list all flights operated by a specific crew member over a date range, with times, positions, and block hours
Crew utilization summary — aggregate flight time and block time per crew member to assess workload and availability
Position assignment review — compare planned crew positions with Journey Log data to verify actual roles flown
Training flight report — filter by training type to list simulator or line training events with crew details
Document expiry check — cross-reference passport and travel document expiry dates against upcoming scheduled flights

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.

Flight identification

Column	Column key	Description

Column	Column key	Description
Flight number	`flightNo`	The flight number as entered in the schedule
Trip number	`trip_number`	The trip number grouping the flight
Trip type	`trip_type`	Classification of the trip (e.g. commercial, ferry, training)
Aircraft	`registration`	Aircraft registration assigned to the flight
Aircraft type	`aircraftTypeName`	Aircraft type name
Is the flight cancelled	`isCancelled`	Indicates whether the flight was cancelled
Flying	`is_flying`	Indicates whether the crew member was flying (as opposed to a non-flying role)

Planned departure and arrival dates

Column	Column key	Description

Column	Column key	Description
Date ADEP [Plan][UTC]	`departureDate`	Planned departure date at the departure airport, expressed in UTC
Date ADEP [Plan][LT]	`departure_date_LT`	Planned departure date at the departure airport, expressed in local time
Date ADES [Plan][UTC]	`destinationDate`	Planned arrival date at the destination airport, expressed in UTC
Date ADES [Plan][LT]	`destination_date_LT`	Planned arrival date at the destination airport, expressed in local time

Journey Log departure and arrival dates

Column	Column key	Description

Column	Column key	Description
Date ADEP [JL][UTC]	`departure_date_JL`	Actual departure date at the departure airport from the Journey Log, expressed in UTC
Date ADEP [JL][CREW BT]	`departure_date_JL_CREW_BT`	Actual departure date at the departure airport from the Journey Log, expressed in crew base time
Date ADEP [JL][LT]	`departure_date_JL_LT`	Actual departure date at the departure airport from the Journey Log, expressed in local time
Date ADES [JL][UTC]	`destination_date_JL`	Actual arrival date at the destination airport from the Journey Log, expressed in UTC
Date ADEP [JL][CREW BT]	`destination_date_JL_CREW_BT`	Actual departure date from the Journey Log expressed in crew base time (second occurrence)
Date ADES [JL][LT]	`destination_date_JL_LT`	Actual arrival date at the destination airport from the Journey Log, expressed in local time

Scheduled times

Column	Column key	Description

Column	Column key	Description
STD	`STD`	Scheduled Time of Departure (STD)
STA	`STA`	Scheduled Time of Arrival (STA)
STD[JL]	`STD_JL`	Scheduled Time of Departure as recorded in the Journey Log
STD[JL][CREW BT]	`STD_JL_CREW_BT`	Scheduled Time of Departure from the Journey Log expressed in crew base time
STA[JL]	`STA_JL`	Scheduled Time of Arrival as recorded in the Journey Log
STA[JL][CREW BT]	`STA_JL_CREW_BT`	Scheduled Time of Arrival from the Journey Log expressed in crew base time

Actual times (Journey Log)

Column	Column key	Description

Column	Column key	Description
OFF	`OFF`	Off-block time as recorded in the Journey Log
ON	`ON`	On-block time as recorded in the Journey Log
T/O [UTC]	`TO`	Takeoff time [UTC] as recorded in the Journey Log
T/O [LT]	`TO_LT`	Takeoff time expressed in local time
T/O [CREW BT]	`TO_CREW_BT`	Takeoff time expressed in crew base time
LND [UTC]	`LND`	Landing time [UTC] as recorded in the Journey Log
LND [LT]	`LND_LT`	Landing time expressed in local time
LND [CREW BT]	`LND_CREW_BT`	Landing time expressed in crew base time

Departure airport (ADEP) — planned

Column	Column key	Description

Column	Column key	Description
ADEP name [Plan]	`ADEPName`	Full name of the departure airport as per the flight plan
ADEP city [Plan]	`ADEPCity`	City of the departure airport as per the flight plan
ADEP country name [Plan]	`ADEP_country_name`	Country of the departure airport as per the flight plan
ADEP IATA [Plan]	`ADEP_IATA`	IATA code of the departure airport as per the flight plan
ADEP ICAO [Plan]	`ADEP_ICAO`	ICAO code of the departure airport as per the flight plan
ADEP FAA [Plan]	`ADEP_FAA`	FAA code of the departure airport as per the flight plan
ADEP custom code [Plan]	`ADEP_Cust`	Custom airport code for the departure airport as per the flight plan
ADEP preferred code [Plan]	`ADEP_Code`	Preferred airport code for the departure airport as per the flight plan
ADEP group [Plan]	`adep_airport_group`	Airport group of the departure airport as per the flight plan

Destination airport (ADES) — planned

Column	Column key	Description

Column	Column key	Description
ADES name [Plan]	`ADESName`	Full name of the destination airport as per the flight plan
ADES city [Plan]	`ADESCity`	City of the destination airport as per the flight plan
ADES country name [Plan]	`ADES_country_name`	Country of the destination airport as per the flight plan
ADES IATA [Plan]	`ADES_IATA`	IATA code of the destination airport as per the flight plan
ADES ICAO [Plan]	`ADES_ICAO`	ICAO code of the destination airport as per the flight plan
ADES FAA [Plan]	`ADES_FAA`	FAA code of the destination airport as per the flight plan
ADES custom code [Plan]	`ADES_Cust`	Custom airport code for the destination airport as per the flight plan
ADES preferred code [Plan]	`ADES_Code`	Preferred airport code for the destination airport as per the flight plan
ADES group [Plan]	`ades_airport_group`	Airport group of the destination airport as per the flight plan

Departure airport (ADEP) — Journey Log

Column	Column key	Description

Column	Column key	Description
ADEP name [JL]	`ADEP_Name_JL`	Full name of the departure airport as recorded in the Journey Log
ADEP city [JL]	`ADEP_City_JL`	City of the departure airport as recorded in the Journey Log
ADEP country name [JL]	`ADEP_country_name_JL`	Country of the departure airport as recorded in the Journey Log
ADEP IATA [JL]	`ADEP_IATA_JL`	IATA code of the departure airport as recorded in the Journey Log
ADEP ICAO [JL]	`ADEP_ICAO_JL`	ICAO code of the departure airport as recorded in the Journey Log
ADEP FAA [JL]	`ADEP_FAA_JL`	FAA code of the departure airport as recorded in the Journey Log
ADEP custom code [JL]	`ADEP_Cust_JL`	Custom airport code for the departure airport as recorded in the Journey Log
ADEP preferred code [JL]	`ADEP_Code_JL`	Preferred airport code for the departure airport as recorded in the Journey Log

Destination airport (ADES) — Journey Log

Column	Column key	Description

Column	Column key	Description
ADES name [JL]	`ADES_Name_JL`	Full name of the destination airport as recorded in the Journey Log
ADES city [JL]	`ADES_City_JL`	City of the destination airport as recorded in the Journey Log
ADES country name [JL]	`ADES_country_name_JL`	Country of the destination airport as recorded in the Journey Log
ADES IATA [JL]	`ADES_IATA_JL`	IATA code of the destination airport as recorded in the Journey Log
ADES ICAO [JL]	`ADES_ICAO_JL`	ICAO code of the destination airport as recorded in the Journey Log
ADES FAA [JL]	`ADES_FAA_JL`	FAA code of the destination airport as recorded in the Journey Log
ADES custom code [JL]	`ADES_Cust_JL`	Custom airport code for the destination airport as recorded in the Journey Log
ADES preferred code [JL]	`ADES_Code_JL`	Preferred airport code for the destination airport as recorded in the Journey Log

Alternate airport groups

Column	Column key	Description

Column	Column key	Description
ALTN group [Plan]	`altn_airport_group`	Airport group of the primary alternate airport as per the flight plan
ALTN2 group [Plan]	`altn2_airport_group`	Airport group of the secondary alternate airport as per the flight plan
T/O ALTN group [Plan]	`to_altn_airport_group`	Airport group of the takeoff alternate airport as per the flight plan

Flight times and distances

Column	Column key	Description

Column	Column key	Description
Flight time [JL]	`flightTimeJL`	Actual flight time (airborne time) as recorded in the Journey Log
Flight time [FTL]	`flightTimeFTL`	Flight time as counted for Flight Time Limitation (FTL) purposes
Block time [JL]	`blockTimeJL`	Actual block time (off-block to on-block) as recorded in the Journey Log
Block time [FTL]	`blockTimeFTL`	Block time as counted for FTL purposes
Estimated Flight time [Plan]	`estimated_flight_time`	Estimated flight time from the flight plan
Block time [Plan]	`block_time_plan`	Planned block time from the schedule
Landings	`landings`	Number of landings recorded in the Journey Log
Distance [NM][Plan]	`distance_plan`	Planned flight distance in nautical miles
Distance [NM][JL]	`distance_JL`	Actual flight distance in nautical miles as recorded in the Journey Log
MAX FL	`max_flight_level`	Maximum flight level reached during the flight
Approach	`approach`	Approach type flown (e.g. ILS, visual)
Approach type	`approach_type`	Category or classification of the approach
Cosmic radiation[µSv] - simple	`cosmic_radiation_simple`	Estimated cosmic radiation dose in microsieverts for this flight (simple calculation)

Crew identity

Column	Column key

Column	Column key