Alexandria, MN
Cancelled registrations · 59
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 = 'MN' AND d.registrant_city = 'ALEXANDRIA' 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 = 'MN' AND d.registrant_city = 'ALEXANDRIA' 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.
N888VKDJI INSPIRE 1 · S/N W130CA30020277N726HCDJI PHANTOM 3 ADVANCED · S/N P76DCI06016079N6217WDJI PHANTOM 2 VISION + · S/N BF121620028927N594TNDJI PV331 · S/N PH645268098 V2.0N104MVBellanca 17-31A · S/N 73-32-111N4375GMccormick Kevin KM4 · S/N 001KM498N7578DBeech A60 · S/N P-177N7618EBellanca 14-19-3 · S/N 4120N601TSSmith AEROSTAR 601P · S/N 61P-0194-014N39805Bellanca 17-31A · S/N 73-32-99N4036BBellanca 17-30A · S/N 76-30800N7308VBellanca 17-30 · S/N 30163N8827VBellanca 17-30A · S/N 30336N6592VBellanca 17-30A · S/N 30276N121ALBellanca 17-31ATC · S/N 31040N68569Bellanca 8KCAB · S/N 44-72N45716Cessna 150M · S/N 15077033N1900Cessna 180A · S/N 50085N114DHNorth American T-28B · S/N 138357N838MMBellanca 17-30 · S/N 30014N7474CConover Deeann HUMMELBIRD · S/N 181526077N2872ZBellanca 7ECA · S/N 123878N188ALPiper PA-34-200T · S/N 347970121N474USBoeing 727-51 · S/N 18944N93649Bellanca 17-30A · S/N 7330589N812SSThompson Harrison C TKD BATHTUB · S/N 1N5725UPiper PA-28-140 · S/N 28-26531N5069EBellanca 8KCAB · S/N 60580N6660ACessna 172 · S/N 28760N5028NBellanca 7ECA · S/N 133480N3531FCessna 182J · S/N 18257531N9089EAeronca 11AC · S/N 11AC-722N76PDBellanca 8GCBC · S/N 220-76N8675VBellanca 8GCBC · S/N 173-75N4732VBellanca 17-30 · S/N 30061N8586VBellanca 7GCBC · S/N 798-75N8555VBellanca 8GCBC · S/N 138-75N4107BBellanca 17-30A · S/N 75-30744N88378Bellanca 8GCBC · S/N 119-74N87060Bellanca 8GCBC · S/N 58-74N57686Bellanca 8KCAB · S/N 131-74N93729Bellanca 17-30A · S/N 74-30621N8945Bellanca 7GCAA · S/N 281-74N39860Bellanca 17-31A · S/N 73-32-106N4210PPiper PA-23-160 · S/N 23-1703N8792VBellanca 17-30A · S/N 30363N9275PPiper PA-18-150 · S/N 18-8903N6333KRepublic RC-3 · S/N 557N4929VBellanca 17-30 · S/N 30140N8897RBellanca 14-19-3A · S/N 4259
Back to Alexandria, MN