need some help with airport codes database

[daraptor]

hey guyz...i think this is off topic but am tryin to design a site for airfares and i need all airport codes mdb file....i would appreciate if anyone can help me out with this....plz help guyz....i need it very badly.......thanks....

 

[hansrijf]

If you find or get the complete list: pls let me know. I would like to have this list also.

In the meantime, try these:

http://library.avsim.net/sendfile.php?Location=AVSIM&Proto=ftp&DLID=533
http://library.avsim.net/sendfile.php?Location=AVSIM&Proto=ftp&DLID=80082
http://library.avsim.net/sendfile.php?Location=AVSIM&Proto=ftp&DLID=23630

One of these is an access 2003 database, I just don't remember which one...

OK, it's the middle one.

 

[Geffy]

hansrijf: those links seem to require login

http://en.wikipedia.org/wiki/List_of_airports_by_IATA_code will give them to you by first letter, it might take you some time but its probably a reasonably complete list.


Even a start of a database for you

CREATE TABLE airport_codes (
  iata CHAR (3) PRIMARY KEY NOT NULL,
  icao CHAR (4) UNIQUE,
  name VARCHAR (255) NOT NULL,
  city VARCHAR (255),
  locality VARCHAR (255),
  country CHAR (2) NOT NULL
);

---         IATA   ICAO    Airport name                       City        Locality            Country
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
    VALUES ('AAA', 'KAAA', 'Logan County Airport',            'Lincoln',  'Illinois',         'US');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
    VALUES ('AAA', 'NTGA', 'Anaa Airport',                    'Anaa',     'Tuamotu Island',   'PF');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
    VALUES ('AAB', 'YARY', 'Arrabury Airport',                'Arrabury', 'Queensland',       'AU');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
    VALUES ('AAC', 'HEAR', 'El Arish International Airport',  'El Arish', '',                 'EG');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
    VALUES ('AAD', ''    , 'Ad-Dabbah Airport',               'Ad-Dabbah', '',                'SD');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
    VALUES ('AAE', 'DABB', 'Rabah Bitat Airport (Les Salines Airport)', 'Annaba', '',         'DZ');