How to read the (regular) AMS movements?

[quincytoi]

Any one can guide me read the Scramble Amsterdam Schiphol Movements. I would like to extract all movements of any one (historical) day at Schiphol in order to run some simulation. No need for military flight, only civil flight would do.

Just unable to read the tables... Such as the Abbrev. in regular tables...

What i need is the following columns:

STA, STD, ATA, ATD, Airline, Flight No(s)

Any one can help me plz, many thanks.

[Hurricane]

Any one can guide me read the Scramble Amsterdam Schiphol Movements. I would like to extract all movements of any one (historical) day at Schiphol in order to run some simulation. No need for military flight, only civil flight would do.

Just unable to read the tables... Such as the Abbrev. in regular tables...

What i need is the following columns:

STA, STD, ATA, ATD, Airline, Flight No(s)

Any one can help me plz, many thanks.

Have a look here; http://www.scramble.nl/databases.htm & http://www.scramble.nl/forum/viewtopic.php?f=14&t=17583

Adios, Hurricane

[quincytoi]

Have a look here; http://www.scramble.nl/databases.htm

Adios, Hurricane

I just came from there, it's just that i don't know how to read the table, especially the Schiphol movement - Regulars....all abbreviations. Don't mean anything to me

[ehusmann]

It is not that hard, if indeed you understand what it means.

The table lay out is each column is a day (1st, 2nd, 3rd etc), the rows are flightnumbers.
Each cell shows the registration of the plane that was on the flightnumber (row) of that day (column).

Take for example the regular list of January 2009. The first row show flight 8A474/8A475. The first is the inbound flight, the second is the outbound flight. On the 2nd of January the flight was performed with the (CN)-RNA. Unfortunately, not the complete registration is used in the table, the prefixes have been deleted (probably to save space). Also, if you want to be able to read the flight numbers, you will need to know the codes for the airlines. The example here for example is flight 8A474 and 8A (Airline code) stands for Atlas Blue from Morocco.

I guess if you really want to understand the info of the table, you have to be somewhat of an aviation geek, knowing the prefixes and the airline codes....

But, this only gives you part of the information you are looking for. The STA and STD are not mentioned here, but you could find that on the Schiphol site, but I don´t think you can find historical data here. ATD and ATA are not listed anywhere as far as I know.

Erwin

[quincytoi]

It is not that hard, if indeed you understand what it means.

The table lay out is each column is a day (1st, 2nd, 3rd etc), the rows are flightnumbers.
Each cell shows the registration of the plane that was on the flightnumber (row) of that day (column).

Take for example the regular list of January 2009. The first row show flight 8A474/8A475. The first is the inbound flight, the second is the outbound flight. On the 2nd of January the flight was performed with the (CN)-RNA. Unfortunately, not the complete registration is used in the table, the prefixes have been deleted (probably to save space). Also, if you want to be able to read the flight numbers, you will need to know the codes for the airlines. The example here for example is flight 8A474 and 8A (Airline code) stands for Atlas Blue from Morocco.

I guess if you really want to understand the info of the table, you have to be somewhat of an aviation geek, knowing the prefixes and the airline codes....

But, this only gives you part of the information you are looking for. The STA and STD are not mentioned here, but you could find that on the Schiphol site, but I don´t think you can find historical data here. ATD and ATA are not listed anywhere as far as I know.

Erwin

Thank you very much for the detailed explanation, Erwin. With the short registration number, it's hard to extract the aircraft indeed.

The crucial info i need is actually the STA, and STD, at the Schiphol site, i can find all arrival times, and departure times, it's hard to map all movement to these arrival/departure

[ehusmann]

I understand, you will need to figure out which code belongs to which airline.... but luckily, there is help for that as well!

The Airline Codes Website

The two letter codes you find in the movements page are IATA codes.

Erwin

PS: send me a PM if you have specific questions