How to produce a quick comparison between two or more airlines over multiple performance indicators.
Start setting up your query using the yellow query filters:
| Carrier Airline Code | AIRLINE folder |
| Passenger 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 Airline Code | AIRLINE folder |
| Carrier Airline Name | AIRLINE folder |
| Frequency | FREQUENCY & CAPACITY folder |
| Total Number of Seats | FREQUENCY & CAPACITY folder |
| Available Seat Kilometres | FREQUENCY & CAPACITY folder |
| Available Seat Miles | FREQUENCY & CAPACITY folder |
| Week Commencing Date | PERIOD folder |
Click on Run Query and select the carrier codes of your choice e.g. B6 – Jetblue & WN – Southwest and the week(s) that you wish to conduct the comparison for e.g. 2006-04-17.
Move your mouse over the Results Table until a grey border appears around it. Right click on this grey border and select the Turn To sub option. Now click on the bottom right icon called Form. This icon is displayed in the following format.
Your results are now displayed in a new tabular format that facilitates a quick comparison between the two carriers. The new table can be customised by clicking on the Properties Tab. There you will be given the option to change the colour, size and style of the text and its background.
MAXimum information
How good are you with Aircraft Codes? Do you know that FRJ is the code for Fairchild Dornier 328 Jet? If not, why don’t you run a simple query with OAG MAX Online?
In the query tool, expand the AIRCRAFT folder and then ‘drag & drop’ (or double click) the General Aircraft Code, the General Aircraft Name, the Specific Aircraft Code and the Specific Aircraft Name in the Result Objects. There is no need to include any filters in your query.
Now click Run Query and MAX Online will display all aircraft codes and names, general and specific.