OpenAirDocs.org
Howell, MI

Cancelled registrations · 44

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

N9570FHughes 269B · S/N 410462Cancelled Sep 16, 2023 · Revoked, canceled · Built 1971 · Northland Helicopters IncN3002LCessna 310J · S/N 310J0002Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1965 · Doyle Beryle SN4054ACameron Balloons ZL-60 · S/N 6493Cancelled May 2, 2022 · Exported to Canada · Built 2007 · Petrehn Paul JN82957Aeronca 7AC · S/N 7AC-1608Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1946 · Osantowske Eugene LN88SKMckenzie GREAT LAKES 2T-1 · S/N 6618L-321Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1977 · Mckenzie David EN739JKDJI PHANTOM 4 · S/N 07DDD380A10514Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Kim Stricker Productions IncN6498AYuneec International Q500 TYPHOON · S/N YU15070962B01J01Cancelled Sep 20, 2019 · Sale reported, canceledN8868FHughes 269A · S/N 63-0232Cancelled Sep 6, 2019 · Revoked, canceled · Built 1963 · Northland Helicopters IncN1561ZBeech V35 · S/N D-8442Cancelled Jul 11, 2019 · Registration expired, pending cancellation · Built 1967 · Evergreen Exploration LLCN8829FHughes 269A · S/N 0174Cancelled Dec 19, 2018 · Registration expired, pending cancellation · Built 1963 · Freeling Joshua LN9004HBalloon Works FIREFLY 7 · S/N F7-474Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1989 · Full Of Hot Air Balloon Club LLCN360HHHaigh Henry A II HAIGH RATSREPUS SS 2 · S/N 1Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1989 · Haigh Henry A IIN9259Enstrom F-28A · S/N 240Cancelled Feb 13, 2017 · Revoked, canceled · Built 1974 · Haigh Henry AN8524KStinson 108 · S/N 1081524Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Livingston Flying Service IncN3205HVan Strien Greg EAA BIPLANE · S/N PF-1Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1992 · Carrasco William RN4547BCessna 180 · S/N 31446Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1955 · Goff Robert WN44116Cameron Balloons US Z-77 · S/N 6220Cancelled Dec 16, 2014 · Registration pending, canceled · Built 1999N90888Balloon Works FIREFLY 7 · S/N F7-625Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1990 · Full Of Hot Air Balloon Club LLCN1601ACameron Balloons US A-105 · S/N 5923Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1994 · Renaissance Balloons IncN8106BCessna 172 · S/N 29906Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1957 · Dancey Dan RN73475Cessna 172M · S/N 17267491Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1976 · Free Spirit Aviation IncN65566Cessna 152 · S/N 15281622Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1978 · Free Spirit Aviation IncN5480RCessna 172F · S/N 17253043Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1965 · Felco CorpN494CMeyers Industries 200A · S/N 258Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1960 · Mcpherson Robert TN15271Balloon Works FIREFLY 7 · S/N 10147Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1980 · Yaden Calvin DN417CPBeech 58 · S/N TH-417Cancelled Mar 13, 2012 · Exported to Honduras · Built 1973 · Cst Group LLCN4126GCameron Balloons US N-77 · S/N 6117Cancelled Sep 20, 2006 · Triennial form not returned · Built 1997 · General Motors CorpN1605ECameron Balloons US N-77 · S/N 5922Cancelled Dec 30, 2005 · Triennial form not returned · Built 1994 · Renaissance Balloons IncN3009PCameron Balloons US N-77 · S/N 6025Cancelled Dec 30, 2005 · Triennial form not returned · Built 1996 · Renaissance Balloons IncN365SACessna 172S · S/N 172S8244Cancelled Aug 19, 2004 · Exported to United Arab Emirates · Built 1999 · Smith Craig ON700JDBalloon Works FIREFLY 7-B · S/N F7B-024Cancelled Mar 9, 2001 · Prokuda Brian PN7475QAlbrecht Richard SEAREY · S/N 1DK028Cancelled Feb 19, 1999 · Albrecht RichardN1127RRaven S55A · S/N S55A306Cancelled Sep 11, 1998 · Triennial form not returned · Anything For A Buck Balloon Co DBAN5695UPiper PA-28-140 · S/N 2826493Cancelled Jan 30, 1997 · Triennial form not returned · Airservice Enterprise IncN2036FBalloon Works FIREFLY 6 · S/N 619Cancelled Aug 14, 1996 · Triennial form not returned · Stephan Gerald FN300SQHughes 269C · S/N 1290004Cancelled May 23, 1974 · Exported to South Africa · Built 1969 · Northland Helicopters IncN52441Fairchild M-62A · S/N T423395Cancelled Apr 1, 1973 · Sharpe Thomas GN9383FHughes 269B · S/N 64-0098Cancelled Mar 5, 1973 · Exported to Australia · Northland Helicopters IncN3469NPiper J3C-65 · S/N 22691Cancelled May 27, 1971 · Bowen Robert EN1998CCessna 170B · S/N 26143Cancelled May 24, 1971 · Exported to Canada · Berlin ArthurN1046DCessna 190 · S/N 7658Cancelled Sep 2, 1970 · Built 1951 · Nelmes William G L/ColN78VCessna 140 · S/N 14585Cancelled Sep 1, 1970 · Corral Leon AN76796Cessna 140 · S/N 11228Cancelled May 22, 1965 · Cook R JamesN8124ACessna 170B · S/N 20976Cancelled Jan 15, 1953 · Smyth William E
Back to Howell, MI