OpenAirDocs.org
Sturgis, MI

Cancelled registrations · 41

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 = 'MI' AND d.registrant_city = 'STURGIS'
  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.

N826JCPhantom X-1 · S/N 88-9110Cancelled Dec 24, 2022 · Built 1988 · Finch Jerry CN365RATears R C RAPTOR · S/N 9801M14PCancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1998 · Missionary AeroplanesincN319NFoshee Phillip D MARANDA · S/N 002Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 2009 · Missionary Aeroplanes IncN1803HCessna 310C · S/N 35903Cancelled Mar 23, 2018 · Revoked, canceled · Built 1959 · Huedig ArminN502EPInfinity Power Parachutes C-582 · S/N IPP14-419Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Infinity Power Parachutes LLCN502GPInfinity Power Parachutes C-582 · S/N IPP14-418Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Infinity Power Parachutes LLCN467KPInfinity Power Parachutes COMMANDER 110 · S/N IPP12-403Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 2012 · Infinity Power Parachutes LLCN46432Infinity Power Parachutes INFINITY 2005 · S/N IPP5-302Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2005 · Infinity Power Parachutes LLCN3937VInfinity Power Parachutes CLASSIC 2003 · S/N IPP3-166Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2007 · Infinity Power Parachtues LLCN26093Piper PA-38-112 · S/N 38-81A0115Cancelled Dec 26, 2017 · Built 1981 · Bartelt Aviation IncN611TXEvolution Trikes REVO · S/N 000554Cancelled Jan 27, 2012 · Built 2010 · Geigley Galen EN6560CCessna 414A · S/N 414A0013Cancelled Mar 25, 2010 · Triennial form not returned · Built 1977 · Mid Continent Aire LtdN9327UCessna 150M · S/N 15078276Cancelled May 16, 2006 · Triennial form not returned · Built 1976 · Conrad John RN8082FCessna 150F · S/N 15064182Cancelled May 15, 2006 · Triennial form not returned · Built 1966 · Conrad John RN132MSMooney M20J · S/N 24-3411Cancelled May 1, 2006 · Exported to Belgium · Built 1997 · Bartelt Aviation IncN4988JPiper PA-28R-180 · S/N 28R-30743Cancelled Jan 16, 2003 · Triennial form not returned · Built 1968 · Conrad JohnN433FMMooney M20J · S/N 24-3419Cancelled Sep 27, 2002 · Exported to Italy · Built 1998 · Bartelt Aviation IncN8052ZCessna U206A · S/N U206-0452Cancelled Jul 16, 2002 · Exported to Guatemala · Built 1965 · Bartelt Aviation IncN371JDCessna 402B · S/N 402B1322Cancelled Jul 2, 2002 · Built 1978 · Riley Aviation IncN27FNPiper PA-44-180 · S/N 44-7995110Cancelled Nov 7, 2001 · Exported to Canada · Built 1979 · Flying N IncN648CACessna 152 · S/N 15281455Cancelled Aug 14, 1998 · Exported to Belgium · Bartelt Aviation IncN733GACessna 172N · S/N 17268274Cancelled Jul 11, 1996 · Exported to Belgium · Bartelt Aviation IncN1660UCessna T210N · S/N 21064719Cancelled Feb 28, 1995 · Exported to Mexico · Bartelt Aviation IncN8202HPiper PA-32RT-301T · S/N 32R8229048Cancelled Aug 11, 1993 · Exported to Germany · Bartelt Aviation IncN5124PCessna 152 · S/N 15284883Cancelled Jul 7, 1993 · Exported to Belgium · Bartelt Aviation IncN68927Cessna 152 · S/N 15282406Cancelled Jul 1, 1993 · Exported to Belgium · Bartelt Aviation IncN4375GCessna TU206G · S/N U20605455Cancelled May 13, 1992 · Exported to Belgium · Bartelt Aviation IncN8095RPiper PA-32RT-301T · S/N 32R8229031Cancelled Feb 19, 1991 · Exported to Germany · Bartelt Aviation IncN42989Piper PA-32R-301T · S/N 32R8329022Cancelled Jan 2, 1991 · Exported to Belgium · Bartelt Aviation IncN4798DCessna 182A · S/N 34898Cancelled Jun 14, 1979 · Exported to Canada · Swihart Stewart DN7065RPiper PA-28-140 · S/N 28-21765Cancelled Aug 7, 1975 · St Joseph Valley Flying Club IncN2432GCessna 182B · S/N 51732Cancelled Dec 3, 1971 · Michiana Motors IncN1235CPiper PA-22-135 · S/N 22-1038Cancelled Aug 19, 1971 · Kline Larry & Cripe AnselN18755Arrow F · S/N 96Cancelled Jul 15, 1971 · Built 1937 · Banks DonaldN1771JPiper PA-28-140 · S/N 28-24193Cancelled Mar 23, 1971 · Sturgis Airways IncN33430Piper J4A · S/N 4-1368Cancelled Feb 20, 1956 · Built 1940 · Emerson Donald DN4177NCessna 120 · S/N 13648Cancelled Oct 6, 1955 · Built 1947 · Studeman EddN999BDouglas DC3C · S/N 4255Cancelled Oct 3, 1955 · Built 1942 · Castleton Inc-Kentucky CorpN81450Aeronca 7AC · S/N 7AC-68Cancelled Sep 23, 1955 · Built 1945 · Leroques Flying Service IncN48173Fairchild M-62A · S/N 5913AECancelled Dec 28, 1954 · Richmond Eugene FN16534Aeronca LB · S/N 2039Cancelled Feb 16, 1950 · Built 1936 · Baker Owen O
Back to Sturgis, MI