I woke up this past Sunday morning and was perusing my Twitter feed (you are following me there, right??) when I came across an interesting tweet from @MileValue. In short, he was frustrated at the apparent lack of award space from Sao Paulo to Europe. If the rumors are to be believed, it is simply impossible. And so he put out a challenge:
Given nothing better to do, I unleashed the power of my Star Alliance Award Search tool on the challenge. I loaded up all three routes and every day from February 15 through December 31, 2013. Then I went and got brunch and came back to check on the results. It seems that @MileValue was sortof correct. Looking through the results there were not a ton of dates with premium cabin seats available on the TAM-operated flights. Inventory was surprisingly wide open for GRU-Madrid between June 27 – August 1, but not much else. At that point I basically walked away from the project, knowing that there was some space but not a ton.
But today I’m sitting in a jury duty waiting room, desperately hoping to not be picked and I needed something to do so I’m looking over the data in more detail. Filtering for only flights offering business or first class (the initial challenge was any seat in any cabin) availability, looking at all carriers and all European gateways I came up with more than 350 options. And that’s even after excluding the phantom F inventory from Lufthansa. It turns out that perhaps we were asking the wrong question on Sunday.
Nearly 200 flights have first class inventory and more than 250 have business class (about 100 have both). Not every carrier is always available. Neither is every gateway. But there are a lot of dates available from May through December. TAM is only available from mid-May through July but other carriers have broader options. And TAM also has their Milan and Paris flights showing quite a few dates available. The raw(-ish) data is here.
If I limit the results only to economy class flights there are more than 600 route/date combinations with seats available. Milan, Paris and Madrid are, again, the most commonly available destinations but Barcelona, Munich, Zurich, Lisbon and even Porto show up somewhat regularly as available. Oh, and I’m not including the various options which involved transiting Buenos Aires, Mexico City or various North American gateways. Those would add a lot more flight options.
This is just a point in time snapshot of the inventory. I have no idea how much is still available today. And obviously this doesn’t mean that there is always a flight available when you are looking. Maybe getting that award will require an extra connection or moving a day or two for finding seats. But don’t be dissuaded by rumors of destinations supposedly impossible to get award seats into or out of. Turns out the seats are more available than you might think.
Anyone have another route or city they’re interested in seeing a compilation of data on? Turns out these aren’t all that hard to generate, though I do have to be a bit careful about the number of queries I’m running.