OpenAirDocs.org
Redding, CA

Cancelled registrations · 141

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

N5723BCessna 182 · S/N 33723Cancelled Jan 10, 1994 · Wilber Michael CN917JBBigham Jack L GLASAIR I RG · S/N 007392Cancelled Oct 1, 1993 · Exported to Botswana · Bigham Jack LN27127Moore Craig D SONERAI I · S/N 428Cancelled Apr 14, 1993N790TCessna 182P · S/N 18262370Cancelled Nov 19, 1990 · Triennial form not returned · Timbuck 2 Flying Club IncN5160YPiper PA-23-250 · S/N 27-2200Cancelled Aug 17, 1982 · Winberry Development Company IncN6022XMooney M20A · S/N 1610Cancelled May 7, 1981 · Williams William B And Thexton Ronald GN22NACessna P206A · S/N P-206-0171Cancelled Dec 22, 1976 · Red Barons Flying ClubN12024Cessna 172M · S/N 172-61794Cancelled Feb 10, 1976 · Exported to Canada · Shasta Aviation IncN9171ACessna 170A · S/N 19362Cancelled Sep 26, 1974 · H And H Flying Service IncN5660FAlon A2 · S/N A-160Cancelled Apr 8, 1974 · Lockwood Robert M DBA Enterprise Sky ParkN22002Cessna T210L · S/N 21059700Cancelled Mar 7, 1974 · Exported to Canada · H & H Air Service Inc DBA Cal Todd AviationN34249Cessna 177B · S/N 177-01733Cancelled Oct 1, 1973 · Beck Edward TN111SCBell HTL-4 · S/N 128888Cancelled Jan 3, 1972 · Shasta-Tehama-Trinity Joint Junior CollegeN76604Cessna 140 · S/N 11044Cancelled Jun 23, 1971 · Bodenhauer PaulN3013ZPiper PA-22-150 · S/N 22-6964Cancelled Apr 19, 1971 · Robert D StrantzN6044DPiper PA-22-150 · S/N 22-4697Cancelled Dec 23, 1970 · Sierra Cascade Land Co IncN6042KRepublic RC-3 · S/N 217Cancelled Nov 16, 1970 · Powers Norman DN7692WPiper PA-28-180 · S/N 28-1685Cancelled Jun 25, 1970 · Shasta Aviation IncN7945TCessna 175A · S/N 56645Cancelled Jun 25, 1970 · Landles Thomas AN51144Cessna 150J · S/N 15069792Cancelled Jun 8, 1970 · Built 1968 · H & H Flying Service IncN4066DCessna 182A · S/N 34766Cancelled Oct 17, 1969 · Clair A Hill & AssociatesN5716PPiper PA-24-250 · S/N 24-790Cancelled Jul 1, 1967 · Shasta Flight ServiceN2510PPiper PA-22-150 · S/N 22-2872Cancelled Aug 3, 1966 · No 126 Aero Flying ClubN24601Piper J3C-65 · S/N 3289Cancelled May 22, 1965 · Teuscher RogerN97912Stinson 108-1 · S/N 108-912Cancelled May 22, 1965 · Roger D TeuscherN5215ZPiper PA-22-108 · S/N 22-8889Cancelled Apr 28, 1965 · Shasta Aviation IncN27576Taylorcraft BC12-65 · S/N 2217Cancelled Nov 14, 1963 · Built 1940 · Smith Arthur MN1335VBeech D17S · S/N 6752Cancelled Apr 18, 1961 · Bingham Motors IncN57461Cessna T-50 · S/N 6466Cancelled Apr 7, 1961 · Weaver FranklinN9187DPiper PA-22-160 · S/N 22-6245Cancelled Nov 20, 1959 · Exported to Australia · Built 1958 · Pierce Harrison M JrN2048NCessna 140 · S/N 12284Cancelled Feb 1, 1959 · Fleming Glenn MN96862Taylorcraft BC12-D · S/N 9162Cancelled Jul 25, 1957 · Exported to Canada · Charles James DN53360Fairchild PT-26 · S/N FV445Cancelled Dec 9, 1955 · Built 1943 · Roe Stanley RN87743Piper J-3C · S/N 15401Cancelled Oct 13, 1955 · Downard Flying ServiceN3145KCulver V · S/N V2-510Cancelled Jan 14, 1955 · Sones Max TN1099DCessna 190 · S/N 7711Cancelled Dec 22, 1953 · H & H Flying Serivce IncN8860KStinson 108-1 · S/N 108-1860Cancelled Nov 19, 1953 · Ingle Chester BN2075NCessna 140 · S/N 12311Cancelled Feb 27, 1951 · Hawkey Don HN16561Aeronca LB · S/N 2048Cancelled Apr 16, 1948 · Built 1936 · Hemsted DonN4892International F-17 · S/N 32Cancelled Apr 29, 1938 · Birkland JacobN7857Butler BLACK HAWK · S/N 100Cancelled Jul 22, 1935 · Farley George R
Back to Redding, CA