Sun Dec 01, 2019 3:15 pm
FAQ
AS OF JULY 2018 THERE ARE CHANGES TO THE FORMAT OF THIS REPORT...SEE BELOW
WHAT IS THIS REPORT?
This compares departures for sale THIS WEEK for the stated period versus what was for sale LAST WEEK...prior year departures are now shown in brackets e.g. [0].
THE SCHEDULES SHOWN HERE CHANGE AFTER YOU POST???
-To improve is to change; to be perfect is to change often---Winston Churchill. This is data the carriers filed at the point in time it was captured. It's changed since then. You are just going to have to live with it.
HOW DO I READ IT?
XXX-YYY DEC 4>5[4] JAN 4>5[4]
XXX Departure IATA code, YYY Arrival IATA code, Month, Average Departures/Day over the month for sale as of last week, Average Departures/Day over the month for sale as of this week, in brackets is the number of Average Departures/Day over the month that were scheduled one year earlier. So, it means that the listed airline changed the frequency between the two airports to add from 4 to 5 roundtrips in December and January. It also means that there were 4 roundtrips the prior year in each month. No other months were changed. I average two directions.
WHAT ABOUT CARRIERS THAT DON'T PUBLISH A SCHEDULE 9 MONTHS IN ADVANCE?
NEW CHANGE-Sometimes airlines do not load their schedules for the entire 330 day standard sales window. Southwest and many LCCs load their schedules for as little as 5 months into the future. When these flight are extended into a new sales month, it becomes a "schedule change". Previously, I have manually deleted these in many cases and replaced them with a Year-Over-Year compare. Effective immediately, this will now change. When a flight is loaded from 0 departures X departures, where X was the same the prior year, the record will not be shown. For example, if Delta loaded ATL-EGE MAR 0>1(1), it would not be shown because this additional flight does not represent a real year-over-year addition. Similarly, if B6 extended their schedule a record like this ATL-BOS JUL 0>4(4) would not be shown. It will be shown if the flight frequency changed from the prior year. So B6 ATL-BOS JUL 0>3(4) would be shown. If a partial month was loaded in a core schedule that became a full schedule month, those changes may be shown under this logic. For example, WN BNA-SEA 0.3>2(2). Because only a fraction of the month was previously loaded for sale, these changes will not be filtered out. I may, however, manually remove them to declutter.
HOW ARE THE DAILY DEPARTURES CALCULATED?
This report uses total operations for the month listed, divided over the days in the month. The following criteria are used to show a change: 1) The change must be at least 6 roundtrips per month with no exceptions, 2) changes of at least 6/week are always shown, 3) routes that are added or dropped are shown subject to the change minimum, and 4) in all other cases routes must change by 20% to be shown. For example, if a route changed from 21/week to 18/week it would not be shown because the change is -14.3%. This is done to filter minor changes that occur in large numbers.
WHAT ARE THE FRACTIONAL FLIGHTS?
Flights that do not operate every day of the month create fractional service. If the route has more than 2 daily flights, departures are rounded, but in cases of less than 2 departures per day a fraction is shown. For example, if a flight operates 4 times in April it will show 4/30=0.133=0.1. Also , a flight that only operates once per week may vary between 0.1 and 0.2 because a weekday may repeat either 4 or 5 times depending on the month.
THOSE FLIGHTS AREN'T DELTA, THEY ARE SKYWEST
This report only shows the marketing code. It is too complicated to show all the operators.
THE FREQUENCIES MAY HAVE CHANGED AS YOU SHOW, BUT THE SEATS DIDNT CHANGE BECAUSE OF EQUIPMENT SWAPS
Seats are not shown. That is a natural weakness of a frequency based report, but it provides something to discuss below.
THIS LOOKS LIKE AN ERROR?
The carriers file the schedules. They do make mistakes. Most of the mistakes I have seen are either related to code shares not being marked as "duplicates" or carriers filing flights with invalid data such as equipment codes that are not standard or overlapping schedule periods that see the same flight number in two places at once. These cause flights to not appear.
CHARTERS?
Lately charters have been showing up in the database. I have no idea if that will continue.
I marked some of the ones I thought were interesting with an "*".
NOTE: As is often the case after holidays, there were data issues. I will do an update if there is a correction in the source data.
*AC LAS-YEG JAN 1.0>0.3[1.0] FEB 1.0>0[1.0] MAR 1.0>0[1.0]
AC LAS-YVR JAN 2>1.5[2] FEB 2>1.0[2] MAR 2>1.0[2]
AC LAX-YYC JAN 2>1.2[1.9] FEB 2>1.0[2] MAR 2>1.0[2]
AC MSP-YYZ JAN 3>2[3]
AC OGG-YYC JAN 0.6>0.4[0.5]
AC PHX-YYZ FEB 1.3>1.0[1.9] MAR 2>1.0[2]
*AC RDU-YUL MAY 0>1.0[0]
AC SAV-YYZ FEB 1.0>0[0] MAR 1.0>0.4[1.0]
AS ANC-DUT JUN 2>0[3] JUL 2>0[2] AUG 2>0[2] SEP 2>0[2]
AS ANC-RDB JAN 0.4>0[0.4] FEB 0.4>0[0.4] MAR 0.3>0[0.4] APR 0.3>0[0.4] MAY 0.3>0[0.4] JUN 0.3>0[0.4] JUL 0.3>0[0.4] AUG 0.3>0[0.5] SEP 0.3>0[0.4]
AS ANC-SCC JAN 3>1.4[1.4] FEB 2>1.3[1.4] MAR 2>1.4[1.3] APR 2>1.4[1.4] AUG 1.9>1.3[1.9] SEP 3>1.4[2]
*AS OMA-SEA MAY 1.0>1.3[1.0] JUN 1.0>2[1.0] JUL 1.0>2[1.0] AUG 1.0>2[1.0] SEP 1.0>1.3[1.0]
*AS PIT-SEA MAY 1.0>1.3[1.0] JUN 1.0>2[1.0] JUL 1.0>2[1.0] AUG 1.0>2[1.0] SEP 1.0>1.3[1.0]
*AS SBA-SEA MAY 1.0>1.4[1.0] JUN 1.0>2[1.0] JUL 1.0>2[1.0] AUG 1.0>2[1.0] SEP 1.0>1.3[1.0]
AV JFK-SAL JAN 1.0>2[2] FEB 1.0>2[2] MAR 1.1>2[2.0]
AV LAX-SAL JAN 3>4[2] FEB 3>4[3] MAR 3>4[3]
DL ABQ-MSP MAY 1.0>0.7[0.8]
DL ATL-MSP MAY 12>11[11]
DL ATL-MYR JUL 4>5[4]
DL ATL-OAK MAY 0.5>0.2[0]
DL ATL-RST MAY 2>1.6[1.5]
DL ATL-SNA MAY 4>3[3]
DL BOS-PBI APR 1.2>0.9[0.7]
DL BOS-RSW APR 1.2>0.9[0.8]
DL BZN-SLC SEP 4>5[3]
DL CHA-DTW APR 2>1.7[1.6]
DL DTW-SNA SEP 1.0>0.7[0.8]
DL FAT-SLC MAY 4>3[3]
DL GJT-SLC APR 4>2[3]
DL JFK-PWM MAY 3>2[3]
DL LEX-MSP MAY 1.0>0[0.6] JUN 1.0>0.8[1.0]
DL MSO-MSP MAY 2>1.5[1.5]
DL MSP-RIC MAY 3>2[1.8]
DL MSP-XWA MAY 3>2[0]
DL MSP-YYZ MAY 4>3[3]
DL ONT-SLC MAY 5>4[3]
DL SGU-SLC APR 5>4[4]
DL SLC-YVR MAY 2>1.6[1.6]
DY LAX-OSL APR 0.6>0.3[0.3] MAY 0.6>0.3[0.3] JUN 0.6>0.3[0.3] JUL 0.6>0.3[0.3] AUG 0.6>0.3[0.3] SEP 0.6>0.3[0.3]
IB LAX-MAD MAR 0.2>0.4[0.4]
IB MAD-MIA MAY 1.0>2[2] JUN 1.0>2[2] JUL 1.0>2[2] AUG 1.0>2[2] SEP 1.0>2[2]
JL DFW-HND APR 0>1.0[0] MAY 0>1.0[0] JUN 0>1.0[0] JUL 0>1.0[0] AUG 0>1.0[0] SEP 0>1.0[0]
JL DFW-NRT APR 1.0>0[1.0] MAY 1.0>0[1.0] JUN 1.0>0[1.0] JUL 1.0>0[1.0] AUG 1.0>0[1.0] SEP 1.0>0[1.0]
JL HND-JFK APR 1.0>2[1.0] MAY 1.0>2[1.0] JUN 1.0>2[1.0] JUL 1.0>2[1.0] AUG 1.0>2[1.0] SEP 1.0>2[1.0]
JL HND-ORD APR 0>1.0[0] MAY 0>1.0[0] JUN 0>1.0[0] JUL 0>1.0[0] AUG 0>1.0[0] SEP 0>1.0[0]
JL JFK-NRT APR 1.0>0[1.0] MAY 1.0>0[1.0] JUN 1.0>0[1.0] JUL 1.0>0[1.0] AUG 1.0>0[1.0] SEP 1.0>0[1.0]
JL NRT-ORD APR 1.0>0[1.0] MAY 1.0>0[1.0] JUN 1.0>0[1.4] JUL 1.0>0[1.5] AUG 1.0>0[1.6] SEP 1.0>0[1.1]
KG DEN-TEX APR 0.2>1.7[0] MAY 0>1.7[0.5] JUN 0>1.7[1.0] JUL 0>1.7[1.0] AUG 0>1.7[1.0] SEP 0>1.7[1.0]
KX DEN-GCM SEP 0>0.3[0]
KX GCM-JFK MAR 0.5>0.7[1.0] APR 0.4>0.7[1.0] MAY 0.4>0.7[0.4] JUN 0.4>0.7[0.6] JUL 0.4>0.7[1.0] AUG 0.5>0.7[1.0] SEP 0.4>0.7[0.5]
*LA CUN-MIA JAN 0.3>0[0.3] FEB 0.2>0[0.3]
*LA MIA-UIO JAN 1.0>0[1.0] FEB 1.0>0[1.0] MAR 1.0>0[1.0] APR 1.0>0[1.0] MAY 1.0>0[1.0] JUN 1.0>0[1.0] JUL 1.0>0[1.0] AUG 1.0>0[1.0] SEP 1.0>0[1.0]
NH HND-IAD APR 1.0>0[0] MAY 1.0>0[0] JUN 1.0>0[0] JUL 1.0>0[0] AUG 1.0>0[0] SEP 1.0>0[0]
NH HND-IAH APR 1.0>0[0] MAY 1.0>0[0] JUN 1.0>0[0] JUL 1.0>0[0] AUG 1.0>0[0] SEP 1.0>0[0]
NH LAX-NRT APR 2>1.0[2] MAY 2>1.0[2] JUN 2>1.0[2] JUL 2>1.0[2] AUG 2>1.0[2] SEP 2>1.0[2]
NH NRT-SEA APR 1.0>0[1.0] MAY 1.0>0[1.0] JUN 1.0>0[1.0] JUL 1.0>0[1.0] AUG 1.0>0[1.0] SEP 1.0>0[1.0]
NH NRT-SJC APR 1.0>0[1.0] MAY 1.0>0[1.0] JUN 1.0>0[1.0] JUL 1.0>0[1.0] AUG 1.0>0[1.0] SEP 1.0>0[1.0]
NK DTW-MSY FEB 1.0>1.6[1.1] MAR 1.0>2[1.4] APR 1.0>1.7[1.0]
NK FLL-IAH FEB 1.0>1.2[1.0] MAR 1.0>1.4[1.0] APR 1.3>1.6[1.0]
UA ACT-IAH JAN 0.3>0[0.3] FEB 0.2>0[0.2]
UA BMG-ORD JAN 0.3>0[0.2]
UA BUF-ORD APR 3>4[4]
UA DVL-JMS JAN 1.4>0.9[1.4] FEB 1.3>0.8[1.4] MAR 1.4>0.9[1.4] APR 1.4>0.9[1.4] MAY 1.4>0.9[1.4] JUN 1.4>0.9[1.4] JUL 1.4>0.9[1.4] AUG 1.4>0.9[1.4] SEP 1.4>0.9[1.4]
UA HYS-SLN JAN 1.7>1.3[1.7] FEB 1.7>1.3[1.7]
UA IAH-MHK FEB 0.2>0[0.2]
UA IAH-MOT FEB 0.3>0[0.2] MAR 0.3>0[0.3]
UA IAH-SWO JAN 0.2>0[0.2] FEB 0.2>0[0.2]
Last edited by
SQ22 on Mon Dec 02, 2019 1:18 am, edited 1 time in total.
Reason: Title updated