Henderson, KY
Registered aircraft · 46
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 = 'KY' AND g.registrant_city = 'HENDERSON' 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 = 'KY' AND g.registrant_city = 'HENDERSON' 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.
N107CLDiamond Aircraft Ind DA20-C1 · S/N C0007N136MADiamond Aircraft Ind DA20-C1 · S/N C0260N141BBDiamond Aircraft Ind DA20-C1 · S/N C0311N155KPCessna 182P · S/N 18263197N18446Beech 95-B55 (T42A) · S/N TC-2086N205BLDiamond Aircraft Ind DA20-C1 · S/N C0249N20937Dart GC · S/N G-41N263CFDiamond Aircraft Ind DA20-C1 · S/N C0263N285MADiamond Aircraft Ind DA20-C1 · S/N C0285N301DBCessna 310R · S/N 310R0891N33STellier G F/Tellier J G PITTS S1S · S/N K066N352DCDiamond Aircraft Ind DA20-C1 · S/N C0352N363TBeech 95-A55 · S/N TC-416N4157EPiper PA 31P 350 · S/N 31P-8414047N41SEDiamond Aircraft Ind DA20-C1 · S/N C0246N42392Piper J3C-65 · S/N 14649N460MADiamond Aircraft Ind DA20-C1 · S/N C0344N484DCDiamond Aircraft Ind DA20-C1 · S/N C0251N485AGDiamond Aircraft Ind DA 42 · S/N 42.AC085N487MADiamond Aircraft Ind DA20-C1 · S/N C0327N509DCDJI AGRAS T50 · S/N 1581F6BUB235N001002TSale reportedN5249TPiper PA-28R-200 · S/N 28R-7235204N5403NBoeing B75N1 · S/N 75-7468N56KDDiamond Aircraft Ind DA 42 · S/N 42.AC076N624TBeech H35 · S/N D-5321N62PADiamond Aircraft Ind DA20-C1 · S/N C0323N655DCDiamond Aircraft Ind DA20-C1 · S/N C0155N68356Cessna 152 · S/N 15285327N713MWDiamond Aircraft Ind DA20-C1 · S/N C0010N733CXCessna 172N · S/N 17268201N737GCCessna 172N · S/N 17269398N75726Cessna 172N · S/N 17267905N804ERDiamond Aircraft Ind DA 40 · S/N 40.311N806ERDiamond Aircraft Ind DA 40 · S/N 40.317N81BLPiper PA46-500TP · S/N 4697160N857PADiamond Aircraft Ind DA20-C1 · S/N C0218N879CTDiamond Aircraft Ind DA20-C1 · S/N C0079N879FZTextron 172S · S/N 172S12403N9034QMaire David BAKENG DUCE · S/N DM-11N928EJQuicksilver MX II SPRINT · S/N 0635N933DSDiamond Aircraft Ind DA 40 · S/N 40.327N957DDTextron 172S · S/N 172S12775N9734BCessna 172RG · S/N 172RG0999N985BJTextron 172S · S/N 172S11634N987CTDiamond Aircraft Ind DA20-C1 · S/N C0087N999VCDiamond Aircraft Ind DA 40 · S/N 40.506
Back to Henderson, KY