OpenAirDocs.org
Sun Valley, CA

Cancelled registrations · 148

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 = 'SUN VALLEY'
  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.

N8556FBell 47G-5 · S/N 7804Cancelled Jan 7, 2026 · Revoked, canceled · Built 1966 · Aircraft & Helicopter Leasing & SaleN88022Bell 47G-3B-2 · S/N 6686Cancelled Jun 5, 2020 · Revoked, canceled · Built 1972 · Aircraft & Helicopter Supp IncN74604Boeing 377 · S/N 15950Cancelled Feb 21, 2020 · Revoked, canceled · Built 1949 · Mansdorf & Co LeeN74610Boeing 377 · S/N 15956Cancelled Feb 21, 2020 · Revoked, canceled · Built 1949 · Mansdorf & Co LeeN74609Boeing 377 · S/N 15955Cancelled Jan 9, 2020 · Revoked, pending cancellation · Built 1949 · Mansdorf & Co LeeN73288Bell 47G-3B-1 · S/N 2912Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Aerial Spotters IncN73955Bell 47G-3B-1 · S/N 2825Cancelled Feb 4, 2017 · Revoked, canceled · Built 1963 · Aircraft And Helicopter Supplies IncN74605Boeing 377 · S/N 15951Cancelled Feb 4, 2017 · Revoked, canceled · Built 1949 · Mansdorf & Co LeeN7905SBell 47G-5 · S/N 7853Cancelled Feb 4, 2017 · Revoked, canceled · Built 1967 · Acft & Helicopter Supplies IncN8116Bell Kitz Kopters 47D1 · S/N K763Cancelled Feb 4, 2017 · Revoked, canceled · Built 1967 · Aircraft & Hel Leasing & Sales IncN90942Boeing 377 · S/N 15958Cancelled Feb 4, 2017 · Revoked, canceled · Built 1949 · Mansdorf & Co LeeN71534Bell 47G-3B-1 · S/N 6621Cancelled Dec 22, 2014 · Revoked, canceled · Aircraft & Hel Leas & Sales IncN70702Bell 47G-3B-1 · S/N 6536Cancelled Dec 2, 2014 · Revoked, canceled · Aircraft & HelicopterN7262GCessna 172K · S/N 17258962Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1970 · Demedio Francisco FN4218WPiper J3C-65 · S/N 14424Cancelled Aug 22, 2013 · Sale reported, canceledN500NWWoodbury Norman B REVOLUTION MINI 500 · S/N 0239Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1996N64706Bell 47G-5 · S/N 7871Cancelled Aug 6, 2013 · Revoked, canceled · Aircraft & Helicopter Lsg & Sls IncN62334Bell 47G-4A · S/N 7671Cancelled Aug 5, 2013 · Revoked, canceled · Built 1969 · Aircraft And Helicopter Supplies IncN39175Sikorsky S-58ET · S/N 58354Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1956 · California Helicopter Parts IncN12370Beech C35 · S/N D-3369Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1952 · Land Darrell DN419GBeech E50 · S/N 58-3063Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Kinder Lendelle JN59622Bell 206B · S/N 1533Cancelled Dec 18, 2012 · Revoked, pending cancellation · Built 1974 · California Helicopter Parts IncN73984Bell 47G-3B-1 · S/N 2893Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1964N59576Bell 206B · S/N 1473Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1974N65219Bell 47G-3B-2 · S/N 6680Cancelled Sep 5, 2012 · Revoked, canceled · Built 1975 · Aircraft & Helicopter Supplies IncN216HBell 47G · S/N 205Cancelled Aug 24, 2012 · Registration expired, pending cancellation · Built 1950 · SkycoptersN48663Fairchild M-62A · S/N T411056Cancelled Aug 8, 2012 · Revoked, canceled · Built 1941 · Carlson F W HN1042VBoeing 377 · S/N 15942Cancelled May 24, 2012 · Revoked, canceled · Built 1949 · Mansdorf & Co LeeN64RJPiper PA-30 · S/N 30-1931Cancelled Jun 21, 2011 · First renewal notice · Built 1969 · Tower General Contractors IncN1510FBalloon Works FIREFLY 7 · S/N F7005Cancelled Apr 4, 2011 · Sale reported, pending cancellation · Built 1982N8496EBell 47G-3B · S/N 2717Cancelled Sep 15, 2009 · Registration revoked · Built 1961 · Aircraft And Helicopter Supplies IncN2111SBeech D18S · S/N A-571Cancelled Jul 13, 2009 · Registration revoked · Built 1951 · Eagle Aircraft Parts CorporationN2241APiper PA-22-135 · S/N 22-642Cancelled Jul 13, 2009 · Registration revoked · Built 1952 · Elliott Franklin FN14566Franks YOU-TOO JR M1 · S/N 1Cancelled Jun 30, 2009 · Registration revoked · Built 1975 · Tucker Donald AN65399Cessna 152 · S/N 15281527Cancelled Oct 30, 2007 · Exported to Philippines · Built 1978 · General Aviation Support Center IncN9045BDouglas C-118A · S/N 44620Cancelled Mar 1, 2006 · Second triennial mailing, no response · Time Aviation Services IncN31425Raytheon 1900D · S/N UE-376Cancelled Jan 16, 2003 · Exported to Indonesia · Built 1999 · Hpp Aviation Services IncN31419Raytheon 1900D · S/N UE-374Cancelled Dec 13, 2002 · Exported to Malaysia · Built 1999 · Hpp Aviation Services IncN44857Raytheon B200 · S/N BB-1787Cancelled Oct 21, 2002 · Exported to Australia · Built 2001 · Hpp Aviation Services IncN31424Raytheon 1900D · S/N UE-375Cancelled Jun 5, 2002 · Exported to Indonesia · Built 1999 · Hpp Aviation Services IncN40481Raytheon B200 · S/N BB-1696Cancelled Sep 6, 2000 · Exported to Australia · Hpp Aviation Services IncN31110Raytheon 1900D · S/N UE-373Cancelled Jul 3, 2000 · Exported to Malaysia · Hpp Aviation Services IncN3169NRaytheon B300 · S/N FL-269Cancelled Jun 9, 2000 · Exported to Canada · Hpp Aviation Services IncN40483Raytheon B200 · S/N BB-1697Cancelled May 12, 2000 · Exported to Australia · Hpp Aviation Services IncN30469Raytheon 1900D · S/N UE-364Cancelled Feb 18, 2000 · Exported to Indonesia · Hpp Aviation Services IncN23356Raytheon B200 · S/N BB-1643Cancelled Jun 30, 1999 · Exported to Australia · Hpp Aviation Services IncN128BJNorth American T-28C · S/N 140509Cancelled Jun 28, 1999 · Triennial form not returned · Built 1956 · Aircraft Cylinder And Turbine IncN1099SRaytheon 400A · S/N RK-139Cancelled Jun 25, 1999 · Exported to Australia · Hawker Pacific IncN23355Raytheon B200 · S/N BB-1641Cancelled Jun 4, 1999 · Exported to Australia · Hpp Aviation Services IncN21746Raytheon A36 · S/N E-3131Cancelled May 17, 1999 · Exported to Australia · Hpp Aviation Services Inc
Back to Sun Valley, CA