I am not sure where to put this, but please move it if this forum is inappropriate for this thread.


I have a conjecture, that one can fly to one airport to another airport (provided both airports have scheduled flights) with two connection. From A, if it is not a hub itself, fly to the most accessible hub, then fly to a hub near point B if there is no flights to B, then fly to B from the second hub. I am sure there are exceptions, but I want to compute the average number of stops it take.


To move forward with a project, I will need to access some kind of routing database. Are there ways that I can obtain this in a file or with some sort of API from an existing website?

(Databases with operating airlines would be preferred as it would be interesting to compare the statistics between the three alliances or even individual airlines)

Thank you for your help,