Mount Juliet, TN
Registered aircraft · 45
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 = 'MOUNT 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 = 'MOUNT 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.
N101DADiamond Aircraft Ind DA 42 · S/N 42.125N11933American General Acft AG5B · S/N 10073N129AMolino PIK-20B · S/N 20079N12GUAB Sportine Aviacija LAK-17A · S/N 150N1417QCessna 150L · S/N 15072717N14LNPiper PA-28-140 · S/N 28-7225043N1630CCessna 180 · S/N 30330N184RJJory Frederick Allen VANS RV-8A · S/N 80963N199TUCostruzioni Aeronautiche Tecna P2006T · S/N 199/USN216CLCessna 152 · S/N 15284706N2315VPiper PA-38-112 · S/N 38-82A0085N2353EAeronca 7AC · S/N 7AC-5930N237MCCessna 750 · S/N 750-0014N2382VPiper PA-38-112 · S/N 38-82A0061N2408LPiper PA-38-112 · S/N 38-79A0696N242DPDiamond Aircraft Ind DA 42 · S/N 42.AC032N3053NPiper PA-28-181 · S/N 28-7990288N32RTPiper PA-32RT-300 · S/N 32R7987008N3939SCessna 172E · S/N 17251139N39752Waco UPF-7 · S/N 5885N47EEPiper PA-23-250 · S/N 27-2009N5213YPiper PA-23-250 · S/N 27-2261N55041Piper PA-28-180 · S/N 28-7305297N604YADJI INSPIRE 1 · S/N W13DCB08020584N6303RPiper PA-28-140 · S/N 28-21468First renewal noticeN6451APiper PA-38-112 · S/N 38-78A0426N6816BCessna T210M · S/N 21062837N6864NMooney M20C · S/N 680144N701PGWinder Paul G ZENITH CH 701 · S/N 7-6117Registration pendingN7363GCessna 172K · S/N 17259063N7AVCirrus Design SR22 · S/N 1053N8065LCessna 172H · S/N 17256265N8069UBeech A36 · S/N E-2727N8209EPiper PA-28-161 · S/N 28-8316027N824SPCck-2000-0069 CCK-2000 · S/N CCK-2000-0069N831PRCessna U206F · S/N U20603452N847GGCirrus Design SR22T · S/N 1654N8533PPiper PA-24-400 · S/N 26-114N863JJMcmahon John RV6 · S/N 22411N88MBBeech E-55 · S/N TE844N8929HNorth American NAVION · S/N NAV-4-929N908JBHawker Beechcraft HAWKER 900XP · S/N HA-0013N9811TPiper PA-38-112 · S/N 38-78A0213N9967UGrumman American Avn. AA-5A · S/N AA5A0367N996MWCessna 172M · S/N 17262434
Back to Mount Juliet, TN