OpenAirDocs.org
Lansing, MI

Cancelled registrations · 120

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 = 'LANSING'
  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.

N97356Stinson 108 · S/N 108-356Cancelled Feb 16, 1983 · Administratively canceled · Christian Allen P IIIN43861Douglas C-47D · S/N 4476933Cancelled Nov 5, 1982 · Lansing Community College (Lor)N12NRBell 47G-2 · S/N 2084Cancelled Apr 11, 1981 · Administratively canceled · Michigan Dept Natural ResourcesN19NRDehavilland BEAVER U-6A · S/N 26101Cancelled Mar 13, 1981 · Built 1967 · Michigan Department Of Natural ResourcesN2701CCessna R182 · S/N R18200220Cancelled Feb 28, 1980 · Exported to Canada · Built 1978 · General Aviation IncN2713PPiper PA-22-150 · S/N 22-3019Cancelled Nov 3, 1977 · Franchimo Mold CoN141XBeech D18S · S/N A-993Cancelled Jul 15, 1977 · Abrams Aerial Survey CorpN2438APiper PA-20-135 · S/N 20-932Cancelled Mar 17, 1976 · Exported to Canada · Leavitt Scott AN1248VConsolidated Vultee BT-13A · S/N 11733Cancelled Jul 29, 1975 · Sale reported · Built 1943N488CSpringborg W Gordon LITTLE WASP · S/N S-1001Cancelled May 8, 1975 · Springborg W GordonN1476Dehavilland BEAVER U-6A · S/N 52-6080Cancelled Feb 7, 1975 · Built 1952 · US Dept Of The Air ForceN6505XCessna 210 · S/N 57505Cancelled Jan 22, 1975 · Exported to Canada · Francis Gerald A & Brock Robert MN6890GCessna 150L · S/N 15072390Cancelled Jan 22, 1975 · Exported to Canada · Wheeler William JN8048RBeech A24R · S/N MC-41Cancelled Apr 12, 1974 · General Aviation IncN6444MBeech C-45H · S/N AF-518Cancelled Jan 21, 1974 · Michigan Aeronautics CommissionN8783Douglas C-47D · S/N 43-48790Cancelled Nov 2, 1972 · Far East Investment IncN8063RBeech C23 · S/N M-1310Cancelled Aug 15, 1972 · General Aviation IncN431Beech 35 · S/N D-2898Cancelled Apr 29, 1972 · Francis Gerald CN17TBeech E18S · S/N BA-137Cancelled Jan 21, 1972 · Francis AviationN9046DPiper PA-22-160 · S/N 22-6185Cancelled Dec 16, 1971 · Carter Clarence BN10NRBell 47G-2 · S/N 2525Cancelled Oct 5, 1971 · Michigan Department Of Natural ResourcesN95242Taylorcraft BC12-D · S/N 9642Cancelled Mar 1, 1971 · Gerald C FrancisN85960Aeronca 11AC · S/N 11AC-378Cancelled Jan 18, 1971 · Built 1946 · Dean & Harris IncN19142Fairchild 24 G · S/N 2990Cancelled Aug 4, 1970 · George G StricklandN341XBeech AT-11 · S/N 1406Cancelled Jul 9, 1970 · Abrams Aerial Survey CorporationN193MMeyers Industries 200C · S/N 284Cancelled Jun 30, 1970 · Michigan Dept Of ConservationN9762BCessna 180 · S/N 50060Cancelled Jun 30, 1970 · Department Of ConservationN366BBeech E50 · S/N EH-27Cancelled Nov 25, 1969 · Francis AviationN5244ACessna 310 · S/N 35444Cancelled May 12, 1969 · Exported to Canada · Hughes Harvey MN7416YPiper PA-30 · S/N 30-479Cancelled Apr 6, 1967 · Exported to Canada · Landy Taylor & Associates IncN8423PPiper PA-24-400 · S/N 26-13Cancelled Jan 10, 1966 · Commercial Credit Equipment CorpN79510Fairchild M-62C(PT-23A) · S/N H0-363Cancelled May 22, 1965 · Francis Gerald CN27586Taylorcraft BL-65 · S/N 2227Cancelled Feb 2, 1960 · Gerald FrancisN2701CCessna 170B · S/N 26245Cancelled Jan 12, 1960 · Harvey M Hughes DBA Hughes Flying ServiceN33816Aeronca 65-TL · S/N L9561TCancelled Feb 20, 1956 · Built 1941 · Monroe David RN1329EAeronca 7AC · S/N 7AC-4890Cancelled Nov 18, 1955 · Aero Manor IncN76855Cessna 140 · S/N 11289Cancelled Oct 12, 1955 · Nelson Keith DN47089Aeronca 0-58B · S/N 058B11343Cancelled Oct 10, 1955 · Bordes Victor D & Russell A SwatmanN9065EAeronca 11AC · S/N 11AC-696Cancelled Oct 6, 1955 · Built 1946 · Boylan Ray MN1421KLuscombe 8A · S/N 4148Cancelled Oct 4, 1955 · Wiechert Alfreda MaxineN50368Cessna T-50 · S/N 5986Cancelled Dec 28, 1954 · Roe E ON2079DBeech D35 · S/N D-3430Cancelled Jun 17, 1954 · Sigler KimN92908Commonwealth 185 · S/N 1639Cancelled Jul 29, 1953 · Lavigne Fred LN77631Fairchild 24W-46 · S/N W46331Cancelled Sep 14, 1950 · Frank GreenN9837HFairchild M-62C(PT-23A) · S/N FE9Cancelled Nov 15, 1949 · Built 1942 · Francis Gerald CN9827HFairchild M-62C(PT-23A) · S/N HO-322Cancelled May 29, 1949 · Built 1943 · Francis Gerald CN5021MTaylorcraft BC12-D · S/N 10321Cancelled Apr 5, 1949 · Built 1946 · Aero Manor IncN14634Aeronca C-3 · S/N A-520Cancelled Jul 27, 1948 · White LyleN1784EAeronca 7AC · S/N 7AC-5351Cancelled Jul 9, 1948 · Built 1946 · Hebert Aviation Co/ Hebert Arthur J/ Hebert AnnaN15482Rearwin 7000 · S/N 430Cancelled Apr 26, 1948 · Built 1935 · Capitol City Flying Club
Back to Lansing, MI