Convert ICAO to N-Number Into a MySQL DB

FlightAware ADS-B Flight Tracking
1

Hello All,

I am recording data to a MySQL DB. I am trying to figure out how to convert the ICAO code into an N-number.

Any ideas of how to do that? I use some php to extract the data from aircrafts.json and then insert into MySQL table. Ideally, I would do the conversion right before inserting the data.

I am guessing there is some javascript doing the conversion each time I click on an aircraft icon and display its particulars. Any help will be much appreciated.

John Ullom

2

dump1090-fa: https://github.com/flightaware/dump1090/tree/master/public_html_merged/db

Or you can try this: https://github.com/wiedehopf/tar1090-db/tree/csv
(which is based on https://www.mictronics.de/aircraft-database/ which would also work)

I believe OpenSkyNetwork also has some sort of reg database but i’m not familiar with it.

4

Thank you wiedhopf.I’ll take a look.

JCU

5

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.