In Progress

FAA Aircraft database feed

The FAA produces a database of all aircraft registered in the US. What is needed is a job that will

1. FTP the data file from the FAA to a local machine (red hat linux)

2. Extract the data from the downloaded file and load it up into tables in a MySQL database. The tables to hold the data do not exist so you are free to decide on the design of those tables but straight copies of the formats in the feed is best.

2. Where data has changed since the last feed update where data has been removed delete where data has been added insert.

The data feed is available from :-

[url removed, login to view]

Skills: Perl

See more: faa data feed, faa feed, faa aircraft database, faa feeds, faa data feeds, mysql aircraft database, faa database aircraft, aircraft database mysql, faa database mysql, aircraft database, receive faa feeds, airplane database mysql, faa number database, faa registered aircraft database, faa database freelance, freelancer faa database, www faa gov, faa gov, database design job, cgi job, faa aircraft database mysql, mysql faa database, registered aircraft data, faa database feed, database feed

About the Employer:
( 1 review ) Leonardo nj, United States

Project ID: #35428