Produce a weekly report that compares number of flights amongst several carriers by day of operation.
Example: We will create this report for the following carriers: Uzbekistan Airways, Air Astrana, Air Company Scat and Altyn Air.
Start setting up your query using the yellow query filters:
Carrier Airline Code |
AIRLINE folder |
| All Flights (excluding surface) | SERVICE folder |
| Operating Flights Only | CODESHARE folder |
| Week Commencing Date | PERIOD folder |
| Non-Stop Flights Only | ROUTING folder |
Now select the following fields as Results Objects.
Carrier Name |
AIRLINE folder |
| Week Commencing Date | PERIOD folder |
| Calendar Date | PERIOD folder |
| Frequency | FREQUENCY & CAPACITY folder |
Click on Run Query and select as Carrier Airline Code HY (Uzbekistan Airways), 4L (Air Astrana), DV (Air Company Scat) and QH (Altyn Air). Now select week commencing date ‘2006-07-03.’
Now Click OK to run the report.
MAX Online will display the results for the selected carriers for that week of July.
Now click within the ‘Calendar Date’ column and then select the Insert/Remove Break icon that is displayed in the top toolbar.
The results will now be grouped by ‘Calendar Date’ which enables you to compare the volume of flights offered by each airline for that particular week.
MAXimum information
Are you familiar with all Aircraft Manufacturer Codes? If not, why don’t you run a query with OAG MAX Online?
In the query tool, expand the ‘AIRCAFT’ folder and then ‘drag & drop’ (or double-click) the ‘Manufacturer Code’ & ‘Manufacturer Name’ in the ‘Result Objects’. There is no need to include any data filters in your query. Now click ‘Run Query’ and the system will display all the requested values, which you can export or save online for future reference.