Complete Airports List

Juan Carlos Esteve · March 26, 2011

OK, Free hosting can limit limit you, so that's the problem, Free Hostings are not good. Paid ones, you won't have that kind of problems.

Hello, we has hosting at www.dreamhost.com, isn't free

We can't maintain a complete list of airport.

43000 reg in memory?? humm is too much.

phpVMS is wonderfull any way

Thanks !!

Kyle · March 26, 2011

Hey,

I took a look at your hosting, you can have it in your hosting, but not sure.

But the other side, if you are a "world-wide" airlines with every airport, and this is for you. But I would usually add the airports I do really need.

michael Kraan · March 29, 2011

Heeyy,,

This is really useful thanks! but do have a problem:

how do you install it on the site?

Michael

Kyle · March 29, 2011

Hey,

You go to phpMyAdmin and then go to your phpvms database and on the top, click on import and then elect the zip file that you downloaded and let it run it will take a while

But one thing, it could be restricted by your hosting but it s a wroth a try.

November 2, 2011

Any of you sql wizards know if there is a way to make it skip entries that exist already instead of stopping? At most all I can get in is 58 airports. Before trying to run this I had only like 30 in my DB.

I suppose I could drop all my airports and start from scratch since it is a dev site anyhow. I hate to do that though due to schedules I already have that I do fly with for testing purposes.

Try INSERT IGNORE

November 2, 2011

Trying to make preferred routes my flight schedules...

Help Please....

Peferred Routes Database

TennShadow · November 2, 2011

Trying to make preferred routes my flight schedules...

Help Please....

Peferred Routes Database

Your best bet would be to log into your site and export the schedules template under "Airline Operations". Then you will see what columns are required from your list. In regards to your preferred routes list you could import that into Excel to help you copy and paste some of the data between that and your schedules template.

Good Luck

November 3, 2011

Will I now have 19000 preferred routes as my flight schedule... Just need to clean it up a little...

[importable Preferred Routes]

Thx for your help...

Nighthawk · December 21, 2011

To Work with a sql database i use navicat. Its free and easy.

rpalmer800 · March 25, 2012

@ SimPilot, That is a HUGE help, Thank you so very much.

animalking · May 18, 2012

Thank you so much for this great file, you're amazing

smeely · July 3, 2012

Would I be able to get the FSX database file?

Rnaetsar · January 27, 2014

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said:

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

dohavik · March 16, 2014

Thanks simpilot for the file with the airports data

cmtehudson · November 23, 2014

Hi guys,

I'm having major snags with this! I've tried importing this file into PHPMyAdmin, but I get this error:

Error

SQL query:

-- -- Database: `aca` -- -- -- Dumping data for table `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (1, '00A', 'Total Rf Heliport', 'US', 40.0708, -74.9336, 0, 0, ''), (2, '00AK', 'Lowell Field', 'US', 59.9492, -151.696, 0, 0, ''), (3, '00AL', 'Epps Airpark', 'US', 34.8648, -86.7703, 0, 0, ''), (4, '00AR', 'Newport Hospital & Clinic Heliport', 'US', 35.6087, -91.2549, 0, 0, ''), (5, '00AZ', 'Cordes Airport', 'US', 34.3056, -112.165, 0, 0, ''), (6, '00CA', 'Goldstone Gts Airport', 'US', 35.3505, -116.888, 0, 0, ''), (7, '00CO', 'Cass Field', 'US', 40.6222, -104.344, 0, 0, ''), (8, '00FA', 'Grass Patch Airport', 'US', 28.6455, -82.219, 0, 0, ''), (9, '00FD', 'Ringhaver Heliport', 'US', 28.8466, -82.3454, 0, 0, ''), (10, '00FL', 'River Oak Airport', 'US', 27.2309, -80.9692, 0, 0, ''), (11, '00GA', 'Lt World Airport', 'US', 33.7675, -84.0683, 0, 0, ''), (12, '00GE', 'Caffrey Heliport', 'US', 33[...]

MySQL said:

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

Why doesn't it just overwrite it? I can't for the life of me get it to work

I'm with the same problem.... Someone know what to do?

simpilot · November 23, 2014

Why doesn't it just overwrite it? I can't for the life of me get it to work

There is nothing to overwrite......

#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist

The table does not exist (phpvms_airports) or you have a different prefix than phpvms_

If you deleted the table prior to trying to insert the new data then you will have to replace the table prior to the data insert. If your table already has data just empty the table (Truncate)

If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file.

cmtehudson · November 23, 2014

There is nothing to overwrite......
#1146 - Table 'wdwvacom_wdw.phpvms_airports' doesn't exist
The table does not exist (phpvms_airports) or you have a different prefix than phpvms_

If you deleted the table prior to trying to insert the new data then you will have to replace the table prior to the data insert. If your table already has data just empty the table (Truncate)

If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file.

"If you are using a different prefix you will either have to temporarily change the prefix or change all instances of the prefix in the data file."

What i was made. I opened the file and changed all the "phpvms_airports" to my table name, in this case, to "phpvms_globairports" and worked fine.

THanks for it sim, really nice!!

Thanks again!

Hudson

PS: Sorry my english errors

Simnut · March 7, 2015

Massive help! Thank you very much

cvonhaytersirls · August 5, 2015

I was reading through and it looked like the problem I had someone else had, but it hadn't been resolved yet. I can't view the airport list on the admin site. nothing shows up. How do I fix this, i tried clearing the cached data as well as optimize the tables but they still won't show. What do I need to do?

CJ

Zakariya · November 25, 2015

hi, i am just wondering if there is a updated data base like this one. When i try to import the file it gives me errors like "Invalid syntax" etc

mattsmith · January 1, 2016

I need help with this. I have added all the airports to my php myadmin and they are showing fine.

When i go to my VA the airports aren't showing.

OmerAslan · March 9, 2016

Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try.

Thanks i download this but can you tell me where do i have to add this file? Sorry i am new. Thanks

pedroportugal · July 2, 2016

hello everyone i install the the DB locks ok but i use smartacars and the smartacars wont conect to my server because the airports. i delete this DB and install my old DB end works again. the diference its 41533 airports to 150 airports lol.

nicolaananda · July 21, 2016

Anyupdate for new icao code & airac?

ThomasSNAv · November 14, 2016

http://prntscr.com/d72qpm

_____________________

I have tried to import the airports, and this error is showing up, can anyone help?

ShrikarG · November 14, 2016

http://prntscr.com/d72qpm

_____________________

I have tried to import the airports, and this error is showing up, can anyone help?

First empty all the contents in phpvms_airports table. Then Import all the airports.

eliezerazevedo · September 4, 2017

Database with 52163 Airports. Fetus file to be used in PHPVMS

https://github.com/eliezerazevedo/Airports-PHPVMS

Sign In

Complete Airports List

Recommended Posts

Juan Carlos Esteve

Kyle

michael Kraan

Kyle

Guest

Guest

TennShadow

Guest

Nighthawk

rpalmer800

animalking

smeely

Rnaetsar

dohavik

cmtehudson

simpilot

cmtehudson

Simnut

cvonhaytersirls

Zakariya

mattsmith

OmerAslan

pedroportugal

nicolaananda

ThomasSNAv

ShrikarG

eliezerazevedo

Join the conversation