OpenAirDocs.org
Ontario, CA

Cancelled registrations · 116

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

N7399SDJI PHANTOM 2 · S/N BC051617055253Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Stearns Conrad & Schmidt Consulting Engrs Inc DBAN109EXAgusta A109S · S/N 22145Cancelled Nov 30, 2021 · First renewal notice · Built 2009 · Prime Healthcare Air Transportation LLCN61ASSzybowcowy Zaklad Doswiadczaln 41A JANTAR STANDARD · S/N B-877Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1978 · Cutshaw William JN1617FCessna 172H · S/N 17255012Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1966N57BEIsrael Aircraft Industries 1124A · S/N 428Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1985 · Cinco Air Charter LLCN67649Cessna 152 · S/N 15281961Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1978 · Jimenez Carlos AN1332EAeronca 7AC · S/N 7AC-4893Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1946 · Ringle Harvey T JrN76549Cessna 140 · S/N 10985Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Olds Lawrence EN810SGGregg Steven M GREGG 1 · S/N GREGG-1Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1997 · Gregg Steven MN68745Consolidated PBY-5A · S/N 1627Cancelled Feb 4, 2017 · Revoked, canceled · So Cal Arcft CorpN8465LCessna T210L · S/N 21060635Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1975N868DSGulfstream Aerospace G1159B · S/N 123Cancelled Dec 11, 2014 · Third renewal notice · Built 1973 · World Jet IncN712ABFairchild F-27A · S/N 91Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Air Cortez International IncN86453Cessna 337E · S/N 33701200Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1970 · Inland Aircraft ServiceN711SMBeech C18S · S/N 5794Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1943 · Bailey Charles MN23FVGlasflugel KESTREL · S/N 19Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1969 · Davis Ray FN68743Consolidated PBY-5A · S/N 1787Cancelled Nov 12, 2013 · Revoked, canceled · So Cal Arcft CorpN68758Consolidated PBY-5A · S/N 46637Cancelled Nov 12, 2013 · Revoked, canceled · So Cal Arcft CorpN68769Consolidated PBY-5A · S/N 1822Cancelled Nov 12, 2013 · Revoked, canceled · So Cal Arcft CorpN957DWStinson 10A · S/N 7957Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1942 · N170r IncN41555Piper PA-28-151 · S/N 28-7415267Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1974 · Peterson Gregory RN2708BFairchild F-27J · S/N 98Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1963 · Air Cortez International IncN9946ACessna 170A · S/N 19306Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1950 · Perlas Paul J Co OwN54540Wall Wesley W QUICKIE · S/N 100Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1981 · Aguilar GilN2569GCessna 182B · S/N 51869Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1959 · Corkhill Terry LN551DWCessna T210N · S/N 21063493Cancelled Apr 8, 2013 · Exported to Mexico · Built 1979N97180Stinson 108 · S/N 108-180Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1946N8590Eppard SCORPION E1 · S/N 080525Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1970N8668RSchweizer SGS 1-26A · S/N 203Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1963N1461PPiper PA-23 · S/N 23-524Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1956 · Abbott J LeeN239GAAnderson Grant MJ5 SIROCCO-EAGLE · S/N 239Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1978 · Richards Simon EN4721XCessna 150G · S/N 15064771Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1966 · Dragon Flyers ClubN41701Culver LCA · S/N 410Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1941 · Dahl Dan B JrN26501Taylorcraft BC-65 · S/N 1842Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1940 · Wilson SharonN623HEnstrom F-28C · S/N 378Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1977N194RMMatscherz Randy A XS MONOWHEEL · S/N A203Cancelled Sep 12, 2012 · Registration pending, canceledN66669Cessna T-50 · S/N 4548Cancelled Sep 5, 2012 · Revoked, canceled · Built 1943 · Blaine Walter RN25996Piper J3L-65 · S/N 3947Cancelled Aug 22, 2012 · Sale reported, canceled · Built 1939N1805TPiper PA-28-140 · S/N 28-7125158Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1971 · Dalton Craig LeeN176DHHetrick G Dale EUROPA · S/N 92476Cancelled Apr 24, 2012 · Sale reported · Built 2003N9238CCessna 180 · S/N 31337Cancelled Jul 15, 2011 · Revoked, pending cancellation · Built 1955 · Hill Richard GN3887SCessna 172E · S/N 17251087Cancelled Jan 31, 2011 · Revoked, pending cancellation · Built 1963 · Cookes Machine SvcN32DRyan NAVION B · S/N NAV-4-411BCancelled Oct 9, 2009 · Registration revoked · Built 1946 · Porter Philip LN812CEHughes Helicopters HUGHES 369D · S/N 720DCancelled May 14, 2008 · Triennial form not returned · Built 1980 · Southern California Edison CompanyN817CFS N I A S AS350D ASTAR · S/N 1438Cancelled Feb 5, 2008 · Exported to Canada · Built 1981 · Southern California Edison CompanyN567JPCessna 525A · S/N 525A0011Cancelled Feb 26, 2007 · Exported to Austria · Built 2000 · Cj2 567 Jp LLCN33852Piper PA-34-200T · S/N 34-7570171Cancelled Feb 7, 2007 · Exported to Canada · Built 1975 · Hamic Lonny T DBAN2322UCook Gary L RANS S-12 · S/N 1093459Cancelled Dec 20, 2006 · Triennial form not returned · Built 1995 · Cook Gary LN40NTMcdonnell Douglas Helicopter 369E · S/N 0513ECancelled Jan 9, 2003 · Triennial form not returned · Built 1994 · City Of Ontario Police DepartmentN4253KKerner John LANCAIR IV P · S/N LIV-261Cancelled Apr 3, 2002 · Exported to Panama · Built 1998 · Kerner John M
Back to Ontario, CA