Registered aircraft · 17

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'GA' AND g.registrant_city = 'MILLEDGEVILLE' ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'GA' AND g.registrant_city = 'MILLEDGEVILLE'
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'GA' AND g.registrant_city = 'MILLEDGEVILLE'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N101RXIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 262Built 2008 · Gb Aviation LLC N1498APiper PA-22 · S/N 22-403Built 1952 · Spivey Larry B N243MECessna 206H · S/N 20608113Built 2000 · Mcaleer William V Jr N26423Grumman American Avn. AA-5A · S/N AA5A0583Built 1978 · Poulnott William N30158Cessna 177 · S/N 17701087Built 1968 · Segroves Jeffrey S N30709Cessna 177B · S/N 17701415Built 1969 · Wessels Jr Steven A N3815WPiper PA-32-260 · S/N 32-746Built 1966 · Ck Aviation LLC N3832LCessna 172G · S/N 17254001Built 1966 · Arnold Jonah Jr N3880YCessna 210D · S/N 21058380Built 1964 · Lake Country Aviation LLC N519JMBeech C24R · S/N MC-634Built 1978 · Wolfgang James N527WMooney M20R · S/N 29-0224Built 2000 · Mitchell Grayson N584DFBeech 58 · S/N TH-1605Built 1990 · Hangar 3 LLC N7124EWilliam Thomasson RV-14A · S/N 141131Thomasson William N7175QCessna 182P · S/N 18262042Built 1973 · Tcb Solutions LLC N750PDJames Russel Depfer SR STOL CH750 · S/N 75-8139Built 2012 · Tcb Solutions LLC N814GPGrumman American Avn. AA-1B · S/N AA1B-0503Built 1974 · Jackson Jefferey W N8672UCessna 172F · S/N 17252575Built 1965 · Echo Tango LLC

Back to Milledgeville, GA