I believe you. Believe me when I say that your system was the first one I tried. You just run into too many exceptions.
Here’s a couple I’m aware of:
Lisbon Airport and Cascais Aerodrome in Portugal both have IATA codes but one is a major hub and the other is a local aerodrome with a subsidised local airline.
There are 6 civillian aerodromes around Paris with IATA codes. Only 2 of them are commercial airports, the rest are general aviation.
Then we have the case of the USA. The American general aviation market is extremely vibrant. There are hundreds of regional aerodromes chock-full of activity, most of them with IATA codes. And they can be located anywhere, in the middle of nowhere, near a city, near other aerodromes. In this situation it becomes very difficult to distinguish between commercial airports and regional aerodromes using IATA codes alone.
Thank you.
I saw military and disused as outside the scope of what I was trying to accomplish. If there is demand I can approach it but I’d rather it be with a separate proposal.
Most aerodromes do not fit a category perfectly. You need to make an averaged decision of which category to choose, but this is par for the course.
East Midlands would normally be a continental class aerodrome ignoring cargo but we can factor it in.
First, we can see large cargo terminals and industrial zone in the satellite imagery.
Second, we can take the total cargo transported annually and calculate a very rough passenger equivalent. East Midlands seems to have transported 375000000kg in 2024. If we divide by 85kg, the standard weight for an adult male for use in weight and balance for aircraft, we get a kind of human equivalent of 4.4 million. Added to real passengers (4.1M), you get 8.5M.
All added up, we have 8.5M equivalent passengers in 2024 (continental), multiple large terminals (intercontinental), large supporting infrastructure (continental) and use by large and medium jets (intercontinental).
East Midlands seems to be right at the edge between an intercontinental and a continental aerodrome, but it leans smaller. I’d classify it as continental.