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]