Skip to content

Cancelled registrations · 97

Query with SQL

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 = 'SUNNYVALE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 = 'SUNNYVALE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N172GPCessna R172H · S/N R1720553Cancelled Sep 30, 2025 · Exported to Guatemala · Sky Dolphin Aviation LLC N8144Bede BD-4 · S/N 405Cancelled Jun 7, 2023 · Revoked, canceled · Built 1972 · Bullen Gary H N698DCessna 414 · S/N 414-0046Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1970 · Yuli Services Inc N301VXAirbus Group HQ VAH001 · S/N 001Cancelled Dec 4, 2020 · Sale reported, canceled · Built 2017 N302VXAirbus Group HQ VAH001 · S/N 002Cancelled Dec 4, 2020 · Sale reported, canceled N8885CPiper PA-22 · S/N 22-1469Cancelled Aug 2, 2020 · Revoked, canceled · Built 1953 · Greenlake Aero Club N4544CCessna 170B · S/N 25488Cancelled Jun 26, 2020 · Revoked, canceled · Built 1953 · Sea Gull Flying Club Inc N217VAvia Stroitel AC-5M · S/N 021Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2002 · Chichkov Dmitry N642BSSigura Ronen RONEN ONE · S/N 010116Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 2016 · Sigura Ronen N605SDGroves M B PIEL S D 605 · S/N WN191Cancelled May 1, 2019 · Registration expired, pending cancellation · Groves Montgomery B N826APPowrachute AIRWOLF 912ULS · S/N A288ULSCancelled Mar 13, 2019 · Registration pending, canceled · Built 2017 N12987Rowlee Judith L BOLAND 48-12/AX-6 · S/N 4812-01Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 2000 · Rowlee Judith L N7106JBalloon Works FIREFLY 7 · S/N F7-384Cancelled Jan 10, 2019 · Registration expired, pending cancellation · Rowlee Judith L N97321Stinson 108 · S/N 108321Cancelled Nov 17, 2018 · Revoked, canceled · Built 1946 · 85 Flying Club Inc N218ABQuad City Ultralights CHALLENGER II · S/N CH2-1196-CW-1534Cancelled May 30, 2018 · Sale reported, canceled · Built 1996 N501UXGatewing UX5 · S/N UX5-000142Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 2013 · Trimble Navigation Ltd N485BTGatewing X 100 UAS · S/N XB0278Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Trimble Navigation Ltd N485ETGatewing X 100 UAS · S/N XB0289Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Trimble Navigation Ltd N888FBDawson William S EXEC 162F · S/N 6253Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Champ Armstrong LLC N518BCJerry Lamont Parker LOEHLE MUSTANG 5151 · S/N 5151-10873332Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 2013 · Parker Jerry L N195RHNielsen Ray R VANS AC RV-3 · S/N 2Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1997 · Hosey Richard J N102MJMillennium Jet SOLOTREK · S/N 001Cancelled Aug 5, 2016 · Third renewal notice · Millennium Jet Inc N5492SCessna TR182 · S/N R18201588Cancelled Sep 11, 2015 · Exported to Chile · Built 1980 · Kidney Scott N821DRGoetowski Charles R RANS S-10 SAKOTA · S/N 0990115Cancelled May 6, 2015 · Registration expired, pending cancellation · Goetowski Charles R N95769Taylorcraft BC12-D · S/N 8069Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1946 · Bourquin Leslie E N9237KPiper PA-28-151 · S/N 28-7615187Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1976 · Lutz Charles E N7038ZLiddell Ronald QUCKSLVR MXL II SPRT · S/N 396Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Liddell Ronald L N7297TCessna 172A · S/N 46897Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1959 · Gardner Paul R N5021EGroat-Steven WEEDHOPPER JC24 · S/N 0004Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1978 · Groat Steven C N3619DCessna 310 · S/N 35319Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1956 · Martinez Frank M N6570CJovair JOV-4E · S/N 101Cancelled Aug 7, 2013 · Revoked, canceled · Built 1967 · Aero Resources Incorporated N48404Cessna 152 · S/N 15283333Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Alcaine Manuel E N8974ABeech C35 · S/N D-2728Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1951 · Howard John B N97735Stinson 108 · S/N 108-735Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1946 · Diamond Richard M N8654MBeech 35-B33 · S/N CD-675Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1963 · Stimmel James B N6740PPiper PA-24-250 · S/N 24-1868Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1960 · Cochrane John A N5142QCessna T210L · S/N 21059642Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1972 · Cuevas Daniel P DBA N8402PPiper PA-28RT-201T · S/N 28R-8131159Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1981 N4510JPiper PA-28R-180 · S/N 28R-30366Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1968 · Arrow Associates N5818WPiper PA-28-150 · S/N 28-1993Cancelled Oct 25, 2012 · Built 1964 · Allen Bradley R N1773QCessna 150L · S/N 15073073Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1971 · Woosley Melvin E N75TSSkinner ACRO-SPORT · S/N 318Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1976 N3030ABeech V35A · S/N D-8935Cancelled Nov 28, 2011 · Exported to Paraguay · Built 1969 · Skulick Eugene A 11 N3836LBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3752Cancelled Dec 21, 2010 · Exported to New Zealand · Built 1982 · Bay Area Soaring Associates N787QBeech H-18 · S/N BA-662Cancelled Nov 3, 2010 · Second triennial mailing, no response · Built 1964 · General Electric Crdt Corp Of Tn N3771GChristopher John CHRISTOPHER MODEL A · S/N 1Cancelled Jul 27, 2009 · Registration revoked · Built 1960 · Christopher John N21155Stinson HW75 · S/N 7054Cancelled Jul 13, 2009 · Registration revoked · Built 1939 · Eggers Fred C N9052CWittman W8L · S/N 9Cancelled Jun 11, 2008 · Triennial form not returned · Built 1955 · Mccaulou Alfred E N74440Bellanca 14-13-2 · S/N 1553Cancelled Dec 12, 2007 · Second triennial mailing, no response · Built 1947 · Tripp Robert E N642BACentrair 101A · S/N 101A0187Cancelled Sep 10, 2007 · Exported to Australia · Built 1984 · Bay Area Soaring Associates Inc

Back to Sunnyvale, CA