Airports & Aircraft Database

[luizdom]

About aircraft and runway length.
For example 737-800 need 7,874 ft, but this full right?
Very rare a plane take off full
my idea;
Decrease 10% of the 7,874ft
and needing 7,086ft of runway to take off

[POTKC]

That's actually a very good idea. Perhaps even a 10% decrease to account for the fact that runway requirements are often given at max gross and at high temperature?

[Unknown98]

Well another thing we could do is use the number of passengers you have on board to calculate the runway length required. And if you are at an airport with a short runway then your passengers would be limited. I believe airline empires does this. We'd just have to figure out some kind of weight-to-range ratio/formula.

[POTKC]

That is an option, but would make planning routes much more complicated. The way I did route planning in CA was see where a specific aircraft could fly from the airport it was based at and choose destinations based on that, but limiting the number of passengers on a return flight would have the potential to cause financial issues if people plan their networks this way.

[skifans]

I think using just a % system alone would be too simple, to use Luizdom's example from above, then the 737 could take off in just 78.74 ft (with a 1% loading) which while impracticable and unprofitable it seems strange that this option does exist. I haven't done any reasurch to establish figures but could we maybe look at limiting the drop at say, 25%. So if your aircraft has a 75% loading, then 75% of the runway length is used, but any lower loading at 75% less remains the runway requirement.

[USA]

Use the weight of fuel needed to operate the route with an assumption of average weight added per passenger both added to a planes operating empty weight to just make an assumption as to what the aircrafts weight would be and then base the % difference between that and MTOW as the % difference in runway length needed - making adjustments obviously if necessary.

---

It would be a lot more complex than anything we've seen with CA, but it would be the most realistic and would only require you to find one extra number (an OEW) for each airplane to make it work.

[Unknown98]

I knew USA would have something lol. Sounds simple enough to me.

[ALT2870]

Good to see all those airports I did for Venture are still there and have some us.

[Unknown98]

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.

[chaitanya]

Can we do time zones longitude wise? Longitude between x.yz* and a.bc* to have time zone +5?

---

ALTER TABLE airports SET timezone = "+1" WHERE longitude <= 5 AND longitude >=16
(I am.mot good with sql)