Alameda, CA

Cancelled registrations · 145

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

N8974VCessna 172M · S/N 17264330Cancelled Feb 10, 1977 · Exported to Australia · Built 1975 · Trans Global Aviation LtdN6872JPiper PA-32R-300 · S/N 32R-7680375Cancelled Jan 25, 1977 · Exported to Australia · Trans Global Aviation LtdN33752Piper PA-32-300 · S/N 32-7540118Cancelled Dec 17, 1976 · Exported to Australia · Built 1975 · Trans Global Aviation LtdN731JCessna 172M · S/N 17264267Cancelled Dec 2, 1976 · Exported to Australia · Trans Global Aviation LtdN75083Piper PA-28-181 · S/N 28-7690291Cancelled Nov 8, 1976 · Exported to Australia · Trans Global Aviation LtdN126KACessna 172M · S/N 17264756Cancelled Mar 25, 1976 · Exported to Australia · Trans Global Aviation LtdN43045Piper PA-28-180 · S/N 28-7405171Cancelled Jan 30, 1976 · Exported to Australia · Trans Global Aviation LtdN21793Cessna 172M · S/N 172-64022Cancelled Jan 1, 1976 · Exported to Australia · Built 1974 · Trans Global Aviation IncN13424Cessna 172M · S/N 17262742Cancelled Dec 17, 1975 · Exported to Australia · Built 1973 · Transglobal Avaition IncN492GADehavilland CARIBOU DHC-4 · S/N 255Cancelled Jun 9, 1975 · Atlas CorporationN3867GCessna U206B · S/N U206-0867Cancelled Jun 26, 1973 · N A S Alameda Aero ClubN1474DCessna 170A · S/N 20083Cancelled Nov 15, 1972 · Shandrew Stephen LN2495Unknown UNKNOWN · S/N TJP63Cancelled Mar 4, 1972 · Built 1970 · Yanagi TakN71636Luscombe 8A · S/N 3063Cancelled Feb 5, 1971 · Robertson Earl AN56152Piper PA-28R-200 · S/N 28R-7335366Cancelled Jan 20, 1971 · Exported to Austria · Trans Global Aviation LtdN6496CKnight TWISTER · S/N 001Cancelled Jan 12, 1971 · Built 1957 · Jones Verne AN7859FCessna 150F · S/N 15063959Cancelled Jun 22, 1970 · Nas Alameda Aero ClubN88819Douglas C54B-DC · S/N 10448Cancelled Nov 1, 1962 · Exported to United Kingdom · Resort Airlines IncN75298Douglas C54-DC · S/N 7480Cancelled Jun 7, 1962 · Exported to United Kingdom · Resort Airlines IncN57670Douglas C54A-DC · S/N 10311Cancelled Jul 21, 1961 · Exported to United Kingdom · Resort Airlines IncN1011KLuscombe 8A · S/N 3738Cancelled Aug 19, 1957 · Exported to Mexico · Rasanen Kaarlo EN3117VBeech 35 · S/N D540Cancelled Jan 22, 1957 · Duggan Lowell HN49009Aeronca 0-58B · S/N 058B10973Cancelled Oct 21, 1955 · Wellington DowN33CKysor Clifford P FRUSTRATED WIDOW · S/N 1Cancelled Oct 4, 1955 · Kysor Clifford PN40112Stinson 108 · S/N 108-42Cancelled Dec 17, 1953 · Fitzpatrick KirbyN3025KCulver V · S/N 244Cancelled Mar 25, 1952 · Pacific Flying ClubN51419Cessna T-50 · S/N 3686Cancelled Aug 7, 1951 · Phillips George AN48687Interstate L-6 · S/N 81Cancelled Nov 19, 1948 · Julian Orville WomackN719MSaint Louis C-2-110 · S/N 119Cancelled Dec 21, 1944 · Steele Elnora BarnesN4141Driggs DART II · S/N 9Cancelled Sep 2, 1944 · Built 1928 · Newman H LN445WCurtiss Wright TRAVEL AIR 12K · S/N 12K-2011Cancelled Nov 8, 1940 · Built 1931 · Maggi John JN19966Hermann Gerboth/Emil Kissel GERBOTHKISSEL GLIDER · S/N 1157Cancelled Apr 22, 1940 · Emil KisselN9974Travel Air A-6000-A · S/N 1095Cancelled Oct 9, 1939 · Fall EmmetN1963Waco GXE · S/N 920Cancelled Apr 15, 1938 · Built 1927 · Chamberlin Dorothy C/Morrison Walter HN12118Stinson U · S/N 9006Cancelled Jan 11, 1938 · Exported to Philippines · Built 1932 · Consolidated Aviation CorpN13210Consolidated FLEETSTER 20 · S/N 3Cancelled Dec 1, 1937 · Baldwin Richard CN14230Security National Acft S1-A · S/N 20Cancelled Aug 15, 1935 · Built 1934 · Metro Air ServiceN10620Bottarini Charles PRUFLING GLIDER · S/N 1Cancelled Mar 5, 1934 · Bottarini CharlesN10674Halton Harlold E PRIMARY GLIDER · S/N 1Cancelled Feb 19, 1934 · Halton Harold EN12226Lockheed ORION 9 · S/N 184Cancelled Apr 7, 1933 · Varney Speed Lines IncN1421Alexander LONG WING EAGLEROCK · S/N 265Cancelled Jan 5, 1933 · Curtiss-Wright Flying Service IncN5481Eaglerock LONG WING EAGLEROCK · S/N 388Cancelled Mar 23, 1932 · Medus RN6406Travel Air 3000 · S/N 752Cancelled Jun 27, 1930 · D C Warren CoN2162Andrews & Nicholson T1 LAND PLANE · S/N 1Cancelled Mar 9, 1929 · Penny SamN2167Curtiss JN4D · S/N M2021Cancelled Nov 12, 1927 · Built 1926 · Pilgrim O W And Thiery Joseph
Back to Alameda, CA