OpenAirDocs.org
Plymouth, MI

Cancelled registrations · 63

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

N4220BBeech F35 · S/N D-4181Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1955N7105RBalloon Works FIREFLY 7 · S/N F7-379Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1987 · Westwind Balloon CoN94876Cessna 152 · S/N 15285804Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1983 · Air One Aviation IncN5485ZPiper PA-22-108 · S/N 22-9268Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1961 · Griffin Joseph RN9806HConsolidated Vultee BT-15 · S/N 3395Cancelled Sep 6, 2019 · Revoked, canceled · Built 1942 · Krum VN5021VBaker Dellon J CGS HAWK · S/N H-8-287-K-ACancelled May 12, 2015 · Registration expired, pending cancellation · Klee Joseph CN8039BCessna 172 · S/N 29839Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1957 · Widmer Gary TN379Thunderbird P2 · S/N 102Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1959 · Pope Leon MN6130HPiper PA-28-181 · S/N 28-7890210Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1977N1914MMoening Michael D BEARHAWK · S/N 001Cancelled Jul 30, 2013 · Exported to Canada · Built 2013 · Moening Michael DN704BDDietrich BD-4 · S/N BD-4-704Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1975 · Dietrich RolfN5950LAmerican AA-1 · S/N AA1-0250Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1969 · Rocheleau Mathaus AN3EZPope SPEZIO SPORT P-3 · S/N 103Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1980 · Pope Leon MN73058Cessna 120 · S/N 10270Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1946N55JKKinney SMYTH SIDEWINDER · S/N 212159Cancelled Jan 31, 2013 · Sale reported, canceledN41CALockheed 18 · S/N 2318Cancelled Jun 4, 2012 · Revoked, canceled · Marshall Allen CN5106PPiper PA-24-180 · S/N 24-116Cancelled Feb 22, 2012 · Exported to Australia · Built 1958 · Guarino Richard JN3240QCessna 401 · S/N 401-0040Cancelled Jul 29, 2011 · Triennial form not returned · Built 1967 · Avitec IncN181MTRuark Kevin R LANCAIR IV-P · S/N LIV-428Cancelled Jul 11, 2011 · Exported to Canada · Built 1999 · Charis Foundation IIN3509DCessna 170B · S/N 27052Cancelled Dec 22, 2010 · Revoked, pending cancellation · Built 1955 · Panko Richard JN62915Cessna 172P · S/N 17275358Cancelled Jul 31, 2007 · Exported to Canada · Built 1981 · Avitec IncN441RTRobinson Helicopter R44 · S/N 1320Cancelled Jul 26, 2006 · Exported to Canada · Built 2003 · Apple Aviation Services LLCN439DERobinson Helicopter R22 BETA · S/N 3933Cancelled Apr 26, 2006 · Exported to Canada · Built 2005 · D & M Aviation LLCN5220HEurocopter COLIBRI EC 120B · S/N 1037Cancelled Dec 29, 2005 · Exported to New Zealand · Built 1999 · Pem Flight Solutions LLCN43DERobinson Helicopter R22 BETA · S/N 3017Cancelled Aug 11, 2005 · Exported to Canada · Built 1999 · Plymouth OrchardsN228CBCameron Balloons O-65 · S/N 612Cancelled Jul 8, 2005 · Registration expired, pending cancellation · Built 1980 · Pingley Gary LN432DERobinson Helicopter R44 II · S/N 10252Cancelled Feb 8, 2005 · Exported to Canada · Built 2004 · D & M Aviation LLCN9250VMooney M20E · S/N 690055Cancelled Oct 4, 2004 · Exported to Canada · Built 1969 · Kage Distributors IncN262DMBierly Douglas BIERLY KITFOX 2 · S/N 262Cancelled Aug 21, 2003 · Built 1989 · Elmendorf Thomas FN9050ZBalloon Works FIREFLY 8B-15 · S/N F8B484Cancelled Oct 22, 1998 · Triennial form not returned · Westwinds Balloon Co IncN8470SCessna 182H · S/N 18256570Cancelled Mar 24, 1997 · Triennial form not returned · Gilleian Lawrence CN16047Cessna 150L · S/N 15073439Cancelled Mar 19, 1997 · Triennial form not returned · Kennedy Thomas JN8183LCessna 172H · S/N 17256383Cancelled Jan 15, 1993 · Kennedy KevinN4060SBalloon Works FIREFLY 7 · S/N 7977Cancelled May 15, 1992 · Triennial form not returned · Westwinds Balloon CoN2043HBalloon Works FIREFLY 7 · S/N 791Cancelled Mar 28, 1991 · Triennial form not returned · Brown Laurence LN514AJMoore RAND KR-2 · S/N 1583Cancelled Jan 11, 1985 · Moore Donald EN40DSShumard Douglas J STAR-LITE · S/N 001Cancelled Jul 1, 1984 · Built 1983 · Shumard Douglas JN51226Cessna 150J · S/N 15069851Cancelled Aug 3, 1977 · Skypacers IncN6949TCessna 310D · S/N 39249Cancelled Jul 12, 1977 · Gallagher James MN5518WPiper PA-28-160 · S/N 28607Cancelled May 24, 1976 · Mitchell L DennisN11401Cessna 150L · S/N 15075390Cancelled Dec 11, 1975 · Sale reported · Built 1973N8408GCessna 150 · S/N 15062508Cancelled Sep 23, 1975 · Gould TimN70USPiccard AX-6 · S/N 670Cancelled Aug 19, 1975 · Ridley Richard GN7953NPiper PA-28-180 · S/N 28-5369Cancelled May 15, 1974 · Sky Pacers IncN683APiper PA-22 · S/N 2285Cancelled Apr 24, 1974 · Long Harold KN20RMMabrey-Martin VOLKSPLANE VP-1 · S/N V-300-RMCancelled Dec 19, 1973 · Mabrey Russell BN7630VAero Commander CALLAIR A-9B · S/N 1358Cancelled Jan 29, 1973 · Exported to Bolivia · De Smyter John KeithN2389FCessna 210E · S/N 21058589Cancelled Jan 10, 1973 · Exported to Bolivia · John Keith DesmyterN50867Cessna 150J · S/N 15069607Cancelled Nov 15, 1971 · Exported to Canada · Smith George H SrN87261Ercoupe 415-C · S/N 434Cancelled Sep 25, 1970 · Built 1946 · Shemwell Carl R
Back to Plymouth, MI