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.

N94276Mooney M20K · S/N 25-0481Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1980 · Performance Aircraft IncN96956Cessna 182Q · S/N 18266912Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1979 · Taylor RobertN9330XCessna 182E · S/N 18253730Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1962 · Amos Jack LN89630Cessna 152 · S/N 15282808Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1978 · Bull D SN9029CCessna 180 · S/N 31077Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1954 · Perry James MN909Piper PA-23 · S/N 23-535Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1956 · Hoffman JerryN20LFMartin-Rohde ROTEC RALLY 3-B · S/N 64552Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1982 · Lite FliteN80962Temco GC-1B · S/N 1155Cancelled May 13, 2013 · Registration expired, pending cancellation · Hadley Charles L JrN4325PPiper PA-23-160 · S/N 23-1826Cancelled May 9, 2013 · Sale reported, canceled · Built 1959N4432MPartenavia P68B · S/N 187Cancelled May 9, 2013 · Sale reported, canceled · Built 1979N73656Gyrocopter WF04 SU101 TC46 · S/N 691985184622Cancelled May 7, 2013 · Registration expired, pending cancellation · Dudicz LeonardN73664Cessna 172N · S/N 17267600Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1976 · Apa And Syzygy LLCN6599LCessna 152 · S/N 15284457Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1980 · Pehrson John V JrN5881LAmerican AA-5 · S/N AA5-0081Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1972 · C P Flying Club IncN4734DCessna 182A · S/N 34834Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1958 · Solis Clarence MN9210GCessna 172N · S/N 17273628Cancelled Apr 3, 2013 · Exported to Guatemala · Built 1980 · Flying Vikings IncN185CEConquistidore Enterprises EXEC · S/N MC185Cancelled Apr 2, 2013 · Sale reported, canceledN6085GCessna 150K · S/N 15071585Cancelled Mar 26, 2013 · Revoked, pending cancellation · Built 1969 · Sky View Aviation IncN9997Mooney M20A · S/N 1518Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1958N98567Cessna 340A · S/N 340A0036Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1976N711BMCessna 411 · S/N 411-0220Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1966N7256SCessna 150H · S/N 15067956Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1967N6466WPiper PA-28-140 · S/N 28-20539Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1964N66942Cessna 152 · S/N 15281677Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1978N6904FCessna 150F · S/N 15063504Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1966N7519VRobinson Helicopter R22 BETA · S/N 3565Cancelled Jan 31, 2013 · Built 2004 · Spitzer MatthewN7508YRobinson Helicopter R22 BETA · S/N 3757Cancelled Dec 4, 2012 · Built 2005 · Spitzer Matthew DBAN4036WPiper PA-32-300 · S/N 32-40061Cancelled Nov 29, 2012 · Revoked, canceled · Built 1966 · Davis Ray EN4861Beech D18S · S/N A-318Cancelled Sep 27, 2012 · Revoked, canceled · Built 1946 · Robinson Robert DBAN3584QCessna 172M · S/N 17261684Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1973N68286Cessna T-50 · S/N 5319Cancelled Sep 6, 2012 · Revoked, canceled · Built 1943 · Hayward Skyways IncN255ERPiper PA-44-180 · S/N 44-8195004Cancelled Aug 27, 2012 · Registration pending, canceled · Built 1980N3139KNew Piper PA-28-161 · S/N 2842265Cancelled Aug 16, 2012 · Exported to Australia · Built 2006 · International Aircraft Sales LLCN320ADDavis Ronald James VANS RV-7 · S/N 71824Cancelled Aug 16, 2012 · Exported to Australia · Built 2007 · International Aircraft Services LLCN229WBeech 65-80 · S/N LD-50Cancelled Aug 13, 2012 · Sale reported, canceled · Built 1962N6362CPiper PA-28-181 · S/N 28-7890365Cancelled Aug 3, 2012 · Exported to Australia · Built 1978N4613VCessna T-50 · S/N 3502Cancelled Jul 31, 2012 · Revoked, canceled · Built 1943 · Jette Ariel CN4559YPiper PA-25-235 · S/N 25-4217Cancelled Jul 19, 2012 · Revoked, canceled · Built 1967 · Robinson Robert DBAN1014Aero Commander 680-F · S/N 680F-1244-125Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1963 · Kernick Morris DBAN6807JPiper PA-28-181 · S/N 28-7690399Cancelled May 8, 2012 · Exported to Costa Rica · Built 1976 · Coutches Robert H DBAN53498Cessna 172P · S/N 17274767Cancelled Apr 5, 2012 · Exported to Philippines · Built 1981N4940HCessna 152 · S/N 15284034Cancelled Mar 30, 2012 · Exported to Philippines · Built 1979N7463SSmith AEROSTAR 601 · S/N 61-0038-75Cancelled Oct 3, 2011 · Exported to Canada · Built 1969 · Skyview Aviation LLCN274NDPiper PA-28-161 · S/N 2842074Cancelled Sep 12, 2011 · Exported to Indonesia · Built 2000N358NDPiper PA-28-161 · S/N 2842186Cancelled Sep 12, 2011 · Exported to Indonesia · Built 2003N72735Cessna 120 · S/N 9914Cancelled Aug 2, 2011 · Expired dealer · Built 1946 · Anthony Aircraft IncN67035Beech C23 · S/N M-2235Cancelled Jul 27, 2011 · Expired dealer · Built 1980 · Raytheon Aircraft Services IncN200DTAero Commander 680W · S/N 1763-9Cancelled Jun 28, 2011 · Registration pending, canceled · Built 1968N733HECessna 172N · S/N 17268300Cancelled Jun 11, 2010 · Exported to Argentina · Built 1976 · Vorne Daryl AN24342Cessna 152 · S/N 15280227Cancelled Apr 13, 2010 · Exported to Philippines · Built 1977 · Flying Vikings Inc
Back to Hayward, CA