Skip to content

Walnut Creek, CA

Cancelled registrations · 85

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 = 'WALNUT CREEK' 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 = 'WALNUT CREEK'
  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 = 'WALNUT CREEK'
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.

N9444ACessna 140A · S/N 15265Cancelled Sep 7, 2026 · Diel Mark A N311CGGulfstream Aerospace GVI (G650) · S/N 6064Cancelled Feb 25, 2025 · Exported to Isle Of Man · Built 2014 · Marinelli Paul T Trustee N6831RCessna T210G · S/N T210-0231Cancelled May 22, 2024 · Exported to Chile · Built 1966 · Weissburg Barry D N31AKHansen Kenneth Ea LONG EZ · S/N KE-1Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1983 · Harvey Frank G N685QADJI PHANTOM 3 PROFESSION · S/N P76DCK26B20978Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Jax Kneppers Associates Inc N567DAGlaser-Dirks DG-400 · S/N 4-39Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Antelman Donald R N53GV3D Robotics IRIS+ · S/N IRS1434800152/PXFP145938Cancelled May 6, 2019 · Registration expired, pending cancellation · Grandview Services LLC N56GV3D Robotics IRIS+ · S/N IRS1433200324/PXFP144380Cancelled May 6, 2019 · Registration expired, pending cancellation · Grandview Services LLC N7796SSchweizer SGS 1-26D · S/N 456Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Built 1969 · Csaa N415AFDoyle Dermot J ODYSSEY · S/N 001Cancelled Oct 25, 2018 · Built 2008 · Cooper Sean P N8120EMooney M20A · S/N 1391Cancelled Jul 26, 2018 · Revoked, canceled · Built 1959 · Higgins Leroy N21945Cessna C-165 · S/N 561Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1940 · Hale S W N8257MCessna 182P · S/N 18264575Cancelled Mar 23, 2018 · Revoked, canceled · Built 1976 · Wirth Raliegh N2727NPowrachute PC 2000 · S/N A 254 POWCancelled Feb 12, 2018 · Registration expired, pending cancellation · Burke Buddy N6843KPiper PA-16 · S/N 16-677Cancelled Nov 21, 2017 · Revoked, canceled · Built 1949 · Gouchie Wesley J Jr N2960Carlton GYROPLANE 'A' · S/N A-1Cancelled Oct 28, 2017 · Revoked, canceled · Carlton Philip C N5531WAtkinson Philip J QUICKSILVER SPRINT · S/N N0767817Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2006 · Atkinson Philip J N332Harvey Frank G C2 · S/N 01Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 2002 · Harvey Frank G N79MECessna T210N · S/N 21063269Cancelled Sep 19, 2016 · Exported to Brazil · Built 1979 · Sims Stuart P N14THJones Hobert BOBCAT-1 · S/N 1Cancelled Oct 22, 2015 · Hammitt Thomas K N8193GWhite Roy TWIN STAR MK 2 · S/N M2-102Cancelled May 15, 2015 · Registration expired, pending cancellation · Moore James I N680TBeech K35 · S/N D-5785Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1958 · Beasley Raymond R N1408RGrumman American Avn. AA-1B · S/N AA1B-0508Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1974 · Scranton Michael C N66HHolder MIDGET MUSTANG I · S/N 380Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1972 · Janes David A N6470KRepublic RC-3 · S/N 721Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1947 N1460BLuscombe 8F · S/N 6087Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1948 · Russell James K N391TMPiper PA-28R-201T · S/N 28R-7803200Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1978 · One Tango Mike LLC N40093Beech UC-45J · S/N 89484Cancelled Oct 3, 2012 · Sale reported, canceled · Built 1943 N3153NCunningham George A RUTAN LONG E-Z · S/N 770Cancelled Aug 7, 2012 · Registration pending, canceled · Built 1982 N3977LCessna 172G · S/N 17254146Cancelled Jun 7, 2012 · Registration pending, canceled · Built 1966 N13UWUtah State University KOLB TWINSTAR MK-II · S/N M2181Cancelled Mar 9, 2011 · Second renewal notice · Williams Franklin T N434ACTreadwell Walter L TREADWELL-ALLEY CAT · S/N 004Cancelled Jan 11, 2011 · First renewal notice · Built 1999 · Treadwell Walter L N471GFCessna T210K · S/N 21059453Cancelled Apr 23, 2010 · Exported to Mexico · Built 1971 · Kirspel Franz J N55138Cessna 172P · S/N 17275117Cancelled Feb 10, 2010 · Exported to Philippines · Built 1981 · Broda Edward S N1515VLockheed 18-08 · S/N 2111Cancelled Jun 30, 2009 · Registration revoked · Built 1941 · Answer Man Inc N8272JVarga 2150A · S/N VAC-118-79Cancelled Dec 12, 2008 · Triennial form not returned · Built 1978 · Parker Claron Trustee N522GGGould Gray J MURPHY REBEL · S/N 415RCancelled Sep 24, 2004 · Triennial form not returned · Built 2000 · Gould Gray J N5698LMooney M20J · S/N 24-1415Cancelled Dec 13, 2002 · Triennial form not returned · Built 1983 · Concord Flying Club N644LLYakovlev YAK 52 · S/N 833310Cancelled Nov 26, 2002 · Whiteway Melinda M N18GJOdell John R. & George V. THORP T-18 · S/N 792Cancelled Apr 4, 2000 · Triennial form not returned · Odell John R N6420EParker Michael G RV-4 · S/N 1875Cancelled Aug 2, 1999 · Second triennial mailing, no response · Parker Michael G N444LPOpperman Christopher J M LANCAIR IV · S/N 199Cancelled Jun 15, 1998 · Bradford Properties Inc N9552BCessna 172R · S/N 17280394Cancelled May 19, 1998 · Exported to Germany · Carlson John Eric DBA N9571WCessna 182S · S/N 18280155Cancelled Apr 28, 1998 · Exported to Germany · Carlson John Eric DBA N443ESCessna 172R · S/N 17280360Cancelled Apr 15, 1998 · Exported to Germany · Carlson John Eric DBA N9491ZCessna 172R · S/N 17280341Cancelled Mar 19, 1998 · Exported to Germany · Carlson John Eric DBA N9525FCessna 172R · S/N 17280336Cancelled Mar 19, 1998 · Exported to Germany · Carlson John Eric DBA N9496FCessna 172R · S/N 17280342Cancelled Mar 13, 1998 · Exported to Germany · Carlson John Eric DBA N9943FCessna 172R · S/N 17280195Cancelled Feb 3, 1998 · Exported to Germany · Carlson John Eric DBA N9937FCessna 172R · S/N 17280183Cancelled Nov 5, 1997 · Exported to Germany · Carlson John Eric

Back to Walnut Creek, CA