OpenAirDocs.org
Iron Mountain, MI

Cancelled registrations · 53

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 = 'IRON MOUNTAIN'
  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.

N69799Consolidated Vultee BT-13A · S/N 11693Cancelled Oct 11, 2019 · Revoked, canceled · Built 1943 · Trudell Rosaire CN51GGRiverside James M SCORPION RW133 · S/N 2671Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Riverside James MN6311ECessna 172 · S/N 46411Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1959 · Steinbrechet Carl JN771MEBetti Michael J MURPHY ELITE · S/N 771ECancelled Jun 5, 2014 · Exported to Canada · Built 2007 · Betti Michael JN22587Cessna 150H · S/N 15068381Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1968N176Culley OSPREY · S/N 176Cancelled Nov 29, 2012 · Sale reported, pending cancellationN42046Piper J3C-65 · S/N 9099Cancelled Jun 12, 2012 · Revoked, canceled · Built 1942 · Richer James EN235BASwearingen SA226TC · S/N TC235Cancelled Oct 10, 2006 · Exported to Canada · Superior Aviation IncN151SASwearingen SA226TC · S/N TC302Cancelled Apr 25, 2006 · Exported to Canada · Superior Aviation IncN162SWSwearingen SA226TC · S/N TC325Cancelled Apr 14, 2006 · Exported to Canada · Built 1979 · Superior Aviation IncN328BASwearingen SA226TC · S/N TC-253Cancelled Mar 22, 2006 · Exported to Canada · Built 1978 · Superior Aviation IncN327BASwearingen SA226TC · S/N TC249Cancelled May 25, 2005 · Exported to Canada · Superior Aviation IncN26SACessna 404 · S/N 404-0225Cancelled Jul 14, 2003 · Triennial form not returned · Superior Aviation IncN36998Cessna 404 · S/N 404-0101Cancelled Jan 28, 1999 · Triennial form not returned · Superior Aviation IncN224AMSwearingen SA226TC · S/N TC227Cancelled Jan 15, 1999 · Triennial form not returned · Superior Aviation IncN441KMCessna 441 · S/N 4410196Cancelled Apr 27, 1995 · Triennial form not returned · Garrett Aviation IncN2663GCessna 402C · S/N 402C0354Cancelled Aug 13, 1992 · Exported to Mozambique · Superior Aviation IncN7880QCessna 310Q · S/N 310Q0657Cancelled Sep 10, 1986 · Garrett Aviation IncN7264TCessna 172A · S/N 46864Cancelled Jan 9, 1978 · Fontana Aviation IncN1775GBeech H-18 · S/N BA-635Cancelled Dec 20, 1977 · Fontana Aviation IncN454HCessna 421A · S/N 421A0155Cancelled Dec 15, 1977 · Built 1969 · Fontana Aviation IncN5396JCessna 421B · S/N 0946Cancelled Dec 15, 1977 · Fontana Aviation IncN73033Cessna 172M · S/N 17267244Cancelled Jan 25, 1977 · Exported to Canada · Fontana Aviation IncN3945QCessna 172L · S/N 172 60045Cancelled Sep 23, 1976 · Exported to Canada · Fontana Aviation IncN4PACessna 414 · S/N 414-0515Cancelled Aug 17, 1976 · Exported to Germany · Built 1974 · Fontana Aviation IncN6800YPiper PA-23-250 (6PCLM) · S/N 27-4137Cancelled Aug 3, 1976 · Exported to Canada · Fontana Aviation IncN9161MCessna 182P · S/N 182 64710Cancelled Jul 7, 1976 · Exported to Canada · Fontana Aviation IncN18830Cessna 320E · S/N 320E0107Cancelled Jun 3, 1976 · Exported to Canada · Built 1967 · Fontana Aviation IncN8101QCessna 414 · S/N 414-0001Cancelled Feb 26, 1976 · Exported to Canada · Fontana Aviation IncN87236Cessna T310R · S/N 310R0313Cancelled Oct 22, 1975 · Exported to Canada · Fontana Aviation IncN30263Cessna 172M · S/N 17264128Cancelled Sep 17, 1975 · Exported to Canada · Fontana Aviation IncN21375Cessna 172M · S/N 17263939Cancelled Apr 2, 1975 · Exported to Canada · Built 1974 · Fontana Aviation IncN72FABeech H-18 · S/N BA-631Cancelled Feb 10, 1975 · Fontana Aviation IncN73FABeech H-18 · S/N BA-649Cancelled Nov 7, 1974 · Fontana Aviation IncN6122FCessna 210H · S/N 21059022Cancelled Jun 27, 1974 · Exported to Canada · Fontana Aviation IncN11598Cessna 150L · S/N 15075554Cancelled Apr 2, 1974 · Exported to Canada · Fontana Aviation IncorporatedN52627Cessna 182P · S/N 18262724Cancelled Feb 27, 1974 · Exported to Canada · Fontana Aviation IncN11296Cessna 150L · S/N 15075306Cancelled Nov 30, 1973 · Exported to Canada · Built 1973 · Fontana Aviation IncN12967Cessna 172M · S/N 17262412Cancelled Nov 30, 1973 · Exported to Canada · Built 1973 · Fontana Aviation IncN70374Cessna A185F · S/N 18502134Cancelled Apr 24, 1973 · Exported to Canada · Built 1973 · Fontana Aviation IncN19961Cessna 172M · S/N 17260890Cancelled Jan 17, 1973 · Exported to Canada · Built 1972 · Fontana Aviation IncN2345ZBeech H-18S · S/N BA626Cancelled Apr 6, 1971 · Built 1963 · Fontana JosephN64504Consolidated Vultee BT-13B (SNV-2) · S/N 79-143Cancelled Feb 2, 1971 · Built 1943 · Trudell Rosaire CharlesN550Howard DGA-15P · S/N 1747Cancelled Sep 23, 1959 · Fontana Aviation IncN48474Fairchild M-62A · S/N 8053AECancelled Nov 21, 1955 · Vanooyen Chester ON43764Taylorcraft BC12-D · S/N 7423Cancelled Oct 10, 1955 · Fontana School Of Aeronautics IncN6018KRepublic RC-3 · S/N 188Cancelled Oct 4, 1955 · D R SmithN5556NGrumman G-21A · S/N B-62Cancelled Jul 27, 1951 · Exported to United Kingdom · Built 1944 · Fontana School Of AeronauticsN26484Meyers OTW · S/N 37Cancelled Jul 28, 1948 · Fontana School Of AeronauticsN18215Heiserman Chas HEISERMAN · S/N 1-434Cancelled Jul 15, 1939 · Charles Heiserman
Back to Iron Mountain, MI