OpenAirDocs.org
Rialto, CA

Cancelled registrations · 70

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

N8090WPiper PA-28-180 · S/N 28-2181Cancelled Jan 28, 2019 · Revoked, canceled · Built 1965 · Edwards Samuel JN6467TCessna 150 · S/N 17867Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1960 · Cendejas AgustinN33THCessna 402B · S/N 402B1039Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Ortiz Angel Tomas MaldonadoN62636Schweizer TG3A · S/N 39Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Kensinger William AN6515NBellanca 14-13-3 · S/N 1636Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1949 · Belew Loye TN54014Ryan Aeronautical ST3KR · S/N 2231Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1942 · Miro Aviation IncN58164Hughes 269C · S/N 940348Cancelled Nov 25, 2014 · Third renewal notice · Japan Aircraft Sales And Leasing IncN9399Sikorsky UH-19D · S/N 56-1548Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1971 · Loma Linda University Medical CenterN8973ABeech C35 · S/N D-2727Cancelled May 14, 2014 · Built 1951 · Buhl Jack AN5334XShinn Darrell W BENSEN BM 8 · S/N 1Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Shinn Darrell WN8942CPiper PA-22-150 · S/N 22-1535Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1953 · Rahhal Mark AN37751Siegenfield Harold KR-2 · S/N 3498Cancelled Jul 10, 2013 · Sale reported, canceledN415MABell 222U · S/N 47568Cancelled Jun 11, 2013 · Built 1988 · Mercy Air Service IncN8986FHughes 269C · S/N 930239Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1973 · Japan Aircraft Sales And Leasing IncN8876WPiper PA-28-235 · S/N 28-10433Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1964 · Moore Steven EN7802SBell 47G-5 · S/N 7856Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1967 · Aerohead Helicopters IncN58329Hughes 269C · S/N 290769Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1979 · California Avn Research Info IncN51862Texas Helicopter OH-13H/M74A · S/N 79-028Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1979 · Aerohead Helicopters IncN5052BHughes Helicopters HUGHES 369D · S/N 611009DCancelled Nov 29, 2012 · Sale reported, pending cancellation · Built 1981N2498BBell 47G-2 · S/N 1482Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1956 · Aerohead Helicopters IncN50627Stinson 10A · S/N 7787Cancelled Aug 10, 2012 · Revoked, canceled · Built 1941 · Kelley Marion LN3373GUnknown model · S/N 1DHCancelled Jun 13, 2011 · Revoked, canceled · Built 1962 · Henopp David EN416MABell 222UT · S/N 47526Cancelled Oct 21, 2010 · Triennial form not returned · Built 1985 · Mercy Air Service IncN86242Cessna T337D · S/N 337-1126Cancelled Apr 27, 2010 · Triennial form not returned · Built 1969 · Benart Donald AN27730Stinson 10A · S/N 7662Cancelled Jul 14, 2009 · Registration revoked · Built 1940 · Kelley Marion LN137BWRockwell International 690B · S/N 11446Cancelled Dec 12, 2006 · Exported to Canada · Built 1977 · Kti IncN130JSSchweizer 269C · S/N S1571Cancelled Aug 28, 2006 · Triennial form not returned · Built 1991 · Western Operations IncN626SBMcdonnell Douglas Helicopter 600N · S/N RN024Cancelled Aug 4, 2005 · Exported to Canada · Built 1997 · San Bernardino County Sheriffs DepartmentN45012Hughes 269C · S/N 900962Cancelled Mar 11, 2005 · Triennial form not returned · Built 1980 · Western OperationsN625SBMcdonnell Douglas Helicopter 600N · S/N RN033Cancelled Dec 1, 2004 · Triennial form not returned · Built 1998 · San Bernardino County Sheriffs DepartmentN350JTDehavilland TIGER MOTH DH 82A · S/N 827Cancelled May 27, 2003 · Exported to Canada · Built 1942 · Scholl Judith A DBAN803SBMcdonnell Douglas Helicopter 369E · S/N 0211ECancelled Dec 8, 2000 · Exported to New Zealand · County Of San BernardinoN16284Piper PA-28-140 · S/N 287325232Cancelled Apr 25, 1996 · Stagnitto Philip RN822SBCessna 210K · S/N 21059424Cancelled Nov 4, 1994 · Exported to South Africa · County Of San BernardinoN6115PPiper PA-24 · S/N 241215Cancelled Aug 3, 1994 · Triennial form not returned · Kinney Elmer LN62844Barratt Don C ADVANCED AVN CARRERA · S/N CR027447Cancelled Feb 4, 1994 · Triennial form not returned · Barratt Don CN94150Cessna 152 · S/N 15285609Cancelled Mar 9, 1993 · Exported to Germany · California Aviation Research InfoN24977Cessna 152 · S/N 15280486Cancelled Aug 20, 1992 · California Avn Research InfoN8432KPiper PA-28-161 · S/N 288116309Cancelled Jun 3, 1992 · Triennial form not returned · Art Scholl Aviation IncN49796Cessna 152 · S/N 15281320Cancelled Jan 3, 1991 · California Aviation Research InfoN228DMPiper PA-31-350 · S/N 31-7952146Cancelled Mar 21, 1990 · Exported to Australia · Built 1979 · Barnett Investments IncN78EVFalkenthal Robert J VARIEZE · S/N RAF-1803Cancelled Jul 30, 1985 · Falkenthal Robert JN8853BCessna 172 · S/N 36553Cancelled Dec 7, 1983 · Administratively canceled · Scholl Art DBAN71PGallaher Glenn O STITS-GALLAHER SA6B · S/N 106Cancelled Nov 17, 1983 · Force Howard LN4386SSikorsky S58E · S/N 581648Cancelled Nov 12, 1980 · Western Helicopters IncN9134FHughes 369HS · S/N 330459SCancelled Aug 24, 1978 · Exported to New Zealand · Western Helicopters IncN2684CCessna 310 · S/N 35084Cancelled Jul 8, 1977 · Ashford Ben TN234CFCessna 150J · S/N 15069432Cancelled Jul 31, 1975 · Exported to Canada · Evans Gwillym EN9350LAmerican AA-1A · S/N AA1A-0050Cancelled May 5, 1975 · J&R Flight ServiceN73212Bell 47G-3B · S/N 2748Cancelled Dec 5, 1974 · Western Helicopters Inc
Back to Rialto, CA