I am using a combination of Arrived, Departed, Scheduled, and Enroute to track flights from a small regional airport (3 outgoing and 3 incoming flights daily, all direct flights). At the end of the year they will have a flight from their airport A to airport C with a connection at airport B. Passengers do not disembark at B and continue on the same aircraft to C.
If we continue to use the ID of airport A I am assuming won’t include the leg from B to C. Both B and C are larger airports so it would be difficult to use these same queries with them and filter out the results. What is the recommended method of capturing the departure time, arrival time, and flight status of the B to C leg?
Thank you for your suggestions.