OpenAirDocs.org
Holland, MI

Cancelled registrations · 67

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

N1998BVannuil Jerry E AVID FLYER MKIV · S/N 001Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 2008 · Vannuil Jerry EN696JBCanadair CL-600 CHALLENGER · S/N 1061Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1982 · Sierra Tango Bravo LLCN5605DBuckeye Industries DREAM MACHINE · S/N 4823Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2000 · Bussies Carl JN2007JBush Jerome J PIETENPOL SKY SCOUT · S/N 001Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Bush Jerome JN8052KStinson 108 · S/N 1083052Cancelled Jan 25, 2019 · Revoked, canceled · Built 1947 · Six Flg DutchmenN633STSwearingen SA-226T · S/N T-237Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Airship Ventures LLCN742QADJI PHANTOM 3 ADVANCED · S/N P76DCG17A10856Cancelled May 31, 2018 · Sale reported, canceledN5607FAlon A2 · S/N A-207Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1966 · Stam Steven SN29622Taylorcraft BF · S/N 2464Cancelled Mar 23, 2018 · Revoked, canceled · Built 1940 · Wiley Robert GN2893ABuckeye DREAM MACHINE 582 · S/N 3765Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Ryzenga Mark RN6144ADestiny XLT · S/N 2C0337Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2000 · Mcdonough James MN9649UGrumman American Avn. AA-1C · S/N AA1C0086Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1977 · Stam Steven SN7413UBalloon Works FIREFLY 8B · S/N F8B-080Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1987 · Van Dis Marc H DBAN88438Piper J3C-65 · S/N 16056Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1946 · Teall AlanN132EPDassault/Sud FAN JET FALCON SER F · S/N 463Cancelled Mar 3, 2016 · Exported to Canada · Built 1982 · Wingspan LLCN133EPDassault-Breguet FALCON 10 · S/N 131Cancelled Dec 23, 2015 · Exported to Canada · Built 1978 · Wingspan LLCN650PCCessna T310Q · S/N 310Q0465Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1972 · Wingspan LLCN7247WBalloon Works FIREFLY 8 · S/N F8-433Cancelled Nov 14, 2013 · Registration expired, pending cancellation · Built 1999 · Van Dis Marc HN3558BBeech B50 · S/N CH-16Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1954 · Belligan Bruce JN8405ECessna 172N · S/N 17272195Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1979 · Tulip City Air Service IncN7419YBalloon Works FIREFLY 8B · S/N F8B-086Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1987 · Van Dis Marc H DBAN9039PPiper PA-24-260 · S/N 24-4502Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1966 · Eagles LtdN79569Cessna 172K · S/N 17258183Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Lakeshore AviatorsN7065NVetrano William J RAF 2000 · S/N H2-93-4-89Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1993N24BJPulis John L SCORPION-II · S/N 6421Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1979N5136YCessna T210N · S/N 21064091Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1980 · Keith Alan HN4798APiper PA-22-150 · S/N 22-3949Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1956 · Weener Ronald PN3716SBalloon Works FIREFLY 8B · S/N F8B-014Cancelled Feb 13, 2013 · Sale reported, canceledN5941XBrantly B-2 · S/N 79Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1961N3709SBalloon Works FIREFLY 8B · S/N F8B-023Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1985N16DTTuransky-David R.A.F. VARIEZE · S/N 1260Cancelled Jul 9, 2012 · Sale reported, canceled · Built 1980N5321DCessna 172N · S/N 17272516Cancelled Apr 27, 2012 · First renewal notice · Built 1979 · Tulip City Air Service IncN54WBBeswick THORP T-18 · S/N 1026Cancelled Jan 6, 2012 · First renewal notice · Built 1978 · Beswick William JrN9630ZCessna U206G · S/N U206-06583Cancelled Dec 5, 2008 · Exported to South Africa · Project Air IncN315PRaytheon A36 · S/N E-3434Cancelled Jun 25, 2008 · Built 2002 · Skytracker Aviation II IncN805AACessna 208B · S/N 208B0844Cancelled Dec 27, 2007 · Exported to Madagascar · Built 2000 · Project Air IncN1760RCessna U206G · S/N U20606805Cancelled Aug 29, 2007 · Exported to Tanzania · Built 1984 · Project Air IncN396MECessna 182S · S/N 18280875Cancelled Jun 22, 2006 · Exported to Venezuela · Built 2000 · Skytracker Aviation LLCN9792YCessna 210N · S/N 21064600Cancelled Sep 28, 2005 · Exported to Tanzania · Built 1981 · Project Air IncN3131CSmith-Houtman SH · S/N 501Cancelled Mar 12, 2004 · Exported to Canada · Built 1959 · Fogg Michael ToddN4942CCessna 210N · S/N 21063681Cancelled Dec 3, 2003 · Exported to Uganda · Built 1979 · Project Air IncN736GXCessna R172K · S/N R1722526Cancelled Sep 30, 2003 · Exported to Australia · Built 1977 · Project Air IncN12173Cessna 208B · S/N 208B0987Cancelled Dec 2, 2002 · Exported to United Kingdom · Built 2002 · Project Air IncN9771FCessna 208 · S/N 20800190Cancelled Aug 15, 2002 · Exported to United Kingdom · Built 1990 · Project Air IncN9750FCessna 208 · S/N 20800172Cancelled Mar 12, 1999 · Exported to Ethiopia · Project Air IncN714UHCessna 152 · S/N 15279440Cancelled Sep 18, 1997 · Triennial form not returned · Tulip City Air Service IncN741MFCessna 150L · S/N 15075099Cancelled Oct 27, 1993 · Triennial form not returned · Tulip City Air Service IncN359VEVan ECK Steve MODEL 300 · S/N 1Cancelled Jan 9, 1991 · Van Ek Steven MN6372WPiper PA-28-140 · S/N 28-20433Cancelled Sep 25, 1985 · South Side Flying Club IncN36878Aeronca 65-TAL · S/N L1931TACancelled Aug 7, 1982 · Built 1931 · Omni Air & Klein Edward
Back to Holland, MI