Kalamazoo, MI

Cancelled registrations · 134

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

N1925LBeech B19 · S/N MB-795Cancelled Jun 8, 2004 · Triennial form not returned · Built 1976 · Nitsch Steven MN4090YBoven Larry D MINI 500 · S/N 0378Cancelled Apr 1, 2004 · Triennial form not returned · Boven Larry DN6256ACessna 182 · S/N 33056Cancelled May 19, 2003 · Exported to Canada · Built 1956 · Rhoades David JN1183MLutke Michael T ROTOWAY EXEC 90 · S/N J123151Cancelled Mar 24, 2003 · Triennial form not returned · Built 1993 · Lutke Michael TN7323LEagle Balloons C-7 · S/N E85785Cancelled Aug 11, 2000 · Triennial form not returned · Eagle Soar IncN52830Cessna 182P · S/N 18262880Cancelled Feb 5, 1997 · Triennial form not returned · Eagle Air IncN35549Cessna 172I · S/N 17256827Cancelled Feb 14, 1994 · Eagle Air IncN27283Fairchild SA227-AC · S/N AC729Cancelled Sep 16, 1992 · Exported to Argentina · Marion Recovery IncN8436APiper PA-28-161 · S/N 288116317Cancelled Mar 20, 1992 · Exported to FranceN12QQFroelich Del QUICKIE-I · S/N 296Cancelled Jan 22, 1985N2345JBeech 23 · S/N M-300Cancelled Mar 2, 1983 · Kalaire Flying ClubN4053PRaven S55A · S/N S55A-858Cancelled Sep 23, 1982 · Kazoo DriftersN2287MPiper PA-28-161 · S/N 28-7816272Cancelled May 13, 1981 · Exported to Iceland · Built 1977 · Bartelt Aviation IncN377WBCessna T310Q · S/N 310Q0954Cancelled Apr 20, 1981 · Jonathan Airways IncN4446Dehavilland TIGER MOTH DH 82A · S/N 29552Cancelled Feb 13, 1981 · Exported to Canada · Bright John PN5494BCessna 182 · S/N 33494Cancelled Jul 11, 1980 · Exported to Canada · Dillon Bruce AN27837Piper PA-31-325 · S/N 31-7912011Cancelled Apr 27, 1979 · Exported to Canada · Built 1978 · Bartelt Aviation IncN704NECessna 150M · S/N 150 78736Cancelled Jan 30, 1979 · Exported to Canada · Kal-Aero IncN2369APiper PA-38-112 · S/N 3878A0658Cancelled Sep 29, 1978 · Exported to Canada · Bartelt Aviation IncN6648MCessna 182P · S/N 18263789Cancelled Oct 12, 1977 · Exported to Canada · Woody Bartelt Aircraft Sales IncN2244SAero Commander 560-F · S/N 560F-1043-15Cancelled Sep 22, 1976 · Stryker CorpN1992MCessna 182P · S/N 18264521Cancelled Jun 11, 1976 · Exported to Australia · Kal Aero IncN6726HCessna 172M · S/N 17265557Cancelled Aug 18, 1975 · Exported to Canada · Kal Aero IncN97483Beech UC-45J · S/N 29629Cancelled Jun 11, 1975 · Built 1971 · Western Michigan UniversityN98119Beech RC-45J · S/N 39217Cancelled Jun 11, 1975 · Western Michigan University CorpN73541Hiller H-23D · S/N 57-3036Cancelled Jun 10, 1975 · Department Of Transportation TechnologyN93215Martin RB57A · S/N 52-1485Cancelled May 5, 1975 · Built 1971 · Western Michigan UniversityN7286NCessna 182P · S/N 182-63073Cancelled Mar 3, 1975 · Exported to Bolivia · Kal-Aero IncN5218WPiper PA-28-150 · S/N 28255Cancelled Jul 24, 1974 · Nichols Russel L & Ketchbaw Roscoe MN69776Cessna 310Q · S/N 310Q0971Cancelled Apr 26, 1974 · Exported to Canada · Kal-Aero IncN55479Consolidated Vultee BT-13A · S/N 6424Cancelled Oct 18, 1973 · Mcnamara Motor Express IncN2427QCessna 182K · S/N 18257627Cancelled May 25, 1973 · Exported to Canada · Kal-Aero IncN2049ZCessna 150C · S/N 15059849Cancelled Apr 16, 1973 · Exported to Canada · Kal-Aero IncN7824ZCessna 150C · S/N 15059924Cancelled Apr 16, 1973 · Exported to Canada · Kal Aero IncN4975FCessna U206B · S/N U206-0675Cancelled Mar 21, 1972 · Exported to Canada · Kal Aero IncN2230EAeronca 7AC · S/N 7AC-5804Cancelled Dec 10, 1971 · Exported to Canada · Built 1946 · Hobaugh William GN5006Republic F-84F · S/N 51-9501Cancelled Nov 19, 1971 · Western Michigan UniversityN5046Republic F-84F · S/N 52-6486Cancelled Nov 19, 1971 · Western Michigan University/Transportation TechN7071XCessna 150A · S/N 15059171Cancelled Sep 23, 1971 · Bullard DuaneN1040ZLockheed T-33A · S/N 53-5219Cancelled Jan 18, 1971 · Westerm Michigan UnivN41908Luscombe 8C · S/N 1869Cancelled Jan 12, 1971 · Built 1941 · Meyers EltonN27680Taylorcraft BL-65 · S/N 2322Cancelled Dec 8, 1970 · Sinke EngleN30057Sikorsky UH-19C · S/N 14306Cancelled Oct 16, 1970 · Western Michigan UniversityN99245Engineering & Research ERCOUPE 415-C · S/N 1868Cancelled Oct 8, 1970 · Exported to Canada · Gary L ScottN3351Grumman F8F-1 · S/N 90454Cancelled Jun 4, 1969 · Balz G WN2813ACessna 180 · S/N 30013Cancelled Apr 29, 1968 · Exported to Canada · Sherman Ronald DBA Sherman Aircraft SalesN4406EAeronca 11CC · S/N 11CC-229Cancelled Dec 10, 1965 · Exported to Canada · Built 1948 · Dillon Bruce AN96654Taylorcraft BC12-D · S/N 8954Cancelled Aug 23, 1965 · Exported to Canada · Baden CorneliusN6027MStinson 108-3 · S/N 108-4027Cancelled Dec 10, 1964 · Exported to Canada · Sherman Ronald DBA Sherman Aircraft SalesN76276Cessna 140 · S/N 10684Cancelled Dec 9, 1964 · Paper City Aero Club
Back to Kalamazoo, MI