OpenAirDocs.org
Red Bluff, CA

Cancelled registrations · 63

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 = 'RED BLUFF'
  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.

N35588Piper J5A · S/N 5-686Cancelled Aug 26, 2025 · Built 1941 · Cheek Joey FN65PJBell 206L-3 · S/N 51127Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1985 · P J Helicopters IncN806PJSikorsky UH-60A · S/N 79-23312Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Pj Helicopters IncN44FVSchempp-Hirth STANDARD CIRRUS · S/N V1Cancelled Dec 20, 2021 · Exported to Germany · Built 1969 · Griffin Nathan KN5088FAero Vodochody L-29C DELFIN · S/N 893144Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Taylor Peter LN58538Fairchild M-62A · S/N T424156Cancelled Jan 24, 2020 · Revoked, canceled · Built 1942 · Ellis Darrell RN37223Cessna 310R · S/N 310R0963Cancelled Mar 9, 2019 · Sale reported, canceled · Built 1977N357PJEurocopter AS 350 B3 · S/N 3608Cancelled Jan 17, 2019 · First renewal notice · Built 2002 · Helibro LLCN77BXMoxter Bobby L PITTS S1D · S/N MX1 61 72Cancelled May 31, 2018 · Sale reported, canceled · Built 2003N4683BCessna 180 · S/N 31581Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1955 · Taylor Peter LN8569JCessna 150G · S/N 15066469Cancelled Apr 6, 2018 · Revoked, canceled · Built 1967 · Brown Rex AN3294VBeech 35 · S/N D-745Cancelled Apr 5, 2018 · Revoked, canceled · Built 1947 · Atlas AeroN163PJHughes Helicopters HUGHES 369D · S/N 1068DCancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1982 · P J Helicopters IncN82GWWalston George THORP T-18 · S/N GW1Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1982 · Walston GeorgeN68PJBell 206B · S/N 3384Cancelled Jan 21, 2014 · First renewal notice · Built 1981 · P J Helicopters IncN205PJArrow Falcon Exporters UH-1H · S/N 64-13617Cancelled Nov 6, 2013 · Registration expired · Built 1964 · P J Helicopters IncN62PJMcdonnell Douglas Helicopter 369E · S/N 0535ECancelled Nov 6, 2013 · Registration expired · Built 1997 · P J HelicoptersN24624Beech A24R · S/N MC-137Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1972N2867DNorth American AT-6F · S/N 44-82300Cancelled Aug 19, 2013 · Sale reported, canceledN42282Davis Stephen B PTERODACTYL NFL · S/N 432Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Davis Stephen BN2409KParry Anthony Dean KR2 · S/N BUG104359Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 2000 · Parry Anthony DN7477TCessna 172A · S/N 47077Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1959 · Fette George LN212FNPicklesimer Andrew N HORNET SPECIAL · S/N 001Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 2007 · Picklesimer Andrew NN34NULaliberte Rene QUICKSILVER MX II · S/N 1735Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1983N68651Mcgills Stits SA3B · S/N P-203Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1963N6019JCessna A150L · S/N A1500319Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1972N12FDDal Porto BABY ACE D · S/N 007Cancelled Jul 24, 2012 · Registration expired, pending cancellation · Built 1970 · Wax William LN61PJHughes Helicopters HUGHES 369D · S/N 770162DCancelled May 2, 2012 · First renewal notice · Built 1977 · P J Helicopters IncN2036CBeech M35 · S/N D-6494Cancelled Jun 14, 2011 · Sale reported, pending cancellation · Built 1960N593BBruce Robert A RV-7A · S/N 71019Cancelled Mar 24, 2011 · Exported to Australia · Built 2008 · Bruce Robert AN19664Taylorcraft A · S/N 271Cancelled Jul 10, 2009 · Registration revoked · Built 1937 · Twiggs Allen Dale JrN6087WPiper PA-28-140 · S/N 28-20101Cancelled Oct 31, 2003 · Triennial form not returned · Built 1964 · Ditmars William RN4487DBeech G35 · S/N D-4612Cancelled Sep 5, 2002 · Built 1956 · Anderson Lawrence EN8249DScafido Vito ROTORWAY EXEC HELI · S/N 3720Cancelled Mar 22, 2001 · Sharp Jack DN10800Bell 206B · S/N 2910Cancelled Jul 22, 1996 · Triennial form not returned · P J Helicopters IncN8606FHughes Helicopters HUGHES 369D · S/N 370100DCancelled Jan 21, 1994 · P J Helicopters IncN2522WBeech B24R · S/N MC213Cancelled Dec 9, 1991 · Exported to Canada · Moulton Thomas KN2776MPiper PA-28R-201T · S/N 28R7803144Cancelled Jul 8, 1991 · Physical Therapy And Wellness CenterN140RMPiper PA-28-140 · S/N 287125229Cancelled Mar 26, 1991 · Triennial form not returned · Mueller Henry RN5787QMooney M20E · S/N 752Cancelled Nov 3, 1983 · Stoufer Robert MN67379Cessna 152 · S/N 15281795Cancelled Jan 14, 1983 · Fregin DanielN1066WBeech A36 · S/N E-414Cancelled Jan 13, 1978 · Built 1973 · L T Anderson Construction CompanyN4663YPiper PA-25-235 · S/N 25-4387Cancelled Jul 21, 1975 · Built 1967 · Gunsauls Philip RN68109Consolidated Vultee BT-13 · S/N 7988Cancelled Sep 11, 1974 · Nor Cal Para-RescueN5295QCessna 150L · S/N 15073195Cancelled Jun 20, 1974 · Shepherd Carl L & Shepherd Prentice KN10386Schweizer SGS 1-26A · S/N 117Cancelled Dec 3, 1973 · Richard PughN1439QCessna 150L · S/N 150-72739Cancelled May 22, 1973 · Martin WesN7719CDouglas B-26 · S/N 43-22392Cancelled Sep 10, 1970 · Aero Atlas IncN6663CBeech AT-11 · S/N 4236838Cancelled Jun 26, 1970 · P And B Aviation IncN56WBeech A35 · S/N D-2043Cancelled Apr 29, 1970 · Built 1949 · Birdsong N
Back to Red Bluff, CA