Gallatin, TN
Registered aircraft · 69
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 = 'GALLATIN' 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 = 'GALLATIN' 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.
N104CVGaskins Abe B SAFARI 400 · S/N CH1503N1150NPilatus PC-12/47E · S/N 1156N115MFDassault-Breguet FALCON 50 · S/N 330N122GSBeech E18S · S/N BA-259N12ACirrus Design SR22T · S/N 11431N1307HPiper PA-28-161 · S/N 28-7716015N142DBCirrus Design SR22T · S/N 1894N1684FCessna 172H · S/N 17255079N1750HPiper PA-32R-300 · S/N 32R-7780189N176KMCirrus Design SR22T · S/N 1851N194WENightingale R/Nightingale M VANS RV-9A · S/N 90259N1977TRobert B Tugwell RV-6A · S/N 60422N211DBTextron 525B · S/N 525B0533N21347Cessna 172M · S/N 17263933N215LBLindstrand Balloons 77A · S/N 5264N226SFCirrus Design SF50 · S/N 0481N230SRCirrus Design SR22 · S/N 2361N24050Keleher Lark JK 1-A · S/N 125N2411PPiper PA-18-150 · S/N 18-8009010N2433RCessna 182G · S/N 18255533N255GRRaven Lake AIRCAM · S/N AC 212N2808RCessna 182K · S/N 18258408N2912PPiper PA-22-150 · S/N 22-3180N327BABeech B100 · S/N BE99N3455Hall W/Stripling C VANS RV7-A · S/N 72685N34HYAviat A-1B · S/N 2124N393KBTextron 680A · S/N 680A-0057N413CNCirrus Design SR22 · S/N 3651N4250JPiper PA-28-140 · S/N 28-22606N4278LCessna 152 · S/N 15281218N4473YPiper PA-16 · S/N 16-375N44780Piper PA-28-235 · S/N 28-7510005N498CCPiper PA-28R-200 · S/N 28R-7635447N5048ABellanca 8KCAB · S/N 516-79N5159LPowrachute PC 2000 · S/N A-296POWN527LQCirrus Design SR22T · S/N 1110N52HACessna 182T · S/N 18282226N5302XCessna 182T · S/N 18281175N5381TPiper PA-32-300 · S/N 32-7240106N55150Piper PA-28-180 · S/N 28-7305322N5698GCessna 150K · S/N 15071198N580JHEmbraer-Empresa Brasileira De EMB-500 · S/N 50000006N58PCBeech 58P · S/N TJ-101N5911YPiper PA-23-250 · S/N 27-3067N59182Cessna 182B · S/N 51578N595DLCirrus Design SR22T · S/N 1681N600JGPiper PA-32-300 · S/N 32-40726N606MCCessna 525C · S/N 525C0121N615WBWilliam M Barrett RV-14A · S/N 140729N623PMCessna 650 · S/N 650-7018
Back to Gallatin, TN