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).
AMS – Amsterdam NL
ARN – Stockholm SE
BCN – Barcelona ES
BRU – Brussels BE
CDG – Paris Charles de Gaulle FR
DUS – Dusseldorf DE
FAO – Faro PT
FNC – Funchal PT
FRA – Frankfurt DE
GRZ – Graz AU
HEL – Helsinki FI
HER – Heraklion GR
INN – Innsbruck AU
KLU – Klagenfurt AU
KRK – Krakow PL
LCA – Larnaca CY
LHR – London Heathrow UK
LIS – Lisbon PT
LNZ – Linz airport
LPA – Las Palmas ES
LYS – Lyon FR
MAD – Madrid ES
NCE – Nice FR
NTE – Nantes FR
OPO – Porto PT
OSL – Oslo NO
PDL – Ponta Delgada PT
PMI – Palma de Mallorca ES
PRG – Prague CZ
SOF – Sofia BG
STN – London Stansted UK
SZG – Salzburg AU
VIE – Vienna AU
WAW – Warsaw PL
For all these airports, data were aggregated for cancellations requested for flights scheduled between 1st of March and the end of Summer 2020 IATA season.
All data were extracted by slot coordinators as of June the 1st between June the 2nd and June the 15th.
The graph essentially shows that:
– Very late cancellations, less than one week (cat A and B), were requested by airlines for flights scheduled in March and in very few cases scheduled for later periods;
– Late cancellations, between one and two weeks (cat C), were requested by airlines mainly for flights scheduled at the beginning of April and also at a lower scale every 2 weeks from mid April until now;
– Cancellations made 3 or 4 weeks in advance (cat D and E) represent a very large amount of all cancellations for flights scheduled mid April and at the beginning of May and June (more than 50%);
– Early cancellations (cat F) were almost non-existent for flights scheduled in March, not numerous for flights scheduled in April and represent already a significant proportion of the flight cancellations originally scheduled in May and June. Naturally, all cancellations made for flights scheduled after beginning of July were with more than 4 weeks in advance.
For cancellations of flights originally scheduled in July, August, September and October 2020, the graphic clearly shows that airlines are still deciding on cancellations on a monthly basis.