Trying to get the schedule of a particular airline (VOZ) for a 1 week period in the past (within the last weeks or two).
Have been investigating a couple of ways using FlightXML but nothing seems to jump out at me.
The data I need are (for a specific startDate->endDate of 7 days):
- Aircraft Rego
- Dep Date/Time (preferably Scheduled)
- Arr Date/Time (preferably Scheduled)
The problem I face is that there seems to be several functions that I can use to get some of this data but there isn’t a single one that has the schedule info and the aircraft rego in one result set.
What I have been thinking about is using AirlineFlightSchedule to get the FlightNo (ident), origin, dest and times and then using the flight number as ident to get the tailnumber from AirlineFlightInfo.
I have two problems with this.
- The ident is sometimes a VOZ flight number and at other times a codeshare (which I don’t want to retrieve).
- The second query looks up one flight at a time to get the tail number. Which for a full week of schedules will be over 3000 separate queries each returning 1 row.
What would be easier is if I could send FlightXML the aircraft rego and retrieve the flight history for that aircraft like you can do on the live site here flightaware.com/live/flight/VHYFE/history but with the flight number as part of the result. That way I could run a query for each aircraft (rather than each flight) which would only be about 50 queries for the whole airline for the whole week. This would also mean I can filter out the codeshare flights as I have a list of regos I would be searching.
Unless there’s another way that I can do this??
Thanks in advance