Mt Juliet, TN
Registered aircraft · 23
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'TN' AND g.registrant_city = 'MT JULIET' 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 = 'TN' AND g.registrant_city = 'MT JULIET' 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.
N128TMFun Flight M24 ORION PLUS · S/N 24245086N1728HPiper PA-28-161 · S/N 28-7716047N194TDBombardier BD-100-1A10 · S/N 20232N22233Taylorcraft BL · S/N 1179N23JFCessna 170B · S/N 26778N2443FPiper PA-38-112 · S/N 38-79A0445N2452TPiper PA-38-112 · S/N 38-78A0807N24KKCessna 172M · S/N 17266333N2579DPiper PA-38-112 · S/N 38-79A0361N2590GPiper PA-38-112 · S/N 38-79A0560N334ABBerges Duncan L VANS RV9A · S/N 90784N355ERAerospatiale AS 355F2 · S/N 5436N441AHEurocopter EC120B · S/N 1426N4715LPiper PA-28-180 · S/N 28-4035N47187Aeronca 0-58B · S/N 11473N533WPCessna 340A · S/N 340A0328N648VBeech B95 · S/N TD-340N7175SStiles Lorren RV-7 · S/N 73777N7828NPiper PA-28-180 · S/N 28-5281N8234BCessna 172 · S/N 36034N8295HPiper PA-28-161 · S/N 28-8316013N83729Aeronca 7AC · S/N 7AC-2407N9731KPiper PA-34-200T · S/N 34-7870036
Back to Mt Juliet, TN