Scope - FTL Duty

Overview

The FTL Duty scope covers duty periods and Flight Time Limitation (FTL) records for crew members. Each record represents a single duty — a continuous period during which a crew member is subject to regulatory working time rules, from the moment they report for duty until they are released. The scope captures actual and planned duty start and end times, Flight Duty Period (FDP) data, rest periods, and FTL compliance results.

This scope is essential for regulatory compliance and fatigue risk management. Operators use it to verify that crew working hours remain within the legal limits set by aviation authorities, to detect violations, monitor discretion usage, and produce auditable duty and rest records.

What reports can you build with this scope?

Examples of typical reports operators build with this scope:

Monthly crew duty hours summary by crew member or AOC
FTL violation report — list of duties where limits were exceeded
Discretion usage report — duties where FDP extension was applied
Rest period compliance report — actual vs. required rest before and after each duty
Early/late/night duty frequency report for fatigue risk analysis

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.

Crew identification

Column	Column key	Description

Column	Column key	Description
Crew member	`crew_member`	Full name of the crew member assigned to the duty
Crew code	`crew_code`	Short identifier code assigned to the crew member
Crew ID card	`crew_id_card`	ID card number of the crew member
Crew permission group	`crew_permission_group`	Permission group the crew member belongs to in Leon
Crew user base	`crew_user_base`	The base location assigned to the crew member's user account
Crew home base ICAO	`crew_home_base_icao`	Crew member's home base airport in ICAO format
Crew home base IATA	`crew_home_base_iata`	Crew member's home base airport in IATA format
Crew DOB	`crew_dob`	Date of birth of the crew member
Crew phone number	`crew_phone_number`	Phone number on record for the crew member
Crew email	`crew_email`	Email address on record for the crew member
Crew gender	`crew_gender`	Gender of the crew member
Crew labels	`crew_labels`	Labels assigned to the crew member
Crew positions	`crew_positions`	Crew positions (roles) held by the crew member

Duty times — actual

Column	Column key	Description

Column	Column key	Description
Duty start date [UTC]	`duty_start_date_utc`	Date when the duty started, expressed in UTC
Duty start time [UTC]	`duty_start_time_utc`	Time when the duty started, expressed in UTC
Duty start date [CREW BT]	`duty_start_date_crew_bt`	Date when the duty started, expressed in the crew member's base time
Duty start time [CREW BT]	`duty_start_time_crew_bt`	Time when the duty started, expressed in the crew member's base time
Duty start date [LT]	`duty_start_date_lt`	Date when the duty started, expressed in local time
Duty start time [LT]	`duty_start_time_lt`	Time when the duty started, expressed in local time
Duty end date [UTC]	`duty_end_date_utc`	Date when the duty ended, expressed in UTC
Duty end time [UTC]	`duty_end_time_utc`	Time when the duty ended, expressed in UTC
Duty end date [CREW BT]	`duty_end_date_crew_bt`	Date when the duty ended, expressed in the crew member's base time
Duty end time [CREW BT]	`duty_end_time_crew_bt`	Time when the duty ended, expressed in the crew member's base time
Duty end date [LT]	`duty_end_date_lt`	Date when the duty ended, expressed in local time
Duty end time [LT]	`duty_end_time_lt`	Time when the duty ended, expressed in local time
Duty length	`duty_length`	Total duration of the actual duty period

Duty times — planned

Column	Column key	Description

Column	Column key	Description
Planned duty start date [UTC]	`planned_duty_start_date_utc`	Planned date for duty start, expressed in UTC
Planned duty start time [UTC]	`planned_duty_start_time_utc`	Planned time for duty start, expressed in UTC
Planned duty start date [LT]	`planned_duty_start_date_lt`	Planned date for duty start, expressed in local time
Planned duty start time [LT]	`planned_duty_start_time_lt`	Planned time for duty start, expressed in local time
Planned duty end date [UTC]	`planned_duty_end_date_utc`	Planned date for duty end, expressed in UTC
Planned duty end time [UTC]	`planned_duty_end_time_utc`	Planned time for duty end, expressed in UTC
Planned duty end date [LT]	`planned_duty_end_date_lt`	Planned date for duty end, expressed in local time
Planned duty end time [LT]	`planned_duty_end_time_lt`	Planned time for duty end, expressed in local time
Planned duty length	`planned_duty_length`	Total duration of the planned duty period
Difference between planned and actual duty hours	`difference_duty_length`	Difference between the planned and actual duty duration

Flight Duty Period (FDP)

Column	Column key	Description

Column	Column key	Description
FDP start date [UTC]	`fdp_start_date_utc`	Date when the Flight Duty Period (FDP) started, expressed in UTC
FDP start time [UTC]	`fdp_start_time_utc`	Time when the Flight Duty Period (FDP) started, expressed in UTC
FDP end date [UTC]	`fdp_end_date_utc`	Date when the Flight Duty Period (FDP) ended, expressed in UTC
FDP end time [UTC]	`fdp_end_time_utc`	Time when the Flight Duty Period (FDP) ended, expressed in UTC
FDP length	`fdp_length`	Actual duration of the Flight Duty Period
Planned FDP length	`planned_fdp_length`	Planned duration of the Flight Duty Period
Max FDP	`max_fdp_length`	Maximum permitted FDP length under applicable FTL rules
Difference between max FDP and planned FDP	`difference_max_and_planned_fdp_length`	Difference between the maximum allowed FDP and the planned FDP duration
FDP extension	`fdp_extension`	Indicates whether a Flight Duty Period extension was applied
Discretion for extension	`discretion_length`	Duration of discretion used to extend the FDP
Discretion for extension [JL]	`log_discretion`	Duration of discretion recorded in the Journey Log

Rest periods

Column	Column key	Description

Column	Column key	Description
Rest required before	`rest_required_before`	Minimum required rest period before this duty
Rest actual before	`rest_actual_before`	Actual rest period observed before this duty
Rest required after	`rest_required_after`	Minimum required rest period after this duty
Rest actual after	`rest_actual_after`	Actual rest period observed after this duty
Rest reduction (preceding duty)	`rest_reduction`	Rest reduction applied based on the preceding duty
Recovery rest valid until [UTC]	`recovery_rest_valid_until_utc`	Timestamp (UTC) until which recovery rest is valid after this duty

Split duty

Column	Column key	Description

Column	Column key	Description
Split duty time	`split_duty_time`	Duration of the split duty rest break within the duty period
Split off	`split_off_time`	Time at which the split duty break began
Split on	`split_on_time`	Time at which the split duty break ended

Route and flight data

Column	Column key	Description

Column	Column key	Description
Route ICAO	`duty_route`	Departure and arrival airports for a single-sector duty, in ICAO format
Route IATA	`duty_route_iata`	Departure and arrival airports for a single-sector duty, in IATA format
Routes ICAO	`duty_routes`	All routes covered during the duty period, in ICAO format
Routes IATA	`duty_routes_iata`	All routes covered during the duty period, in IATA format
Flight number	`flight_number_list`	Flight number(s) included in this duty
Trip number	`trip_number_list`	Trip number(s) associated with this duty
Sectors	`sector_count`	Number of sectors (flight legs) within the duty period
Flight time	`flight_time`	Total flight time for a single sector within the duty
Flight times	`flight_times`	Flight times for all sectors within the duty period
Block time	`block_time`	Block time for a single sector within the duty
Block times	`block_times`	Block times for all sectors within the duty period
Take off [no]	`takeoff_count`	Number of takeoffs performed during the duty
Landings [no]	`landing_count`	Number of landings performed during the duty
Next EOBT [UTC]	`next_eobt_utc`	Estimated Off-Block Time (EOBT) of the next scheduled flight, in UTC

Duty identification and classification

Column	Column key	Description

Column	Column key	Description
Duty name	`cdr_duty_name`	Name or label of the duty as defined in the roster
Activity Types	`ftl_sector_activity_types`	Types of activities (e.g. flight, ground duty) included in this duty
Early/late/night duty	`ftl_duty_night_duty_type`	Classification of the duty as early, late, or night duty
WOCL	`wocl`	Window of Circadian Low (WOCL) — indicates if the duty falls within the body's low-performance period
Roster duty legend	`roster_duty_legend`	Legend or colour code associated with the duty in the crew roster
Acclimatization timezone	`acclimatization_timezone`	Timezone used for crew acclimatization calculations for this duty
FTL duty nid	`ftl_duty_nid`	Internal identifier of the FTL duty record

Aircraft

Column	Column key	Description

Column	Column key	Description
Aircraft list	`duty_aircraft`	Aircraft registration(s) operated during the duty
Aircraft type name	`aircraft_type_name`	Name of the aircraft type used during the duty
Aircraft crew ratings	`aircraft_crew_ratings`	Crew type ratings applicable to the aircraft flown during the duty
ICAO type	`icao_type`	ICAO designator of the aircraft type
Crew augmentation	`crew_augmentation`	Crew augmentation configuration applied during the duty (e.g. augmented crew for long-haul)

Block times — actual and planned

Column	Column key	Description

Column	Column key	Description
Planned BLOFF [UTC]	`planned_bloff_UTC`	Planned Block Off time expressed in UTC
Planned BLOFF [LT]	`planned_bloff_LT`