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.

N64LUCessna 172R · S/N 17280592Cancelled Mar 24, 2004 · Exported to India · Built 1998N95974Cessna 152 · S/N 15285993Cancelled Mar 24, 2004 · Exported to India · Built 1985N81246Cirrus Design SR20 · S/N 1389Cancelled Mar 11, 2004 · Exported to Australia · Built 2004 · International Aircraft Services LLCN4076ZRobinson Helicopter R22 BETA · S/N 1919Cancelled Feb 18, 2004 · Triennial form not returned · Built 1991 · Spitzer Matthew LN8157HCirrus Design SR20 · S/N 1376Cancelled Feb 4, 2004 · Exported to Australia · Built 2003 · International Aircraft Services LLCN112KCessna T210N · S/N 21064747Cancelled Jan 2, 2004 · Exported to Namibia · Built 1982 · Kintscher R KN8154LCirrus Design SR20 · S/N 1374Cancelled Dec 29, 2003 · Exported to Australia · International Aircraft Services LLCN8155LCirrus Design SR20 · S/N 1375Cancelled Dec 29, 2003 · Exported to Australia · Built 2003 · International Aircraft Services LLCN758UGCessna R172K · S/N R1723366Cancelled Dec 5, 2003 · Exported to Philippines · Built 1980N6150ACirrus Design SR22 · S/N 0631Cancelled Nov 17, 2003 · Exported to Australia · Built 2003 · International Aircraft Services LLCN923CDCirrus Design SR20 · S/N 1353Cancelled Oct 20, 2003 · Exported to Australia · International Aircraft Services LLCN6080WCirrus Design SR22 · S/N 0615Cancelled Oct 3, 2003 · Exported to Australia · Built 2003 · International Aircraft Services LLCN6005NCirrus Design SR22 · S/N 0640Cancelled Sep 17, 2003 · Exported to Australia · Built 2003 · International Aircraft Services LLCN48626Cessna 152 · S/N 15283354Cancelled Sep 16, 2003 · Exported to Philippines · Built 1979 · Flying Vikings IncN6063KCessna 150M · S/N 15077504Cancelled Sep 16, 2003 · Exported to Philippines · Built 1975 · Flying Vikings IncN7176SRobinson Helicopter R22 BETA · S/N 2971Cancelled Aug 27, 2003 · Triennial form not returned · Built 1999 · Spitzer Matthew DBAN1439CCirrus Design SR22 · S/N 559Cancelled Jul 25, 2003 · Exported to Australia · Built 2003 · International Aircraft Services LLCN1109CCirrus Design SR20 · S/N 1336Cancelled Jun 23, 2003 · Exported to Australia · Built 2003 · International Aircraft Services LLCN1631CCirrus Design SR20 · S/N 1324Cancelled May 22, 2003 · Exported to Australia · International Aircraft Services LLCN1302CCirrus Design SR20 · S/N 1312Cancelled May 2, 2003 · Exported to Australia · International Aircraft Services LLCN753CCirrus Design SR22 · S/N 0423Cancelled May 2, 2003 · Exported to Australia · Built 2002 · International Aircraft Services LLCN1416CCirrus Design SR22 · S/N 0479Cancelled Apr 16, 2003 · Exported to Australia · International Aircraft Services LLCN861CDCirrus Design SR20 · S/N 1215Cancelled Aug 23, 2002 · Exported to Australia · International Aircraft Services LLCN934CDCirrus Design SR20 · S/N 1216Cancelled Aug 23, 2002 · Exported to Australia · International Aircraft Services LLCN296CDCirrus Design SR22 · S/N 0207Cancelled Jun 21, 2002 · Exported to Australia · International Aircraft Services LLCN4004JRobinson Helicopter R22 BETA · S/N 1320Cancelled Mar 29, 2002 · Triennial form not returned · Built 1990 · Spitzer Matthew LN4556ZPiper PA-22-108 · S/N 22-8061Cancelled Feb 8, 2002 · Triennial form not returned · Built 1961 · Stavro Arthur JN515WBPiper PA-31T · S/N 31T-7720023Cancelled Jan 14, 2000 · Triennial form not returned · Brent'S International IncN7011JPiper PA-24-260 · S/N 24-4227Cancelled Aug 25, 1999 · Exported to CanadaN4665SSmith Gerald J MOHAWK · S/N 198Cancelled Nov 13, 1997 · Triennial form not returned · Smith J GeraldN402PCCessna 402B · S/N 402B0454Cancelled Aug 5, 1997 · Exported to Philippines · Brent'S International IncN735EWCessna 182Q · S/N 18265375Cancelled Jan 29, 1997 · Exported to PhilippinesN9834FCessna 208 · S/N 20800232Cancelled Sep 4, 1996 · Exported to Malaysia · Brents International IncN1428APiper PA-22 · S/N 22341Cancelled Jun 10, 1996 · Thompson William AN757LWCessna 152 · S/N 15279834Cancelled Jun 1, 1995 · Exported to Colombia · Aviation Training IncN734CACessna TU206G · S/N U20604820Cancelled May 11, 1995 · Exported to Mexico · Eplin Thomas MN677CPBeech 58 · S/N TH907Cancelled Dec 8, 1994 · Exported to Philippines · Northern Resort IncN9836FCessna 208 · S/N 20800234Cancelled Apr 20, 1994 · Exported to Malaysia · Brents International IncN9835FCessna 208 · S/N 20800233Cancelled Apr 19, 1994 · Exported to Malaysia · Brents International IncN9833FCessna 208 · S/N 20800231Cancelled Jan 11, 1994 · Exported to Malaysia · Brents International IncN9826FCessna 208 · S/N 20800229Cancelled Oct 18, 1993 · Exported to Malaysia · Brent'S International IncN9829FCessna 208 · S/N 20800230Cancelled Oct 15, 1993 · Exported to Malaysia · Brent'S International IncN52222Cessna 172P · S/N 17274446Cancelled Sep 10, 1993 · Triennial form not returned · Aviation Training IncN4792BCessna 152 · S/N 15283638Cancelled Jul 23, 1992 · Triennial form not returned · Aviation Training IncN4746GBeech H-18 · S/N BA627Cancelled Feb 14, 1992 · Exported to Philippines · Balubar ValerieN1362RGrumman American Avn. AA-1B · S/N AA1B0662Cancelled Jun 5, 1991 · Coutches M E DBAN2894APiper PA-28-181 · S/N 287990534Cancelled Dec 4, 1990N7043YCessna 180K · S/N 53100Cancelled May 31, 1989 · Exported to Australia · Career Aviation Sales IncN5304MSwearingen SA226TC · S/N TC204Cancelled Mar 15, 1985 · Exported to Denmark · Career Aviation Academy IncN5303MSwearingen SA226TC · S/N TC203Cancelled Feb 20, 1985 · Exported to Denmark · Career Aviation Academy Inc
Back to Hayward, CA