Duluth, MN
Cancelled registrations · 822
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.
N602CACirrus Design SR22T · S/N 11377N181SRCirrus Design SR22T · S/N 11391N794VJCirrus Design SF50 · S/N 0794N851VJCirrus Design SF50 · S/N 0851N212DMCirrus Design SR22T · S/N 11158N460CCirrus Design SR22T · S/N 11196N28JFCirrus Design SR22T · S/N 11138N94ESCirrus Design SF50 · S/N 0823N222CNCirrus Design SF50 · S/N 0801N156GHCirrus Design SR22 · S/N 11142N99CSCirrus Design SR22T · S/N 10851N51GHCirrus Design SR22T · S/N 10911N167WCirrus Design SR22T · S/N 11130N456CDCirrus Design SR20 · S/N 11365N279LDCirrus Design SR22T · S/N 10658N12AUCirrus Design SR22 · S/N 10637N34EDCirrus Design SF50 · S/N 0707N88SNCirrus Design SR22T · S/N 10024N702SRCirrus Design SR22T · S/N 10420N347ASCirrus Design SR22 · S/N 10134N270GCirrus Design SR22 · S/N 10485N264WCirrus Design SR22T · S/N 10741N662BHCirrus Design SF50 · S/N 00X1N958MJCirrus Design SF50 · S/N 00X2N778ZACirrus Design SR22 · S/N 10778N50DYCirrus Design SF50 · S/N 0689N692VJCirrus Design SF50 · S/N 0692N638CVCirrus Design SF50 · S/N 0638N221AVCirrus Design SR20 · S/N 10443N24EUCirrus Design SR22T · S/N 10451N648SKCirrus Design SR22T · S/N 10648N247UKCirrus Design SR22T · S/N 9774N41GHCirrus Design SR22T · S/N 10432N85JHCirrus Design SR22T · S/N 10216N105SACirrus Design SR22 · S/N 10259N221MVCirrus Design SR20 · S/N 9819N315JDCirrus Design SR22T · S/N 9814N28RYCirrus Design SR22T · S/N 10023N587VJCirrus Design SF50 · S/N 0587N565VJCirrus Design SF50 · S/N 0565N70SACirrus Design SR22 · S/N 10207N231JKCirrus Design SR20 · S/N 9544N142MDCirrus Design SR22 · S/N 10127N79RYCirrus Design SR22T · S/N 9808N87GECirrus Design SR22T · S/N 10078N20GHCirrus Design SR22T · S/N 9772N1105NCirrus Design SR22T · S/N 10042N982FGCirrus Design SR22 · S/N 9825N512CACirrus Design SR22 · S/N 9110N221PRCirrus Design SR20 · S/N 9094
Back to Duluth, MN