Chico, CA

Cancelled registrations · 176

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

N8491JBrooke Walter L B-10 · S/N 310Cancelled Feb 5, 1996 · Triennial form not returned · Brooke Walter L JrN1997Boeing 727-23 · S/N 19128Cancelled Jan 17, 1996 · Aero Union CorporationN4989PDouglas C-54G · S/N 45629Cancelled Aug 26, 1995 · Triennial form not returned · Aero Union CorporationN152RERotec Engineering ROTEC RALLY 3 · S/N 25276Cancelled Dec 22, 1994 · Triennial form not returned · Alldrin Loren KN924AULockheed P-3A · S/N 151359Cancelled Feb 4, 1994 · Triennial form not returned · Aero Union CorporationN8540Vertol 42A · S/N 528623Cancelled Feb 12, 1993 · Triennial form not returned · Aero Union CorporationN48082Boeing-Vertol CH-21C · S/N 5115886Cancelled Aug 5, 1992 · Triennial form not returned · Aero Union CorporationN67109Douglas C54B-DC · S/N 10459Cancelled Aug 26, 1991 · Triennial form not returned · Aero Union CorporationN58FBMcnary Floyd D BOWERS FLYBABY 1-A · S/N 7042Cancelled Apr 11, 1991 · Triennial form not returned · Mcnary Floyd DN5586MGrumman S-2A · S/N 136442Cancelled Aug 16, 1984 · Exported to Canada · Reagan EnterprisesN55872Grumman S-2A · S/N 136510Cancelled Aug 16, 1984 · Exported to Canada · Reagan EnterprisesN55874Grumman US-2C · S/N 136600Cancelled Aug 16, 1984 · Exported to Canada · Reagan EnterprisesN5587KGrumman S-2A · S/N 136465Cancelled Aug 16, 1984 · Exported to Canada · Reagan EnterprisesN55886Grumman S-2A · S/N 136717Cancelled Aug 16, 1984 · Exported to Canada · Reagan EnterprisesN5589MGrumman S-2A · S/N 147559Cancelled Aug 16, 1984 · Exported to Canada · Reagan EnterprisesN44770Grumman S-2B · S/N 136409Cancelled Jun 27, 1984 · Exported to Canada · Reagan Roy DN4477ZGrumman S-2B · S/N 136552Cancelled Jun 27, 1984 · Exported to Canada · Reagan Roy DN39195Hansen Christian C TEENIE TWO · S/N 547775263Cancelled May 1, 1984 · Built 1983 · Hansen Kip CN49379Boeing A75 · S/N 75796Cancelled Dec 12, 1983 · Reagan Roy DN25776Douglas C-117D · S/N 50782Cancelled Jun 16, 1983 · Exported to Canada · Built 1952 · Richards Leroy WN3230RGrumman S-2A · S/N 136504Cancelled Feb 17, 1983 · Exported to Canada · Built 1982 · Reagan EnterprisesN3229AGrumman S-2A · S/N 136448Cancelled Feb 15, 1983 · Exported to Canada · Built 1982 · Reagan EnterprisesN3231HGrumman S-2A · S/N 136451Cancelled Feb 15, 1983 · Exported to Canada · Built 1982 · Reagan EnterprisesN3373FDouglas C54G-DC · S/N 36061Cancelled Oct 1, 1982 · Built 1945 · Aero Union CorpN6883CPiper PA-28-161 · S/N 28-7816438Cancelled Aug 31, 1982 · Chico Aviation IncN4989NDouglas C54G-DC · S/N 45596Cancelled Apr 21, 1982 · Exported to Canada · Aero Union CorpN3303FDouglas C54G-DC · S/N 35988Cancelled May 8, 1981 · Exported to Canada · Built 1945 · Aero Union CorpN4958PDouglas C54G-DC · S/N 36090Cancelled May 8, 1981 · Exported to Canada · Aero Union CorporationN1463UCessna 172M · S/N 17267130Cancelled Sep 30, 1978 · Built 1976 · Owens FrederickN66PBBartlett ICARUS II · S/N R29Cancelled Jul 21, 1977 · Bartlett Philip EN1451RGrumman American Avn. AA-1B · S/N AA1B-0551Cancelled Jul 14, 1977 · Built 1975 · Hyman Dennis DBAN42575Cessna 182L · S/N 18259086Cancelled Aug 26, 1976 · Built 1968 · Hennigan Robert D JrN55745Piper PA-28-180 · S/N 287305458Cancelled May 25, 1976 · Lock Harold K JrN3155YCessna 182E · S/N 18254155Cancelled Jan 13, 1975 · Mid Valley Flying Service IncN4820EDouglas A-26 · S/N 28017Cancelled Nov 25, 1974 · Exported to Canada · Aero Union CorporationN4312CChampion 7EC · S/N 7EC-313Cancelled Oct 11, 1974 · Devine Harold B Et AlN91356Douglas B-26C · S/N 44-34344Cancelled Sep 5, 1974 · Exported to Canada · Built 1945 · Aero Union CorpN6838DDouglas A-26B · S/N 28719Cancelled Jul 26, 1974 · Aero Union CorpN9083ZGrumman TBM-3 · S/N 53492Cancelled Nov 15, 1973 · Aero Union CorpN8938XCessna 182D · S/N 18253338Cancelled Nov 6, 1973 · Exported to Canada · Karr James HN9374JPiper PA-28-180 · S/N 28-3473Cancelled Jan 5, 1973 · Butte Flying Club IncN7213TCessna 172A · S/N 46813Cancelled Jun 19, 1972 · Guice John T JrN330WCDouglas B-26 · S/N 44-35456Cancelled Feb 17, 1972 · Exported to Canada · Aero Union CorporationN9324ZBoeing B-17G · S/N 44-83542Cancelled Sep 20, 1971 · Aero Union CorpN4901LPiper PA-28-180 · S/N 28-4268Cancelled Jul 21, 1971 · Perry Robert SN86469Douglas B-26C · S/N 43-22511Cancelled Jul 8, 1971 · Aero Union CorpN91317Douglas B-26C · S/N 41-39398Cancelled Mar 18, 1971 · Exported to Canada · Aero Union CorpN8395HDouglas A-26B · S/N 44-34607Cancelled Mar 12, 1971 · Exported to Canada · Built 1945 · Aero Union CorpN44955Naval Aircraft Factory N3N-3 · S/N 4375Cancelled Jan 9, 1971 · Chico Aerial Applicators IncN6161PPiper PA-24 · S/N 24-1262Cancelled Jan 16, 1970 · North Valley Flying Club Inc
Back to Chico, CA