OpenAirDocs.org
Saginaw, MI

Cancelled registrations · 64

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

N3564YCessna 182F · S/N 18254464Cancelled Jan 30, 2024 · Revoked, canceled · Built 1962 · Jackpine Aviation IncN271CRCessna 414 · S/N 414-0964Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Bommarito Aircraft IncN6544BGyrotech HONEY BEE · S/N HB0001Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Ostrander Jimmie LN716UBDJI PHANTOM 2 VISION + · S/N PH645384194V2.0Cancelled Sep 3, 2019 · Registration expired, pending cancellation · Bublitz Gary CN4VBVon Berg Richard DAPHNE SD-1A · S/N 20BCancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 2010 · Von Berg Richard MN268MTMerrill Aviation & Defense TORRENT PH2 · S/N MPCT03Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 2013 · Merrill Aviation And DefenseN168MTMerrill Aviation & Defense TORRENT PH2 · S/N MPCT02Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Merrill Aviation And DefenseN1041ZJohnson-Whittman Tailwind JW9L · S/N 1Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 2005 · Von Berg Richard MN6157HCameron Balloons US C-80 · S/N 6016Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1995 · Shreve Maureen FN3469AOstrander Jimmie Lee MINI 500 B · S/N 0454Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Ostrander JimmieN6398NNielsen N Robert NIELSEN RTWY EX 162F · S/N 6335Cancelled Oct 23, 2017 · Registration expired, pending cancellation · Built 1999 · Blair H JosephN1253KQuicksilver SPRINT · S/N KJK003Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Paquette Gary AN9389RBuckeye DREAM MACHINE · S/N 5060Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 2000 · Brady John MichaelN411DLPiper PA-31T · S/N 31T7720057Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1977 · Burt Aviation & Transportation LLCN2837RPiper PA-28R-200 · S/N 28R-35303Cancelled Sep 28, 2015 · Built 1969 · Nightingale Charles HN125DRPiper PA-23-250 · S/N 27-3429Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1966 · Kenny Patrick MN54620Cessna U206F · S/N U20601708Cancelled Jan 16, 2015 · Exported to Zimbabwe · Weyand James DrN3835RCessna 172H · S/N 17255335Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1966 · Hall Vickie CN5518QMooney M20E · S/N 612Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1965 · Simmons KyokoN5622QMooney M20E · S/N 837Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1965 · Hendrick Kelly WN9463APorlas-Ralph BENSEN · S/N 6776Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1978N40548Piper PA-23-250 · S/N 27-7405286Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1973 · Hoffman Flying Service IncN171RKHaughton Larry M LMH EXEC 90 · S/N 6025 LHCancelled Aug 15, 2011 · First renewal notice · Built 1998 · Haughton Larry MN30300Piper J5A · S/N 5173Cancelled Oct 19, 2009 · Registration revoked · Built 1940 · Campbell Rolland V JrN50701Cessna 150J · S/N 15069494Cancelled Jul 23, 2008 · Exported to Canada · Built 1968 · Adams Thomas GN2334ZBeech 23 · S/N M-43Cancelled Feb 3, 2006 · Triennial form not returned · Built 1962 · Musketeer Flying ClubN5827RHunn Duane N SR BENSEN B-8M · S/N 365-42Cancelled Jun 13, 2003 · Triennial form undeliverable · Hunn Duane N SrN84546Aeronca 7AC · S/N 7AC-3242Cancelled Jan 8, 2003 · Triennial form not returned · Built 1946 · Hall Frank KN1029ZParthe Mark B-8M · S/N RV42654Cancelled Oct 28, 2002 · Second triennial mailing, no response · Built 1985 · Parthe Mark EN944PGPinnell Gregory A PHOENIX · S/N 610Cancelled Mar 2, 2001 · Triennial form not returned · Pinnell Gregory AN6913Harden-Clyde BUSHBY MUSTANG II · S/N 7990764Cancelled Aug 24, 1998 · Triennial form not returned · Harden Clyde RN654DHHunn Duane N SR PT-5 · S/N 365428438Cancelled Apr 5, 1993 · Second triennial mailing, no response · Hunn Duane N SrN9374YBeech G18S · S/N BA565Cancelled May 10, 1991 · Exported to Canada · Hoffman Flying Service IncN3776TPiper PA-28R-180 · S/N 28R-30088Cancelled Feb 28, 1984 · Seeley E WardN4VBVon Berg Richard VB-4 · S/N 01Cancelled May 5, 1983 · Triennial form not returned · Von Berg Richard MN2413FPiper PA-38-112 · S/N 38-79A0429Cancelled Oct 4, 1982 · Built 1979 · Hoffman Flying Service IncN6171USmith Sport Aire M - 1 · S/N M-102Cancelled Sep 11, 1980 · Von Berg Richard MN2227APiper PA-22-135 · S/N 22-625Cancelled Oct 28, 1977 · Nestell Elmer FN4192JPiper PA-28-140 · S/N 28-22533Cancelled Feb 19, 1976 · Exported to Canada · Built 1966 · Frank Albert EN72880Cessna 120 · S/N 10074Cancelled Oct 6, 1975 · Bouchey Robert MN2379Smith BENSEN B8M · S/N S-1Cancelled Sep 26, 1975 · Thompson Robert CN1294DCessna 170A · S/N 19870Cancelled Aug 18, 1971 · Brown Robert EN42632Cessna 182L · S/N 18259116Cancelled Apr 22, 1971 · 140 Club IncN6194KRepublic RC-3 · S/N 385Cancelled Mar 11, 1971 · Delta Aviation IncN5844ECessna 150 · S/N 17344Cancelled Jun 23, 1970 · Selley Aircraft ServiceN33823Aeronca 65-CA · S/N CA13651Cancelled Jun 22, 1970 · Davis Orville IN78464Piper PA-12 · S/N 12-1975Cancelled Apr 13, 1964 · Exported to Canada · Built 1955 · Seeley E WardN2557KLuscombe 8E · S/N 5284Cancelled Jul 27, 1961 · Exported to Canada · Built 1947 · Morrison CharlesN4419APiper PA-22-150 · S/N 22-3748Cancelled May 7, 1957 · Macmeekin James WN5659NFairchild PT-23 · S/N 122-SLCancelled Mar 23, 1956 · Molderhauer Henry
Back to Saginaw, MI