OpenAirDocs.org
San Ramon, CA

Cancelled registrations · 28

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 = 'SAN RAMON'
  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.

N345PTWagner Robert C SEAREY LSX · S/N 1LK533CCancelled Aug 28, 2024 · Exported to Canada · Built 2015 · Fridell Mark LN515RKriech Rand R QUICKIE Q-2 · S/N 2362Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Kriech RandN747GGDJI PHANTOM 2 VISION + · S/N PH645475387 V3.0Cancelled Nov 2, 2018 · Second renewal notice · Green Grid IncN6053MStinson 108-3 · S/N 108-4053Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1947 · Ad-Viation IncN777TXGates Lear Jet 25C · S/N 084Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Z-Line Designs IncN80236Cessna 172M · S/N 17266464Cancelled May 23, 2018 · Exported to Australia · Built 1975 · Overseer Investments CorpN6769MStinson 108-3 · S/N 108-4769Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1949 · Ad-Viation IncN331CStinson 108-2 · S/N 108-3331Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1947 · Ad-Viation IncN488JSBuckeye DREAM MACHINE · S/N 48881Cancelled Feb 15, 2018 · Sale reported, canceled · Built 2001N29175Piper PA-32-300 · S/N 32-7940133Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1979 · Foster William GN20FUSocata TB 10 · S/N 641Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Four Banisters IncN55XSakert CASSUTT M-II · S/N 501Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1977 · Channing Troy AN6616XCessna 210A · S/N 21057616Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1960 · Farr Samuel R DBAN36762Piper PA-28-161 · S/N 28-7816656Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1978 · Plowe Harry SN446HCessna 414 · S/N 4140492Cancelled Feb 9, 2012 · Exported to Colombia · Built 1974 · Assad Hany Md DBAN2857GNorth American SNJ-6 · S/N 112124Cancelled Aug 26, 2009 · Registration revoked · Built 1959 · Jones Thomas HN5050BBeech F35 · S/N D-4318Cancelled Jul 30, 2008 · Triennial form not returned · Built 1955 · Fletcher Michael HowardN200JEDassault/Sud FAN JET FALCON · S/N 133Cancelled Mar 7, 2007 · Triennial form not returned · Built 1968 · Jet Ex IncN12RYYoung Robert/Fisher Aero HORIZON I · S/N H-106Cancelled Feb 14, 2006 · Triennial form not returned · Jones Thomas HN12988Nordheim Harry A PIETENPOL AIRCAMPER · S/N 1Cancelled Oct 6, 2004 · Triennial form not returned · Bowe Walter CN32242Jordan John Edward QUICKSILVER MXL II · S/N 395Cancelled Apr 29, 1997 · Triennial form not returned · Jordan John EN200RHHansen Roger A KR-2M · S/N 1797Cancelled Dec 30, 1991 · Hansen Roger AN13NHConsolidated Vultee/Hops L-13A · S/N 47276Cancelled Nov 5, 1991 · Triennial form not returned · Hops Monica AN547DMMerrill Royal D WEEDHOPPER JC-24B · S/N 0148Cancelled Apr 19, 1983 · Merrill D RoyalN1020FFilper TR-2X · S/N 5000TRCancelled Dec 10, 1974 · Filper ResearchN5001FFilper 100A · S/N A0002Cancelled Mar 8, 1972 · Built 1966 · Filper ResearchN5000FFilper 100A · S/N A0001Cancelled Jan 25, 1971 · Filper ResearchN5005FFilper 400A · S/N A0005Cancellation date not recorded · Filper Corporation
Back to San Ramon, CA