South St Paul, MN

Cancelled registrations · 30

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 = 'SOUTH ST PAUL'
  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.

N12326Dehavilland DHC-6-300 · S/N 273Cancelled Feb 1, 2010 · Exported to Canada · Wipaire IncN208JEDehavilland DHC-6-300 · S/N 557Cancelled Sep 4, 2008 · Exported to Canada · Eriksson Aviation LLCN225WACessna 208 · S/N 20800225Cancelled Oct 2, 2007 · Exported to Italy · Built 1993 · Wipaire IncN604MACessna 208 · S/N 20800031Cancelled Jul 17, 2006 · Exported to Canada · Built 1985 · Wipaire IncN125ARCessna 208B · S/N 208B0925Cancelled Sep 7, 2005 · Exported to Australia · Built 2001 · Schmokel Mark L DBAN107FBAir Tractor AT-802 · S/N 802-0176Cancelled Jun 23, 2005 · Exported to Spain · Wipaire IncN94MSCessna 208 · S/N 20800298Cancelled Dec 9, 2004 · Exported to Australia · Schmokel Mark L DBAN633KBeech 95-C55 · S/N TE-198Cancelled Aug 10, 2004 · Triennial form not returned · Built 1966 · Schmokel Mark L DBAN839Eberspacher Warren A HAC MODEL A-001 · S/N 1Cancelled Jun 27, 2000 · Second triennial mailing, no response · Eberspacher Warren AN94901Taylorcraft BC12-D · S/N 9301Cancelled Nov 30, 1976 · Exported to Canada · Brommer Roger AN60064Cessna 150J · S/N 15070047Cancelled Aug 2, 1974 · Walston Aviation Of St Paul IncN562GCessna 150H · S/N 15068274Cancelled Apr 23, 1974 · Twin City Mile High Flying Club IncN96187Taylorcraft BC12-D · S/N 8487Cancelled Jun 21, 1973 · Exported to Canada · Miller Vernon JN5697TCessna 172E · S/N 17251597Cancelled Dec 17, 1971 · Exported to Canada · John P KelleyN117LCessna A185E · S/N 18501850Cancelled Jun 8, 1971 · Exported to Canada · Wiplinger B AN6814DConsolidated Vultee P4Y-2 · S/N 59913Cancelled Feb 2, 1971 · Lysdale Flying ServiceN4218ZPiper PA-18-150 · S/N 18-8440Cancelled Jan 20, 1971 · Exported to Canada · Graham Aviation CompanyN3511VCessna 140 · S/N 14780Cancelled Jan 15, 1971 · Lysdale Flying ServiceN6815DConsolidated Vultee P4Y-2 · S/N 59946Cancelled Oct 26, 1970 · Exported to Mexico · Lysdale Flying ServiceN2784JCessna 185E · S/N 185-1534Cancelled Jul 8, 1969 · Exported to Canada · Walston Aviation Of St Paul IncN9598SChampion 7ECA · S/N 7ECA295Cancelled Feb 3, 1966 · Exported to Canada · Aero SalesN5845TCessna 185C · S/N 185-0745Cancelled Nov 10, 1964 · Exported to Canada · Lysdale Flying ServiceN4640UCessna 180G · S/N 108-51340Cancelled Jun 29, 1964 · Exported to Canada · Fleming Airways IncN5105UCessna 206 · S/N 206-0105Cancelled Mar 26, 1964 · Exported to Canada · Built 1963 · Walston Aviation Of St Paul IncN3013NCessna 140 · S/N 13271Cancelled Aug 9, 1963 · Exported to Canada · Lysdale Flying ServiceN9262TCessna 180C · S/N 50762Cancelled Nov 14, 1960 · Exported to Canada · Aviationrental ServiceN23152Piper J3C-65 · S/N 2936Cancelled Nov 7, 1960 · Exported to Canada · Wiplinger B AN69635Consolidated Vultee BT-13B · S/N 79-1246Cancelled Feb 20, 1956 · Lysdale Flying ServiceN4726BCessna 180 · S/N 31624Cancelled Sep 14, 1955 · Exported to Canada · Wiplinger B AN9585ACessna 170A · S/N 19398Cancelled Mar 7, 1951 · Lysdale Flying Service
Back to South St Paul, MN