Microsoft Power BI file content :
Nota: The anticipation of cancelations concerns individual slots and not the whole series. In other words, and as an example, for a series covering the whole season that is canceled at the beginning of the season the first date would be canceled with no anticipation and the last date of the season for that series with the whole season anticipation)
The graphic in tab 2 shows the horizon of cancellations per month. Each chart shows (one chart per month) the number of cancellations (y-axis) per anticipation of cancellation (in number of days, x-axis) –
The chart in tab 1 shows the horizon of cancellations per date of operation.
For every date shown on the horizontal axis, it shows the number of slots that were originally scheduled on this date and cancelled:
A – On the date of operation
B – Between 1 and 7 days in advance
C – Between 8 and 14 days in advance
D – Between 15 and 21 days in advance
E – Between 22 and 28 days in advance
F – Between 29 and 59 days in advance
G – More than 60 days in advance
It is possible to highlight any of the curves by clicking on it.
The data are aggregated for the following list of airports. There is one chart for all airports combined (tab 1) and one per airport (starting on tab 3).
CDG – Paris Charles de Gaulle FR
LYS – Lyon FR
NCE – Nice FR
NTE – Nantes FR
ORY – Orly FR
For all these airports, data were aggregated for cancellations requested for flights scheduled since the beginning of Winter 2020 IATA season.
All data were extracted by slot coordinators as of December 31st.
The graph essentially shows that:
– Very late cancellations, less than one week (cat A and B), are now very few in W20 compared to flights scheduled in March, April and May.
– Late cancellations, between one and two weeks (cat C), were requested by airlines mainly for flights scheduled during the first two weeks of November (A national lockdown was annonced on the 28th of October and was scheduled to last a minimum of one month).
– Cancellations made 3 or 4 weeks in advance (cat D and E) represent 10 to 15% of all cancellations for flights scheduled in November.
– Early cancellations (cat F) were almost non-existent for flights scheduled in March and April, but now represent the largest volume of all cancellations (70% in first two weeks of November, and up to 80% for the end of November). Naturally, all cancellations made for flights scheduled after beginning of January 2021 4 weeks in advance.