OpenAirDocs.org
Riverside, CA

Cancelled registrations · 287

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

N432CAConstrucciones Aeronauticas C-212-200 · S/N 284Cancelled Mar 31, 1982 · Built 1981 · American Casa Distributor IncN434CAConstrucciones Aeronauticas C-212-200 · S/N 288Cancelled Mar 31, 1982 · American Casa Distributor IncN37729Bell Kitz Kopters 47D1 · S/N 444Cancelled Mar 22, 1982 · Built 1976 · Orco Aviation Inc DBA Riverside Air ServiceN37730Bell Kitz Kopters 47D1 · S/N 767Cancelled Mar 22, 1982 · Orco Aviation Inc DBA Riverside Air ServiceN14117Appleby FOKKER DR-1 REPLICA · S/N AA101Cancelled Jan 21, 1982 · Administratively canceled · Appleby James SN7081JBell 47G-5 · S/N 25029Cancelled Oct 15, 1981 · City Of Riverside Patrol Div. Helicopter UnitN40317Hiller UH-12E · S/N 5162Cancelled Jul 30, 1981 · Exported to Japan · Built 1981 · California Aircraft ServiceN4031VHiller UH-12E · S/N 5166Cancelled Jul 30, 1981 · Exported to Japan · Built 1981 · California Aircraft ServiceN6911GCessna 150L · S/N 15072411Cancelled Sep 23, 1980 · Metal Units Inc DBA Dons Flying ServiceN7647FPiper PA-32R-300 · S/N 32R-7780070Cancelled Aug 5, 1980 · SwwN73724Cessna 172 · S/N 172-67628Cancelled Jun 14, 1978 · Exported to Canada · Pareflite IncN54727Piper PA-31-350 · S/N 317405250Cancelled Nov 16, 1977 · Orco Aviation Inc & Francis Warren M JrN51030Cessna 150J · S/N 15069717Cancelled Jul 7, 1977 · Metal Units Inc DBA Dons Flying ServiceN24749Piper J3C-65 · S/N 3416Cancelled Apr 26, 1977 · Exported to Australia · Appleby James SN21339Cessna 182P · S/N 18261572Cancelled Apr 25, 1977 · Richard A HayesN9723ACessna 170A · S/N 19184Cancelled Nov 15, 1976 · Griffin Marion DN3481RCessna 182 · S/N 182-58781Cancelled Oct 1, 1976 · Built 1968 · Huffman Clarence H/Huffman Gloria MN47XCessna C-165 · S/N 562Cancelled Jun 15, 1976 · MccartydeanN13ASAerotek PITTS S-2A · S/N 2002Cancelled Jun 30, 1975 · Built 1971 · Scholl Art DBA Art Choll AviationN26271Evans STEEN SKYBOLT · S/N E-1Cancelled Jun 27, 1975 · Exported to Mexico · Evans George WN56135Boeing A75 · S/N 75-256Cancelled Jun 10, 1975 · Riverside Aircraft CoN7382KPiper PA-20 · S/N 20-291Cancelled Jun 10, 1975 · Roark Donald RN9016RBeech D18S · S/N A-974Cancelled Jun 10, 1975 · Exported to Mexico · Metal United Inc DBAN54438Piper PA-28-180 · S/N 287405054Cancelled May 9, 1975 · Orco Aviation IncN2528NCessna 140 · S/N 12784Cancelled Dec 10, 1974 · Stamm Norman PN8294ACessna 170B · S/N 25146Cancelled Sep 5, 1974 · Grieve Air ServiceN6685GCessna 150L · S/N 15072185Cancelled Jul 5, 1974 · Jane LamarN2925UCessna 172D · S/N 17250525Cancelled May 23, 1974 · Cornblatt Gerald EN3849BBeech F35 · S/N D-4119Cancelled Apr 23, 1974 · Riverside Aero Club IncN44JVButler AEROSTAR 601 · S/N 61-0059-112Cancelled Jun 22, 1973 · Built 1970 · Economotors Incet AlN2777BFunk Bensen 83P · S/N 6166Cancelled Jun 21, 1973 · Funk Robert JN22DGGarth-Bensen RKG B-8M · S/N 007Cancelled May 29, 1973 · Robert K GarstN8964JPiper PA-28-180 · S/N 28-2986Cancelled May 24, 1973 · Eugene Hale FenwickN2962SCessna 150 · S/N 5066862Cancelled Apr 26, 1973 · Metal Units IncN8691RSchweizer SGU 2-22E · S/N 165Cancelled Jul 24, 1972 · Regents Of The University Of CaliforniaN95031Taylorcraft BC12-D · S/N 9431Cancelled May 11, 1972 · Grieve Air ServiceN42333Piper J3C-65 · S/N 14583Cancelled Jan 26, 1972 · Built 1945 · Grieve Floyd GN4412UCessna 150D · S/N 15060412Cancelled Jan 25, 1972 · Built 1964 · Metal Units Inc DBA Don'S Flying ServiceN2147GCessna 182A · S/N 51447Cancelled Dec 1, 1971 · Haynes JackN3566LCessna 150F · S/N 15062366Cancelled Sep 23, 1971 · Mcgill James BN3859Stephens Akro STANDARD · S/N 001Cancelled Jan 4, 1971 · Built 1967 · Ritchie Margaret FN44225Taylorcraft BC12-D1 · S/N 10025Cancelled Jan 4, 1971 · Built 1946 · Cruse Albert LN9713ZMiscellaneous - Amateur ETC CATEGORY · S/N S6Cancelled Jan 4, 1971 · Built 1961 · Hesse EmilN8540EChampion 7FC · S/N 7FC-346Cancelled Dec 7, 1970 · Nuggs Flying ServiceN8847TCessna 182C · S/N 52747Cancelled Aug 21, 1970 · Kelley Hal EN1205NBoeing B75N1 · S/N 75-8033Cancelled Aug 10, 1970 · Riverside Aircraft CoN4623VBeech 35 · S/N D-1025Cancelled Jun 29, 1970 · Madariaga OscarN68701Fairchild PT-26 · S/N T42-4149Cancelled Jun 26, 1970 · Oscar MadariagaN8982ABeech C35 · S/N D-2734Cancelled Oct 7, 1969 · Motorola IncN5012Cessna 180H · S/N 18051720Cancelled Sep 3, 1968 · Exported to Brazil · Hesse Emil C
Back to Riverside, CA