OpenAirDocs.org
Goleta, CA

Cancelled registrations · 66

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

N340AACessna T310Q · S/N 310Q0206Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1970 · Accurate Aviation GroupN94442Douglas DC3 · S/N 26454Cancelled Nov 21, 2017 · Revoked, canceled · Built 1943 · Atlas Acft CorpN94443Douglas DC3 · S/N 32885Cancelled Nov 21, 2017 · Revoked, canceled · Built 1944 · Atlas Acft CorpN9688UGrumman American Avn. AA-1C · S/N AA1C0099Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Cotton Victoria AN7203XCessna 150A · S/N 15059303Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1961 · Robbins Brick AN2266YCessna 177 · S/N 17700066Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1967 · Lowenstine Mark RN28870Grumman American Avn. AA-5B · S/N AA5B0875Cancelled Sep 26, 2013 · First renewal notice · Built 1978 · Santa Barbara Flying ClubN444KSSchooley Kenneth L AVID FLYER · S/N 235Cancelled Jun 27, 2013 · Sale reported, canceledN7417SBalloon Works FIREFLY 7 · S/N F7-232Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Sipes Kenneth ON625ABBono Anthony J AVID FLYER · S/N 273Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1989N7798PPiper PA-24-250 · S/N 24-3016Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1962 · 7798 P CompanyN7156SCessna 150H · S/N 15067856Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1967 · Whitehead Ronald DBAN4503Iehl William R AMF S14F · S/N 532Cancelled Apr 26, 2013 · Sale reported, pending cancellation · Built 1996N96348Hayes TERMITE-1 · S/N 1Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1977N35994Semco Balloon MARK V · S/N SEM155Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1974N11HBAerospatiale SA316B ALOUETTE III · S/N 1826Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1970N52PJ & J Special 1A · S/N 001Cancelled Aug 14, 2012 · Revoked, canceled · Built 1961 · Burkett Frank GN222MBeech H35 · S/N D-5128Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1951N728MTSampson Thomas E SAMPSON - RV9A · S/N 90535Cancelled Nov 29, 2011 · Exported to South Africa · Built 2006 · Montee Tracy DrakeN758BJCessna R172K · S/N R1722962Cancelled Jan 20, 2010 · Triennial form not returned · Built 1978 · Santa Barbara Flying Club IncN281HBeech C-45H · S/N AF-694Cancelled Oct 14, 2009 · Registration revoked · Barnett Matthew RN2144XCessna 337 · S/N 337-0044Cancelled Jun 29, 2007 · Second triennial mailing, no response · Built 1965 · Cedar Terrance EN10172Hiller UH-12A · S/N 233Cancelled Oct 5, 2004 · Second triennial mailing, no response · Built 1961 · Air Care InternationalN1030DHorvath Nelson J SCORPION TOO · S/N 0001Cancelled Oct 5, 2004 · Triennial form not returned · Built 1985 · Air Care International IncN4993TCessna 411 · S/N 411-0193Cancelled Oct 5, 2004 · Second triennial mailing, no response · Built 1966 · Air Care International IncN9072RGyaki Joseph A J3 · S/N 3Cancelled Oct 5, 2004 · Triennial form not returned · Air Care International IncN105ABBridges Austin K FALCON XP · S/N 600207Cancelled Sep 22, 2004 · Second triennial mailing, no response · Air Care International IncN35PMVander Velde Kent M MURPHY REBEL · S/N 0164RCancelled Sep 22, 2004 · Triennial form not returned · Built 1994 · Air Care International IncN429WCCox Walter W DRAGONFLY · S/N 001Cancelled Sep 22, 2004 · Second triennial mailing, no response · Air Care International IncN4679Sud SA316B ALOUETTE III · S/N 1902Cancelled Sep 22, 2004 · Triennial form not returned · Built 1971 · Air Care International IncN504MTLawley Rodney R MINI 500 · S/N 254Cancelled Sep 22, 2004 · Triennial form not returned · Air Care International IncN7816ZCessna 150C · S/N 15059916Cancelled Sep 22, 2004 · Second triennial mailing, no response · Built 1963 · Air Care International IncN790GSSmith Gregory R AVID STOL HAULER · S/N 790Cancelled Sep 22, 2004 · Triennial form not returned · Built 1994 · Air Care International IncN531LBBaker Larry BARNETT JB42 · S/N 257Cancelled May 16, 2001 · Triennial form not returned · Air Care International IncN80981Cessna 172M · S/N 17266824Cancelled May 5, 1999 · Triennial form not returned · Howar Beth G DBAN5706NRaven S55A · S/N S55A644Cancelled Sep 16, 1995 · Triennial form not returned · Hanson Christan EN737NXCessna 172N · S/N 17269556Cancelled Mar 10, 1992 · Exported to Guatemala · Santa Barbara Flying ClubN528CACessna 152 · S/N 15279693Cancelled Jul 30, 1991 · Second triennial mailing, no response · Phillips Mark L FN4633XCessna 150G · S/N 15064683Cancelled Apr 22, 1991 · Exported to Australia · Vadnais Kenneth GN1267DCessna 170A · S/N 19843Cancelled Dec 7, 1990 · Exported to Australia · Meester Dianne LN49548Boeing KC-97G · S/N 53-280Cancelled Nov 20, 1984 · Exported to France · Tracor Aviation IncN1890HCessna 310C · S/N 35990Cancelled Jul 11, 1984 · Administratively canceled · Clarkes Osewez NeedleN2958FHandley Page HP-137 MK1 · S/N 201Cancelled Jan 10, 1984 · Administratively canceled · Apollo Airways IncN56SBBeech C23 · S/N M-2169Cancelled Nov 12, 1982 · Santa Barbara Aviation IncN31333Boeing KC-97G · S/N 53278Cancelled Oct 5, 1982 · Tracor Aviation IncN7917Vaughn HOMEBUILT AMPHIBIAN · S/N REV098Cancelled Oct 5, 1977 · Vaughn Rondall EN112ASAero Spacelines 377MGT-1 · S/N 0002Cancelled Oct 9, 1975 · Aero Spacelines IncN9597DPiper PA-22-160 · S/N 22-6505Cancelled May 6, 1975 · Wiley Richard RN4491Beech C-50 · S/N CH-335Cancelled Apr 2, 1975 · Exported to Philippines · Lingenfelter Richard L Et AlN6067BCessna 182A · S/N 34067Cancelled Sep 14, 1973 · Jones Paul A
Back to Goleta, CA