You guys have added 212 airports over the course of only 4 days. Keep on keepin' on, lol. That's more that I could have done myself for sure.
Once we reach a point where we think all the airports are accounted for, we need to start looking at airports that are missing data (specifically cargo data) and see if we can find anything. If not, we can probably make an educated guess based on all the other data we have. Some airports we may just not be able to find anything. I looked for about 20 minutes for cargo data on midland international airport, for example, and still couldn't find anything.
edit: We're also going to need the timezone offset data for all airports. Now, I can do a lot of these fairly easily with SQL, for example a lot of countries have the entire country in one time zone, so I can do something like: ALTER TABLE airports SET timezone = "+1" WHERE country = "Germany". But for other countries that are split between several timezones we'll have to do each airport manually.
Once we reach a point where we think all the airports are accounted for, we need to start looking at airports that are missing data (specifically cargo data) and see if we can find anything. If not, we can probably make an educated guess based on all the other data we have. Some airports we may just not be able to find anything. I looked for about 20 minutes for cargo data on midland international airport, for example, and still couldn't find anything.
edit: We're also going to need the timezone offset data for all airports. Now, I can do a lot of these fairly easily with SQL, for example a lot of countries have the entire country in one time zone, so I can do something like: ALTER TABLE airports SET timezone = "+1" WHERE country = "Germany". But for other countries that are split between several timezones we'll have to do each airport manually.