Duluth, MN
Cancelled registrations · 826
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 = 'DULUTH' 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 = 'DULUTH' 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.
N1105NCirrus Design SR22T · S/N 10042N982FGCirrus Design SR22 · S/N 9825N512CACirrus Design SR22 · S/N 9110N221PRCirrus Design SR20 · S/N 9094N66ASCirrus Design SR22 · S/N 9502N25AZCirrus Design SR22T · S/N 9338N232BDCirrus Design SR22T · S/N 9542N127RHCirrus Design SR22 · S/N 9592N88RYCirrus Design SR22T · S/N 9309N404SRCirrus Design SR22T · S/N 9507N935WCCirrus Design SR22 · S/N 9355N939CZCirrus Design SR22T · S/N 9397N62KNCirrus Design SR22T · S/N 9111N439UKCirrus Design SR22T · S/N 9439N123CSCirrus Design SR22T · S/N 9404N223MXCirrus Design SR22 · S/N 9099N9354Cirrus Design SR22 · S/N 9354N813UMCirrus Design SR22T · S/N 9149N386CACirrus Design SR22T · S/N 9360N982JDCirrus Design SR22T · S/N 8982N260KRCirrus Design SR20 · S/N 9260N274SBCirrus Design SR22T · S/N 9330N351TCCirrus Design SR22T · S/N 9341N810ACirrus Design SR22T · S/N 9331N82LJCirrus Design SR22 · S/N 8323N221GBCirrus Design SR22T · S/N 9342N281PHCirrus Design SR20 · S/N 9161N9274CCirrus Design SR20 · S/N 9274N788RCirrus Design SR22T · S/N 9150N9241DCirrus Design SR20 · S/N 9241N223FTCirrus Design SR20 · S/N 9090N9183RCirrus Design SR22T · S/N 9183N447VJCirrus Design SF50 · S/N 0447N52PKCirrus Design SR22T · S/N 9262N987BKCirrus Design SR22T · S/N 9187N105SBCirrus Design SR20 · S/N 9222N154JDCirrus Design SR22T · S/N 9148N930CZCirrus Design SR22T · S/N 8930N958CZCirrus Design SR22T · S/N 9058N64UKCirrus Design SR22T · S/N 9120N903BTCirrus Design SR22T · S/N 8903N902MGCirrus Design SR22T · S/N 9020N931JCCirrus Design SR22T · S/N 9031N949CZCirrus Design SR22T · S/N 9049N762JDCirrus Design SR22T · S/N 2343N967JACirrus Design SR22T · S/N 8967N291MFCirrus Design SR22T · S/N 8736N965RMCirrus Design SR22T · S/N 8965N311EGCirrus Design SR22T · S/N 8939N149BBCirrus Design SR22 · S/N 9013
Back to Duluth, MN