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.

N2096Cirrus Design SR20 · S/N 8571Cancelled Jan 20, 2023 · Exported to Netherlands · Built 2022 · Cirrus Design CorpN221TNCirrus Design SR22T · S/N 8504Cancelled Jan 20, 2023 · Exported to Switzerland · Built 2022 · Cirrus Design CorpN871LBCirrus Design SR22T · S/N 8822Cancelled Jan 19, 2023 · Exported to Canada · Cirrus Design CorpN238TSCirrus Design SR22 · S/N 8931Cancelled Dec 28, 2022 · Exported to Switzerland · Cirrus Design CorpN839JBCirrus Design SR22T · S/N 8839Cancelled Dec 16, 2022 · Exported to South Africa · Cirrus Design CorpN895WPCirrus Design SR22T · S/N 8895Cancelled Dec 16, 2022 · Exported to South Africa · Cirrus Design CorpN818DMCirrus Design SR22 · S/N 8908Cancelled Dec 12, 2022 · Exported to Sweden · Cirrus Design CorpN141CACirrus Design SR22T · S/N 8911Cancelled Dec 6, 2022 · Exported to Canada · Cirrus Design CorpN199FCirrus Design SR22T · S/N 8679Cancelled Dec 6, 2022 · Exported to Canada · Built 2022 · Cirrus Design CorpN874CZCirrus Design SR22 · S/N 8874Cancelled Dec 6, 2022 · Exported to Czech Republic · Cirrus Design CorpN890DECirrus Design SR22T · S/N 8890Cancelled Nov 22, 2022 · Exported to Germany · Cirrus Design CorpN381JSCirrus Design SR20 · S/N 8650Cancelled Nov 7, 2022 · Exported to Australia · Built 2022 · Cirrus Design CorpN132JSCirrus Design SR20 · S/N 8734Cancelled Oct 27, 2022 · Exported to Brazil · Built 2022 · Cirrus Design CorpN65GHCirrus Design SR22T · S/N 8675Cancelled Oct 24, 2022 · Exported to Australia · Built 2022 · Cirrus Design CorpN789MKCirrus Design SR22T · S/N 8789Cancelled Oct 13, 2022 · Exported to Austria · Cirrus Design CorpN811CZCirrus Design SR20 · S/N 8811Cancelled Oct 13, 2022 · Exported to Czech Republic · Cirrus Design CorpN279LPRobinson Helicopter R22 BETA · S/N 2968Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Parthe Productions IncN865BWCirrus Design SR22T · S/N 8787Cancelled Sep 29, 2022 · Exported to Poland · Cirrrus Design CorpN210MLCirrus Design SR20 · S/N 8709Cancelled Sep 9, 2022 · Exported to Germany · Cirrus Design CorpN708TNCirrus Design SR22T · S/N 8708Cancelled Sep 9, 2022 · Exported to United Kingdom · Cirrus Design CorpN909PPCirrus Design SR22T · S/N 8730Cancelled Aug 30, 2022 · Exported to Switzerland · Cirrus Design CorpN135JPCirrus Design SR22 · S/N 8611Cancelled Aug 10, 2022 · Exported to Japan · Built 2022 · Cirrus Design CorpN695CZCirrus Design SR20 · S/N 8695Cancelled Jul 28, 2022 · Exported to Slovak Republic · Cirrus Design CorpN661SUCirrus Design SR22 · S/N 8661Cancelled Jul 8, 2022 · Exported to Denmark · Cirrus Design CorpN871LBCirrus Design SR22T · S/N 8715Cancelled Jul 5, 2022 · Exported to Canada · Cirrus Design CorpN259KACirrus Design SR20 · S/N 8652Cancelled Jun 29, 2022 · Exported to Germany · Built 2022 · Cirrus Design CorpN385LMCirrus Design SR22T · S/N 8636Cancelled Jun 14, 2022 · Exported to Germany · Cirrus Design CorpN281JRCirrus Design SR20 · S/N 8580Cancelled Jun 1, 2022 · Exported to Germany · Cirrus Design CorpN581AWCirrus Design SR22T · S/N 8581Cancelled May 24, 2022 · Exported to South Africa · Cirrus Design CorpN861FGCirrus Design SR22 · S/N 8613Cancelled May 24, 2022 · Exported to South Africa · Cirrus Design CorpN351CVCirrus Design SF50 · S/N 0351Cancelled May 20, 2022 · Exported to Poland · Cirrus Design CorpN395SYCirrus Design SR22T · S/N 8599Cancelled Mar 30, 2022 · Exported to Canada · Cirrus Design CorpN209ZCirrus Design SR22T · S/N 8627Cancelled Mar 18, 2022 · Exported to Guatemala · Cirrus Design CorpN1782KCirrus Design SR22 · S/N 5120Cancelled Mar 15, 2022 · Exported to Czech Republic · Built 2021 · Cirrus Design CorpN22UMCirrus Design SR22 · S/N 5006Cancelled Mar 7, 2022 · Exported to South Africa · Built 2021 · Cirrus Design CorpN501UACirrus Design SF50 · S/N 0357Cancelled Mar 1, 2022 · Exported to San Marino · Cirrus Design CorpN865GNCirrus Design SR22 · S/N 5060Cancelled Feb 15, 2022 · Exported to Czech Republic · Cirrus Design CorpN317BWCirrus Design SF50 · S/N 0317Cancelled Feb 14, 2022 · Exported to Poland · Cirrus Design CorpN455HUCirrus Design SR22T · S/N 2455Cancelled Dec 28, 2021 · Exported to Czech Republic · Cirrus Design CorpN375MSCirrus Design SR22T · S/N 2431Cancelled Dec 14, 2021 · Exported to Malta · Cirrus Design CorpN510SKCirrus Design SR22 · S/N 5102Cancelled Dec 13, 2021 · Exported to Slovak Republic · Cirrus Design CorpN318RSCirrus Design SR22T · S/N 2427Cancelled Dec 7, 2021 · Exported to Germany · Cirrus Design CorpN432RKCirrus Design SR22T · S/N 2432Cancelled Dec 6, 2021 · Exported to Czech Republic · Cirrus Design CorpN238MSCirrus Design SR22T · S/N 2384Cancelled Dec 2, 2021 · Exported to Romania · Built 2021 · Cirrus Design CorpN302CVCirrus Design SF50 · S/N 0302Cancelled Nov 30, 2021 · Exported to Brazil · Cirrus Design CorpN315DKCirrus Design SR22T · S/N 2417Cancelled Nov 10, 2021 · Exported to Denmark · Cirrus Design CorpN134MYCirrus Design SR22 · S/N 4692Cancelled Nov 4, 2021 · Exported to India · Built 2018 · Cirrus Design CorpN505TBCirrus Design SR22 · S/N 5082Cancelled Oct 1, 2021 · Exported to Germany · Cirrus Design CorpN373WWCirrus Design SR22T · S/N 2373Cancelled Sep 23, 2021 · Exported to Poland · Cirrus Design CorpN377RHCirrus Design SR22T · S/N 2377Cancelled Sep 17, 2021 · Exported to Germany · Cirrus Design Corp
Back to Duluth, MN