OpenAirDocs.org
Cupertino, CA

Cancelled registrations · 50

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 = 'CA' AND d.registrant_city = 'CUPERTINO'
  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.

N340SWCessna 340A · S/N 340A0531Cancelled Feb 9, 2024 · Built 1978 · Vimanam Aviation LLCN231FMMooney M20K · S/N 25-0223Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1979 · Goe Larry DN11YXLeong Peng RV8 · S/N 81613Cancelled May 3, 2022 · Leong PengN72641Cessna 140 · S/N 9817Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1946 · Galaxy International IncN2300KLuscombe 8E · S/N 5027Cancelled Jul 19, 2018 · Revoked, canceled · Built 1947 · Fisher Linda LN9248ANungester Robert B 34 · S/N 001Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 1996 · Nungester Robert BN695HRRoscher Frederick THUNDER MUSTANG · S/N IITM026Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 2011 · 51 Aero Leasing LLCN1114MCessna 190 · S/N 7370Cancelled Oct 28, 2017 · Revoked, canceled · Built 1949 · Hull W BN9297VMooney M20F · S/N 690083Cancelled Feb 13, 2017 · Revoked, canceled · Built 1969 · Mcdermott John WN5987TCessna 150D · S/N 15060687Cancelled Sep 9, 2016 · Registration expired, pending cancellation · Plane Talk IncN521HEnstrom F-28A · S/N 324Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1976 · Reinhard Joseph RN199CRCountryman Charles T TAC-1 · S/N CT001Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1985 · Countryman Charles TN3784GPage Cherokee CHEROKEE II · S/N 1Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1962 · Havens Richard AN5241XHammersmith S/Hammersmith B ROTODYNE M2 · S/N 001ACancelled Jun 4, 2013 · Registration expired, pending cancellation · Hammersmith Steven JN7078Lamb MODEL-1 · S/N ML-1Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1980 · Lamb Maurice WN5056AHollmann Martin BUMBLE BEE · S/N 001Cancelled Jan 23, 2013 · Third renewal notice · Built 1983 · Hollmann MartinN2957TAero Commander 200D · S/N 330Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Micelli Robert JN5224BMooney M20 · S/N 1087Cancelled Aug 14, 2012 · Revoked, canceled · Built 1956 · Wadlow Robert EN5271YPiper PA-23-250 · S/N 27-2309Cancelled Aug 14, 2012 · Revoked, canceled · Built 1963 · Broussard Raymond O JrN281LHawker SEA FURY TMK 20 · S/N ES 3615Cancelled May 29, 2007 · Exported to United Kingdom · Built 1948 · Zager Aircraft CorpN320LABellinger/Anderson/Dean LANCAIR 320 · S/N 269Cancelled Dec 17, 2004 · Triennial form not returned · Dean Wallace JrN140TKRolladen Schneider LS-6C · S/N 6314Cancelled Sep 29, 2004 · Exported to New Zealand · Kurreck Tim RN3991GCameron Balloons US V-90 · S/N 5698Cancelled Oct 23, 2003 · Exported to Poland · Built 1991 · Nungester RobertN4633FCessna TP206A · S/N P206-0233Cancelled May 16, 2003 · Second triennial mailing, no response · Built 1966 · Flying Fire Fighters IncN4663VCessna 172RG · S/N 172RG0354Cancelled Mar 19, 2003 · Second triennial mailing, no response · Built 1980 · Ford BarryN540AKCollette John L GLASAIR III · S/N 3077Cancelled Apr 22, 2002 · Triennial form not returned · Built 1991 · Snow Michael KN43377Taylorcraft BC12-D · S/N 7036Cancelled Jan 12, 2001 · Exported to Mexico · Squarcia LarryN4209ABeech C-45H · S/N AF-165Cancelled May 11, 2000 · Exported to Philippines · Lu Steve KN60AARaven S55A · S/N S55A-145Cancelled Nov 9, 1999 · Triennial form not returned · Farnham Myron JN310BKCessna 310I · S/N 310I0200Cancelled Feb 6, 1995 · Triennial form not returned · Hubley Georgia AN75PDNall P T VARIEZE · S/N 1406Cancelled May 2, 1994 · Fletcher Henry HN8248VPiper PA-28-161 · S/N 288116004Cancelled Jul 2, 1991 · Exported to United Kingdom · Aerohawk Aviation IncN40410Balloon Works FIREFLY 7 · S/N 7854Cancelled Jun 5, 1984 · Farnham M J DBA Farnham EnterprisesN8571RBeech A36 · S/N E-602Cancelled Mar 23, 1982 · Sale reported, pending cancellation · Built 1974N62257Hughes 269A · S/N 64-18088Cancelled Dec 24, 1981 · Omni Services IncN62259Hughes 269A · S/N 64-18164Cancelled Dec 24, 1981 · Omni Services IncN62260Hughes 269A · S/N 64-18124Cancelled Dec 24, 1981 · Omni Services IncN62261Hughes 269A · S/N 64-18146Cancelled Dec 24, 1981 · Omni Services IncN47017Bell TH-13T · S/N 3654Cancelled Dec 23, 1981 · Omni Services IncN47018Bell TH-13T · S/N 3615Cancelled Dec 23, 1981 · Omni Services IncN47019Bell TH-13T · S/N 3621Cancelled Dec 23, 1981 · Omni Services IncN27WBDehavilland DH82A · S/N 82901Cancelled Aug 12, 1981 · Exported to United Kingdom · Built 1938 · Buch Walter KN4931EKolstad K/Smith D CHEROKEE II · S/N K-1Cancelled Dec 1, 1980 · Built 1960 · Denesha Richard J JrN38963Lauer SCORPION TWO · S/N 24029Cancelled Sep 11, 1980 · Built 1976 · Lauer Willard LN1005PPiaggio P.136-L1 · S/N 207Cancelled Apr 11, 1978 · Built 1956 · Comstock George & Jatherine PN30138Cessna 177 · S/N 177Cancelled Sep 18, 1975 · Built 1968 · Hoehnle Richard A EtalN7161YPiper PA-30 · S/N 30-182Cancelled Feb 28, 1972 · Pacific Shore Properties IncN3437GNorth American SNJ-5B · S/N 43735Cancelled Feb 10, 1972 · Melcher Burton W IIN4649JPiper PA-28R-180 · S/N 28R-30543Cancelled Dec 31, 1970 · Frazier Gerald E Lewis M SoccioN8258ACessna 170B · S/N 25110Cancelled Jun 10, 1970 · Tosch Norman G
Back to Cupertino, CA