Kalamazoo Aviation History Museum

Earlier aircraft under this name · 25

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'KALAMAZOO AVIATION HISTORY MUSEUM' OR list_contains(d.other_registrant_names, 'KALAMAZOO AVIATION HISTORY MUSEUM')
  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.

N8419Ford 5-AT-C · S/N 58Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1929 · Portage, MIN90729Grumman-Pryor F9F-2 · S/N 12078Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Portage, MIN2954Grumman G-73 · S/N J-14Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1947 · Portage, MIN333SUNorth American SNJ-5 · S/N 91005Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1958 · Portage, MIN2LFFoerster Leroy H AVID FLYER · S/N 740Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1993 · Portage, MIN8HHHaigh STEVENS · S/N 12Cancelled Sep 27, 2017 · Registration expired, pending cancellation · Built 1977 · Portage, MIN90553Wolf Donald S WOLF W-11 · S/N 1Cancelled Sep 27, 2017 · Registration expired, pending cancellation · Built 1979 · Portage, MIN90830Douglas DC3C · S/N 13050Cancelled Sep 27, 2017 · Registration expired, pending cancellation · Built 1943 · Portage, MIN3PPGoodyear FG1D · S/N 92509Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1941 · Portage, MIN37LNorth American B-25H · S/N 43-4899Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1952 · Portage, MIN444SURepublic P-47D · S/N 39955720Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1944 · Portage, MIN52020Fairchild M-62C(PT-23A) · S/N 291HOCancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1943 · Portage, MIN4307LBrunette Leonard Anthony ROTORWAY INTL EXEC90 · S/N 81360Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1991 · Portage, MIN92034Douglas AD-4N · S/N 127888Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1952 · Portage, MIN40ABell P39 · S/N 44-3908Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1944 · Portage, MIN100JENorth American NOMAD NA-260 · S/N 51-7700NCancelled May 4, 2015 · Registration expired, pending cancellation · Built 1961 · Portage, MIN222SUSanders-Parish CURTISS P-40N · S/N 44-7619Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1944 · Portage, MIN76GEMesserschmitt ME 109 C4K · S/N 171Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1944 · Portage, MIN20627Fairchild 24 K · S/N 3309Cancelled Oct 17, 2014 · Registration expired, pending cancellation · Built 1958 · Portage, MIN31948Aeronca 65-CA · S/N C12231Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1941 · Portage, MIN1PPGrumman FM-2 · S/N 86581Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1945 · Portage, MIN5481LRyan Aeronautical ST3KR · S/N 1861Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Portage, MIN101LKKesterke Lawrence CH250 · S/N 736Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Portage, MIN84YFrancis-Angell A-15-SPECIAL · S/N 1Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1947 · Portage, MIN644YWaco INF · S/N 3382Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1930 · Portage, MI
Back to Kalamazoo Aviation History Museum