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.
N1989XCirrus Design SR22T · S/N 1993N509GWCirrus Design SR20 · S/N 2509N318LMCirrus Design SR22T · S/N 1912N194MDCirrus Design SR22T · S/N 1949N123GZCirrus Design SF50 · S/N 0120N389CDCirrus Design SR22 · S/N 1306N944CZCirrus Design SR22T · S/N 1944N246MSCirrus Design SR20 · S/N 2501N194JFCirrus Design SR22T · S/N 1942N761CMCirrus Design SR22 · S/N 4761N420ESCirrus Design SR22T · S/N 1915N39ARCirrus Design SR22T · S/N 1886N460BKCirrus Design SR22 · S/N 4602N191NBCirrus Design SR22T · S/N 1911N477HRCirrus Design SR22 · S/N 4772N150CACirrus Design SR22 · S/N 4751N1430Cirrus Design SR22 · S/N 4742N222LUCirrus Design SR22 · S/N 4658N846JDCirrus Design SR22T · S/N 1846N763MSCirrus Design SR22 · S/N 4763N825EHCirrus Design SR22T · S/N 1883N261PCirrus Design SR22 · S/N 4580N5431DDJI PHANTOM 3 PROFESSION · S/N P77DCF27011416N6903XCessna 172B · S/N 17247803N526MTCirrus Design SR22 · S/N 4643N871EBCirrus Design SR22T · S/N 1871N203ARCirrus Design SR22 · S/N 4525N5431XDJI PHANTOM 3 PROFESSION · S/N P76DCD23010215N837VCCirrus Design SR22T · S/N 1837N712KHCirrus Design SR22 · S/N 4712N338SYCirrus Design SR22T · S/N 1796N794MGCirrus Design SR22T · S/N 1794N266MLCirrus Design SR22T · S/N 1803N456CPCirrus Design SR22 · S/N 4682N1801HCirrus Design SR22T · S/N 1801N228SYCirrus Design SR22 · S/N 4651N695JLCirrus Design SR22 · S/N 4695N460SDCirrus Design SR20 · S/N 2454N677CZCirrus Design SR22 · S/N 4677N32SCCirrus Design SR22 · S/N 4681N515MCCirrus Design SR22 · S/N 4657N656GHCirrus Design SR22 · S/N 4656N218NDCirrus Design SR22T · S/N 1688N131JPCirrus Design SR20 · S/N 2450N247AVCirrus Design SR20 · S/N 2311N251AVCirrus Design SR20 · S/N 2313N280CJCirrus Jet SJX · S/N 0001N496DBCirrus Design SR22 · S/N 4496N714LDCirrus Design SR22T · S/N 1714N732MSCirrus Design SR22T · S/N 1732
Back to Duluth, MN