MAX_Bytes_20060619

Monday 19th June 2006

TIP OF THE WEEK:

Print Version

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.

Back

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.

Back