Hendersonville, TN
Registered aircraft · 61
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 = 'HENDERSONVILLE' 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 = 'HENDERSONVILLE' 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.
N1057WBeech A36 · S/N E-408N1165NMooney M20J · S/N 24-1350N138DWWebster Merle Dean RV-6A · S/N 22798N1631GChampion 7KCAB · S/N 127N169FBDJI MINI 2 · S/N 3Q48KAD003ROYAN169MBDJI MINI 3 PRO · S/N 1581F4XFA233EML893ZGN172TXCessna 172N · S/N 17271027N19SABeech A36 · S/N E-1795N1AYCirrus Design SR22 · S/N 5031N2126DBeech D35 · S/N D-3471N214EDPiper PA-44-180 · S/N 44-8195007N265JHLockwood SUPER DRIFTER · S/N 1061SDN26PSLowrance Darrell 12 · S/N 298N2776RKrucker CYGNET · S/N H20037N282CBCirrus Design SR22 · S/N 3782N2839NCessna 140 · S/N 13100N3057JCessna 150E · S/N 15061157N314YFCirrus Design SR20 · S/N 2302N3212ABalloon Works FIREFLY 7-15 · S/N F7-897N329WWWoodson Warren W MUSTANG II · S/N M-II-1758N33453Piper J3F-65 · S/N 5962N353TSCessna 425 · S/N 425-0221N4047STextron 525 · S/N 525-1121N4062NCessna 140 · S/N 13520N43221Piper PA-28-180 · S/N 28-7405181N438AGDJI AVATA · S/N 1581F4QWB22B4003048UN4463SBeech F33A · S/N CE-580N474FLPiper PA-28-140 · S/N 28-7125279N5133QCessna 172M · S/N 17261761N5201QCessna 172M · S/N 17261770N5271LPiper PA-28-180 · S/N 28-4569N550WTCessna 550 · S/N 550-0599N5624SBeech V35 · S/N D-8168First renewal noticeN612WMWayne L Ristine RANS S-7S · S/N 0215612N617KGBeech D-45 · S/N BG-279N6308NChampion 7ECA · S/N 194N6354JPiper PA-28-180 · S/N 28-4764N6457DCessna 172N · S/N 17272809N661TUCostruzioni Aeronautiche Tecna ASTORE · S/N 061N67296Grumman American Avn. AA-5 · S/N AA5-0764N692BSMissoula SUPER DRIFTER · S/N SD 32621N7175NBeech E33A · S/N CE-201N72406Cessna 337G · S/N 33701577N734CSCessna 172N · S/N 17268755N739VNCessna 172N · S/N 17270842N744TJTed Jepsen LIGHTNING XS · S/N 207N748SMooney M20B · S/N 1728N7951RBeech 36 · S/N E-145N841KYBeech 200 · S/N BB-841N8467RPiper PA-28-140 · S/N 28-22144
Back to Hendersonville, TN