Louisville, KY
Cancelled registrations · 411
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'KY' AND d.registrant_city = 'LOUISVILLE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'KY' AND d.registrant_city = 'LOUISVILLE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N259UPMcdonnell Douglas MD-11F · S/N 48417N282UPMcdonnell Douglas MD-11F · S/N 48452N295UPMcdonnell Douglas MD-11F · S/N 48475N272UPMcdonnell Douglas MD-11F · S/N 48571N279UPMcdonnell Douglas MD-11F · S/N 48573N280UPMcdonnell Douglas MD-11F · S/N 48634N283UPMcdonnell Douglas MD-11F · S/N 48484N565LBCameron Balloons Z-90 · S/N 6539N270UPMcdonnell Douglas MD-11F · S/N 48576N285UPMcdonnell Douglas MD-11F · S/N 48457N988CTDiamond Aircraft Ind DA20-C1 · S/N C0088N787AXBoeing 767-281 · S/N 23020N794AXBoeing 767-281 · S/N 23144N3577APiper PA-22-135 · S/N 22-1851N3758GPiper PA-22-150 · S/N 22-2744N9DXReynolds Harold L SONEX · S/N 0999N271UPMcdonnell Douglas MD-11F · S/N 48572N296UPMcdonnell Douglas MD-11F · S/N 48474N5740KBeech D95A · S/N TD-579N120SACessna 310Q · S/N 310Q1041N248MHPiper J3C-65 · S/N 20820N9522PCameron Balloons US PENGUIN-90 · S/N 2068N3010NLindstrand Balloons 77A · S/N 5087N132LBLindstrand Balloons 150A · S/N 5101N275ELearjet 24D · S/N 245N365Joyce Patrick M HUMMELBIRD · S/N 5288N314DABoeing 737-232 · S/N 23086N44QKSensefly EBEE · S/N EB-03-31690N277UPMcdonnell Douglas MD-11F · S/N 48578N794HBDJI PHANTOM 3 PROFESSION · S/N P76DCL22B27058N102EJSchickli Edward Jacob JR NIEUPORT 17 · S/N 1079N160RBOates C Randy 69K · S/N 97-01N2796SRaven Industries RALLY RX7 · S/N RX7-421N30506Piper J3L-65 · S/N 4884N128VBBeech 95-B55 (T42A) · S/N TC-1211N694WXDJI INSPIRE 1 · S/N W13DCC28030462N6345TNorth American/Aero Classics P-51D · S/N 44-63507N707FCDJI PHANTOM 3 PROFESSION · S/N P76DCJ30A21121N649XGYuneec Electric TYPHOON Q500 4K · S/N YU15270802B04B01N651LEYuneec Electric TYPHOON Q500 4K · S/N YU15130139B02B01N31830Aeronca 65-CA · S/N C11320N330GKPiper PA-23-250 · S/N 27-2943N5626BZarestky Jerel CHALLENGER I · S/N 0201-W-0751N637QDDJI PHANTOM 3 STANDARD · S/N P5ADCG240600DGN633LDDJI PHANTOM 3 ADVANCED · S/N P76DCE07033604N566HDSensefly EBEE · S/N EB-02-287N578FDSensefly EBEE · S/N EB-02-281N2449RRaven S-50A · S/N S50A-279N5652GDJI PHANTOM 2 VISION + · S/N BH301634447750N5684GRaven S55A · S/N S55A-520
Back to Louisville, KY