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.

N49858Cessna 152 · S/N 15281362Cancelled Apr 13, 2010 · Exported to Philippines · Built 1978 · Flying VikingsN172KCessna 172M · S/N 17264011Cancelled Feb 25, 2010 · Exported to Philippines · Built 1974N25461Cessna C-145 · S/N 566Cancelled Aug 25, 2009 · Registration revoked · Built 1940 · Bay Area Aerial SurveyN64262Cessna 172M · S/N 17265135Cancelled Jul 27, 2009 · Exported to Chile · Built 1975 · Coutches Enterprises IncN7188SRobinson Helicopter R22 BETA · S/N 3030Cancelled Jul 23, 2009 · Triennial form not returned · Built 2000 · Spitzer Matthew DBAN2806ZPiper PA-22-150 · S/N 22-6799Cancelled Jul 20, 2009 · Registration revoked · Built 1959 · Fite Gerald WN25422Cessna 152 · S/N 15280648Cancelled Jul 16, 2009 · Registration revoked · Built 1977 · Lang Hal RN22454Cessna 150H · S/N 15068293Cancelled Jul 13, 2009 · Registration revoked · Built 1968 · Del Rosso Harry PN5160UCessna 172RG · S/N 172RG0266Cancelled Jun 30, 2009 · Exported to Brazil · Built 1980 · Rhine Bradley RN1713Beech C-45H · S/N AF-643Cancelled Jun 23, 2009 · Registration revoked · Built 1954 · Robinson Robert DBAN873CKCessna 172S · S/N 172S9873Cancelled May 19, 2009 · Exported to India · Built 2005N1302PPiper PA-23 · S/N 23-342Cancelled May 8, 2009 · Registration revoked · Built 1955 · Lang Robert JN12353Cessna 172M · S/N 17261944Cancelled Apr 14, 2009 · Exported to Namibia · Built 1973N61736Cessna 172M · S/N 17264762Cancelled Apr 8, 2009 · Triennial form not returned · Built 1975 · Flying Vikings IncN6131LCessna 152 · S/N 15284361Cancelled Jul 24, 2008 · Exported to New Zealand · Coutches Enterprises IncN5080UCessna 206 · S/N 206-0080Cancelled Jul 21, 2008 · Exported to Mexico · Built 1963 · International Aircraft Services LLCN9141YPiper PA-28-161 · S/N 28-8616014Cancelled Jul 10, 2008 · Triennial form not returned · Built 1985 · Flying Vikings IncN2059CCessna 172P · S/N 17274407Cancelled Jun 10, 2008 · Exported to New ZealandN80897Cessna 172M · S/N 17266794Cancelled May 28, 2008 · Exported to Philippines · Built 1976N152SCCessna 152 · S/N 15280265Cancelled Feb 26, 2008 · Triennial form not returned · Built 1977 · Flying Viking IncN757XSCessna 152 · S/N 15280091Cancelled Feb 26, 2008 · Triennial form not returned · Built 1977 · Flying Vikings IncN59067Cessna 210L · S/N 21060066Cancelled Feb 21, 2008 · Exported to Namibia · Built 1973N1621XCessna 210L · S/N 21060657Cancelled Nov 19, 2007 · Exported to Namibia · Built 1975N393PTTodebush Peter C SH-2F · S/N 393FCancelled Jul 11, 2007 · Triennial form not returned · Todebush Peter CN111RFPiper PA-31T · S/N 31T-7520037Cancelled May 31, 2007 · Exported to Australia · Built 1975 · Skyview Aviation LLCN2327SRobinson Helicopter R22 BETA · S/N 2113Cancelled Feb 12, 2007 · Triennial form not returned · Built 1992 · Spitzer MatthewN6471HCessna 152 · S/N 15284169Cancelled Feb 1, 2007 · Exported to Philippines · Built 1979 · Flying Vikings IncN65552Cessna 152 · S/N 15281614Cancelled Feb 1, 2007 · Exported to Philippines · Built 1978 · Flying VikingsN757VXCessna 152 · S/N 15280048Cancelled Feb 1, 2007 · Exported to Philippines · Built 1977 · Flying Vikings IncN70144Robinson Helicopter R44 · S/N 0362Cancelled Jan 23, 2007 · Triennial form not returned · Built 1998 · Spitzer MatthewN2566WRobinson Helicopter R22 BETA · S/N 0616Cancelled Dec 5, 2006 · Triennial form not returned · Spitzer Matthew LN51215Cessna 172P · S/N 17274281Cancelled Sep 22, 2006 · Exported to Malaysia · Built 1980N220SARaytheon 58 · S/N TH-2003Cancelled Sep 12, 2005 · Exported to Australia · Built 2001 · International Aircraft Services LLCN60665Cirrus Design SR22 · S/N 1275Cancelled Jun 2, 2005 · Exported to Australia · Built 2005 · International Aircraft Services LLCN60182Cirrus Design SR20 · S/N 1490Cancelled Apr 1, 2005 · Exported to Australia · Built 2005 · International Aircraft Services LLCN61036Cirrus Design SR22 · S/N 1305Cancelled Apr 1, 2005 · Exported to Australia · Built 2005 · International Aircraft Services LLCN398CDCirrus Design SR22 · S/N 1274Cancelled Mar 3, 2005 · Exported to Australia · Built 2005 · International Aircraft Services LLCN54125Cirrus Design SR22 · S/N 1203Cancelled Feb 10, 2005 · Exported to Australia · International Aircraft Services LLCN187CDCirrus Design SR22 · S/N 0927Cancelled Sep 7, 2004 · Exported to Australia · Built 2004 · International Aircraft Services LLCN692CDCirrus Design SR22 · S/N 1017Cancelled Sep 3, 2004 · Exported to Australia · International Aircraft Services LLCN193CDCirrus Design SR22 · S/N 0928Cancelled Jul 29, 2004 · Exported to Australia · International Aircraft Services LLCN628CDCirrus Design SR22 · S/N 0912Cancelled Jul 29, 2004 · Exported to Australia · International Aircraft Services LLCN134KPiper PA-28-235 · S/N 28-7410091Cancelled Jun 22, 2004 · Exported to Canada · Built 1974 · Kintscher R KN5004RCirrus Design SR22 · S/N 0851Cancelled May 24, 2004 · Exported to Australia · Built 2004 · International Aircraft Services LLCN51239Cirrus Design SR22 · S/N 0849Cancelled May 24, 2004 · Exported to Australia · Built 2004 · International Aircraft Services LLCN53423Cirrus Design SR22 · S/N 0828Cancelled May 24, 2004 · Exported to Australia · Built 2004 · International Aircraft Services LLCN803KCCirrus Design SR22 · S/N 0807Cancelled Apr 29, 2004 · Exported to Australia · Built 2004 · International Aircraft Services LLCN5361XCirrus Design SR20 · S/N 1409Cancelled Apr 28, 2004 · Exported to Australia · International Aircraft Services LLCN81239Cirrus Design SR20 · S/N 1392Cancelled Apr 28, 2004 · Exported to Australia · Built 2004 · International Aircraft Services LLCN80904Cirrus Design SR22 · S/N 0780Cancelled Mar 31, 2004 · Exported to Australia · International Aircraft Services LLC
Back to Hayward, CA