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.

N6186MStinson 108-3 · S/N 108-4186Cancelled Aug 20, 2012 · Built 1948 · Flabob Airport LLCN2325ZBeech 23 · S/N M-24Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1962N5144GBeech UC-45J · S/N 45-1124Cancelled Aug 13, 2012 · Revoked, canceled · Hayes Richard AN479CStinson 108-2 · S/N 108-3479Cancelled Aug 7, 2012 · Revoked, canceled · Built 1947 · Kottler SidneyN12186Cessna 172M · S/N 17261869Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1973 · Moretti Dick DBAN4488FRobinson Helicopter R44 II · S/N 13264Cancelled Jun 4, 2012 · Exported to China · Aw Sky AviationN45WKCessna 182T · S/N 18281927Cancelled Feb 13, 2012 · Exported to Canada · Built 2007 · Kienle WalterN8398KStinson 108-1 · S/N 108-1398Cancelled Apr 12, 2011 · Expired dealer · Built 1946 · New Horizons AviationN14257Deschamps STARDUSTER TOO SA300 · S/N 1Cancelled Mar 7, 2011 · Sale reported, pending cancellation · Built 1970N5362MCessna 152 · S/N 15284562Cancelled Oct 12, 2010 · Exported to Bangladesh · Built 1980 · Killingsworth Kevin TN8023ZCessna U206 · S/N U206-0423Cancelled Jun 10, 2009 · Exported to Mexico · Built 1965 · Jeromes Financial Services IncN733QPCessna 172N · S/N 17268468Cancelled May 8, 2008 · Exported to Canada · Built 1976 · Conveying Equipment Co Inc DBAN8989EPiper PA-28-181 · S/N 2843111Cancelled Oct 5, 2007 · Exported to Australia · Built 1997 · Winship Stake & Lath IncN9YCMcclanahan STITS PLAYMATE SA-11 · S/N 162Cancelled Jul 21, 2004 · Built 1973 · Stits David LN24110Bucy Allen ADB-1 · S/N 2221947Cancelled May 8, 2003 · Triennial form not returned · Built 1996 · Bucy Allen DN62620Aklufi Joseph S TUKAN TRIKE · S/N 100547Cancelled Nov 27, 2002 · Triennial form not returned · Built 1999 · Aklufi Joseph SN7824ROhletz Robert VARIEZE · S/N 42Cancelled Sep 4, 2002 · Built 1979 · Ohletz RobertN471DFCessna M337B · S/N 337M0246Cancelled Jul 29, 2002 · Built 1968 · Economic Development Agency Of Riverside CoN475DFCessna M337B · S/N 337M0343Cancelled Jul 29, 2002 · Built 1968 · Economic Development Agency Of Riverside CoN77KRRhea Larry M KR-2 · S/N 6271Cancelled Jun 2, 2000 · Rhea Larry MN1AGBeech F35 · S/N D-4263Cancelled Mar 10, 2000 · Triennial form not returned · Essex Jack GN67339Cessna T-50 · S/N 3844Cancelled Nov 10, 1999 · Second triennial mailing, no response · Rea David JN8609JCessna 150G · S/N 15066509Cancelled Nov 30, 1998 · Triennial form not returned · Mayes Steven JN77KRSchendel KR-2 · S/N 2835Cancelled Jul 2, 1997 · Rhea Larry MN66343Beech C23 · S/N M2206Cancelled Feb 12, 1997 · Triennial form not returned · Riverside Air ServiceN37324Cessna 340A · S/N 340A0348Cancelled Jan 24, 1997 · Triennial form not returned · Gilbert Malcolm SN2182RCessna 182G · S/N 18255382Cancelled Jun 28, 1996 · Raffy Thomas MN7056YGraham Joseph W VP-1 · S/N 01GRAHAM01Cancelled Jun 7, 1995 · Triennial form not returned · Graham Joseph WN2157VHelton George D KOLB TWINSTAR MK II · S/N TS205Cancelled Mar 30, 1995 · Triennial form not returned · Helton George DN172HWCessna 172H · S/N 17255787Cancelled Feb 16, 1995 · Triennial form not returned · Degregorio Orlando GN9466TCessna 210 · S/N 57266Cancelled Aug 11, 1994 · Triennial form not returned · Kurtz William CN8067ECessna 172N · S/N 17272125Cancelled Dec 7, 1993 · Triennial form not returned · Klamt Refrigeration IncN5797MCessna 402B · S/N 402B0359Cancelled Aug 11, 1993 · Exported to Mexico · Parflite IncN3496SCessna 182H · S/N 18255896Cancelled Mar 17, 1993 · Robinson Mark AN4374TPiper PA-34-200 · S/N 347250080Cancelled Mar 17, 1992 · Triennial form not returned · Mayes Steven JN9218QHammond Larry Robert SMITH SIDEWINDER · S/N 4053Cancelled Jan 3, 1992 · Second triennial mailing, no response · Hammond Larry RN90HSHolman H L/Sears H O HS 1 · S/N HS001Cancelled Dec 13, 1991 · Triennial form not returned · Holman Howard LN69010Cessna 152 · S/N 15282430Cancelled Apr 26, 1991 · Triennial form not returned · Parflite IncN6266TCessna 150E · S/N 15060966Cancelled Apr 25, 1991 · Triennial form not returned · Neal Randall LN5704MSherrett John R TIERRA I · S/N 100346Cancelled Mar 28, 1991 · Triennial form not returned · Sherrett John RN750ALClouse William C SA-750 · S/N 399Cancelled Mar 12, 1991 · Exported to Italy · Stolp Starduster CorpN61986Boeing A75N1 · S/N 75-2265Cancelled Jan 27, 1986 · Exported to Australia · Jackman DonN5628VPiper PA-32R-300 · S/N 32R7780348Cancelled Oct 29, 1984 · Orco Aviation IncN67210Bell TH-13T · S/N 3502Cancelled Aug 20, 1984 · City Of Riverside Disaster Preparedness OfficeN5052UCessna 206 · S/N 206-0052Cancelled Aug 29, 1983 · Pictorial Crafts IncN37631Knight Ralph E SKYBOLT · S/N 6233Cancelled May 23, 1983 · Knight Ralph EN29004Construcciones Aeronauticas CASA-212-200 · S/N 245Cancelled Jan 20, 1983 · Exported to Switzerland · American Casa Distributor IncN2478JCessna 150G · S/N 15065578Cancelled Jul 14, 1982 · Exported to Peru · Built 1966 · Burgdorff Theodore WN426CAConstrucciones Aeronauticas CASA-212-200 · S/N 244Cancelled Mar 31, 1982 · Built 1981 · American Casa Distributor IncN430CAConstrucciones Aeronauticas CASA-212-200 · S/N 270Cancelled Mar 31, 1982 · American Casa Distributor Inc
Back to Riverside, CA