Hayward, CA

Cancelled registrations · 263

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

N6342MCessna 152 · S/N 15284683Cancelled Dec 6, 1984 · Green John DN13336Cessna 172M · S/N 17262680Cancelled Mar 27, 1984 · Administratively canceled · Allen Jack LN8078JPiper AEROSTAR 601P · S/N 61P05657963245Cancelled Feb 2, 1983 · Administratively canceled · Research Group 79 17N4930WRockwell International 114 · S/N 14253Cancelled Sep 9, 1982 · Bartolomei HarryN3378ZPiper PA-18A 150 · S/N 18-7259Cancelled May 6, 1982 · Exported to Canada · American Concrete Sawing IncN4112YBellanca 8KCAB · S/N 287-77Cancelled Dec 23, 1981 · Built 1977 · Mayer August J Jr Et AlN46630Cessna 172K · S/N 17257395Cancelled Oct 15, 1981 · Aviation Training IncN6755TCessna 310D · S/N 39055Cancelled Oct 15, 1981 · Aviation Training IncN8361EMooney M20A · S/N 1539Cancelled Apr 12, 1979 · Built 1960 · Morris Plan Co Of CaliforniaN6526SCessna 150H · S/N 15067326Cancelled Oct 6, 1978 · Exported to Canada · Performance Aircraft IncN2865GChampion 7ECA · S/N 513Cancelled Jul 25, 1976 · Miller Jack PN60516Cessna 150J · S/N 15070366Cancelled May 26, 1976 · Tjon JeromeN36234Bellanca 7ECA · S/N 959-73Cancelled May 20, 1976 · Milford Victor BN25722Beech 95-B55 · S/N TC-1613Cancelled Jan 1, 1976 · Exported to Australia · Built 1973 · Beechcraft WestN22509Cessna 150H · S/N 15068326Cancelled Oct 21, 1975 · Mckewon Richard RN3092DCessna 310 · S/N 35292Cancelled May 26, 1975 · Lidstone Kevan JN411UBeech D18S · S/N A122Cancelled Apr 26, 1974 · Built 1946 · Mullens Delmar LN60997Cessna 150J · S/N 15070722Cancelled Jun 27, 1973 · Flite Tech IncN22446Cessna 150 · S/N 15068289Cancelled Jun 25, 1973 · Tjon Jerome TN2093PPiper PA-23 · S/N 23-681Cancelled May 30, 1973 · Air Apache IncN11094Champion 7ECA · S/N 101Cancelled Nov 14, 1972 · Flite Tech IncN6204UMooney M20C · S/N 2043Cancelled Aug 14, 1972 · Anthony Aircraft IncN3180SCessna 182 · S/N 18255680Cancelled Feb 29, 1972 · Built 1964 · Drinkwater David & Evans James DN3766JCessna 150G · S/N 150-65066Cancelled Jan 21, 1972 · Del Rosso Harry PN56703Aeronca 0-58B · S/N 12463Cancelled Oct 27, 1971 · Dave Anthony Used AircraftN6972XCessna 172B · S/N 17247872Cancelled Sep 29, 1971 · Aces-Up SkyserviceN50926Cessna 150J · S/N 15069648Cancelled Sep 25, 1971 · Lang Robert J DBA Mini ClippersN10411Beech C18S · S/N 66402Cancelled Jul 14, 1971 · Nrthwest Aviation IncN60313Cessna 150J · S/N 15070219Cancelled Feb 25, 1971 · Flight Safety IncN6408GCessna 150K · S/N 15071908Cancelled Feb 25, 1971 · Flight Safety IncN6368RPiper PA-28-140 · S/N 28-21540Cancelled Feb 2, 1971 · Harris Ralph HN5972QMooney M20E · S/N 846Cancelled Jan 28, 1971 · Built 1966 · John D Rutzebeck IncN54323Cessna T-50 · S/N 6457Cancelled Jan 25, 1971 · Hayward Skyways IncN99941Engineering & Research 415-C · S/N 2546Cancelled Jun 17, 1970 · Simonian SimonN2657NCessna 120 · S/N 12915Cancelled Jun 5, 1970 · Heering Erwin EN5252YPiper PA-23-250 · S/N 27-2312Cancelled Sep 28, 1966 · Exported to Canada · Built 1963 · Coutches Michael E DBA American Aircraft Sales CoN4351UCessna 150D · S/N 15060351Cancelled Nov 17, 1965 · California AirwaysN2424DCessna 170B · S/N 20576Cancelled May 22, 1965 · Hayward Ang Base Flying ClubN68267Schweizer TG3A · S/N 16Cancelled May 21, 1965 · Arnold Leslie RN72643Cessna 140 · S/N 9819Cancelled May 21, 1965 · California AirwaysN2994NCessna 140 · S/N 13252Cancelled May 19, 1965 · Mcmanamy P JN1967NCessna 120 · S/N 12203Cancelled May 18, 1965 · California AirwaysN5895PPiper PA-24-250 · S/N 24-982Cancelled Jan 29, 1965 · Custom AviationN9613ACessna 140A · S/N 15476Cancelled Apr 13, 1964 · Murray R SN2360PPiper PA-18 · S/N 18-4246Cancelled Jul 27, 1962 · Les Arnold Enterprises IncN89815Cessna 140 · S/N 8864Cancelled Oct 5, 1961 · Exported to Norway · Hammitt Howard WN3215DCessna 180 · S/N 32013Cancelled Jan 13, 1960 · Exported to Vietnam · American Aircraft Sales CoN4391VCessna 195 · S/N 7342Cancelled Oct 9, 1957 · Exported to Bolivia · American Aircraft Sales CoN1760NCessna 120 · S/N 12004Cancelled Sep 12, 1957 · Mcmanamy P JN65989Howard GH-3 · S/N 949Cancelled Mar 14, 1956 · Built 1944 · Foster Ray M / Marsh Air Service
Back to Hayward, CA