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.

N359GBCirrus Design SR22T · S/N 2359Cancelled Aug 16, 2021 · Exported to Poland · Cirrus Design CorpN2445GCessna 206H · S/N 20608094Cancelled Aug 6, 2021 · Exported to Canada · Built 2000 · Goldberg David A TrusteeN279CVCirrus Design SF50 · S/N 0279Cancelled Aug 6, 2021 · Exported to South Korea · Cirrus Design CorpN804BECirrus Design SR22T · S/N 2286Cancelled Aug 5, 2021 · Exported to Turkey · Built 2021 · Cirrus Design CorpN506YCirrus Design SR22 · S/N 5061Cancelled Jul 19, 2021 · Exported to Czech Republic · Cirrus Design CorpN361BJCirrus Design SR22T · S/N 2361Cancelled Jul 7, 2021 · Exported to Germany · Cirrus Design CorpN1039HAeronca 15AC · S/N 15AC-42Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1948 · Kwako Lily MN995CWCirrus Design SR20 · S/N 2715Cancelled Jun 30, 2021 · Exported to Germany · Built 2021 · Cirrus Design CorpN317RSCirrus Design SR22T · S/N 2317Cancelled Jun 21, 2021 · Exported to Germany · Cirrus Design CorpN327GRCirrus Design SR22T · S/N 2327Cancelled Jun 17, 2021 · Exported to Germany · Cirrus Design CorpN233DACirrus Design SR22T · S/N 2333Cancelled May 27, 2021 · Exported to Germany · Cirrus Design CorpN318JACirrus Design SR22 · S/N 5018Cancelled May 19, 2021 · Exported to Australia · Built 2021 · Cirrus Design CorpN295WFCirrus Design SR22T · S/N 2295Cancelled May 11, 2021 · Exported to Poland · Cirrus Design CorpN304HKCirrus Design SR22T · S/N 2304Cancelled Apr 29, 2021 · Exported to Germany · Cirrus Design CorpN687RSCirrus Design SR20 · S/N 2687Cancelled Apr 29, 2021 · Exported to Germany · Cirrus Design CorpN666CACirrus Design SR20 · S/N 2669Cancelled Apr 19, 2021 · Exported to Germany · Built 2021 · Cirrus Design CorpN161GSCirrus Design SR22T · S/N 2264Cancelled Mar 15, 2021 · Exported to Germany · Cirrus Design CorpN221ESCirrus Design SR22T · S/N 2272Cancelled Mar 10, 2021 · Exported to Germany · Cirrus Design CorpN226MXCirrus Design SR22 · S/N 5004Cancelled Mar 3, 2021 · Exported to Germany · Cirrus Deisgn CorpN49EMCirrus Design SR20 · S/N 2639Cancelled Feb 5, 2021 · Exported to Czech Republic · Built 2020 · Cirrus Design CorpN222VGCirrus Design SR22 · S/N 4983Cancelled Jan 14, 2021 · Exported to Netherlands · Cirrus Design CorpN357JLCirrus Design SR22T · S/N 2137Cancelled Dec 22, 2020 · Exported to Germany · Built 2020 · Cirrus Design CorpN4723XCessna 150G · S/N 15064773Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1966 · Easterday Donald JustinN102FHCirrus Design SR22T · S/N 2185Cancelled Dec 3, 2020 · Exported to Germany · Cirrus Design CorpN318LKCirrus Design SR22T · S/N 2153Cancelled Oct 28, 2020 · Exported to Germany · Built 2020 · Cirrus Design CorpN244MSCirrus Design SR20 · S/N 2605Cancelled Oct 13, 2020 · Exported to Romania · Cirrus Design CorpN165MMCirrus Design SR22T · S/N 2165Cancelled Oct 9, 2020 · Exported to Germany · Cirrus Design CorpN930GSCirrus Design SR22 · S/N 4930Cancelled Sep 9, 2020 · Exported to Poland · Cirrus Design CorpN318SSCirrus Design SR22T · S/N 2162Cancelled Aug 24, 2020 · Exported to Poland · Built 2020 · Cirrus Design CorpN65GHCirrus Design SR22T · S/N 2048Cancelled Aug 12, 2020 · Exported to Australia · Built 2020 · Cirrus Design CorpN491FRCirrus Design SR22 · S/N 4919Cancelled Jul 27, 2020 · Exported to United Kingdom · Cirrus Design CorpN821MJCirrus Design SR20 · S/N 2578Cancelled Jul 20, 2020 · Exported to Slovak Republic · Cirrus Design CorpN108CZCirrus Design SR22T · S/N 2108Cancelled Jun 3, 2020 · Exported to Czech Republic · Cirrus Design CorpN2478MPiper PA-12 · S/N 12-1555Cancelled Apr 9, 2020 · Revoked, canceled · Built 1947 · Ottel Robert WN488ZLCirrus Design SR22 · S/N 4888Cancelled Mar 6, 2020 · Exported to Poland · Cirrus Design CorpN543DSCirrus Design SR20 · S/N 2528Cancelled Mar 5, 2020 · Exported to United Kingdom · Cirrus Design CorpN833ADCirrus Design SR22 · S/N 4833Cancelled Feb 19, 2020 · Exported to Russia · Built 2019 · Cirrus Design CorpN482CSCirrus Design SR22 · S/N 4827Cancelled Feb 14, 2020 · Exported to Portugal · Built 2019 · Cirrus Design CorpN485SACirrus Design SR22 · S/N 4850Cancelled Feb 6, 2020 · Exported to South Africa · Built 2019 · Cirrus Design CorpN611HBCirrus Design SR22T · S/N 2039Cancelled Jan 28, 2020 · Exported to Germany · Cirrus Design CorpN482DDCirrus Design SR22 · S/N 4828Cancelled Jan 15, 2020 · Exported to South Africa · Built 2019 · Cirrus Design CorpN831ZSCirrus Design SR22 · S/N 4831Cancelled Jan 15, 2020 · Exported to South Africa · Built 2019 · Cirrus Design CorpN203PKCirrus Design SR22T · S/N 2032Cancelled Dec 16, 2019 · Exported to Poland · Cirrus Design CorpN510KUCirrus Design SR20 · S/N 2510Cancelled Dec 9, 2019 · Exported to South Korea · Built 2019 · Cirrus Design CorpN174LPDJI INSPIRE 1 · S/N W13DLE26040538Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Parthe LanceN31956Aeronca 65-TF · S/N 9241TCancelled Nov 29, 2019 · Revoked, canceled · Built 1941 · Martin FranklinN103ABCirrus Design SF50 · S/N 0132Cancelled Nov 25, 2019 · Exported to Poland · Built 2019 · Cirrus Design CorpN481FGCirrus Design SR22 · S/N 4819Cancelled Nov 5, 2019 · Exported to South Africa · Built 2019 · Cirrus Design CorpN644MACirrus Design SF50 · S/N 0149Cancelled Oct 24, 2019 · Exported to Colombia · Cirrus Design CorpN220ALCirrus Design SR22T · S/N 1976Cancelled Oct 22, 2019 · Exported to South Africa · Built 2019 · Cirrus Design Corp
Back to Duluth, MN