OpenAirDocs.org
El Segundo, CA

Cancelled registrations · 101

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 = 'EL SEGUNDO'
  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.

N82CRGrumman G-1159 · S/N 80Cancelled Jul 3, 2025 · Built 1970 · Northrop Grumman Systems CorpN41617Culver LFA · S/N 376Cancelled Apr 6, 2023 · Registration pending, canceled · Built 1941N11413Aeronca C-3 · S/N A-153Cancelled Jan 14, 2023 · Registration pending, canceledN11890Curtiss Wright JR CW1 · S/N 1263Cancelled Jan 14, 2023 · Registration pending, canceledN28396Piper J4A · S/N 4-849Cancelled Jan 14, 2023 · Registration pending, canceled · Built 1940N6945KPiper PA-20 · S/N 20-48Cancelled Jan 14, 2023 · Registration pending, canceled · Built 1950N75728Beech D17S · S/N 3086Cancelled Jan 14, 2023 · Registration pending, canceledN25NLLeckenby Norman LANCAIR 235 · S/N 221Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1998 · Bell William EngelN100PDCessna 172K · S/N 17257902Cancelled Feb 3, 2021 · Registration expired, pending cancellation · Built 1969 · Harrod Andrew AN168WSabreliner NA-265-40 · S/N 282-33Cancelled Dec 20, 2019 · Built 1965 · Northrop Grumman Systems CorpN160WNorth American Rockwell NA-265-40 · S/N 282-101Cancelled Dec 2, 2019 · Built 1972 · Northrop Grumman Systems CorpN162WBritish BAC 1-11 401/AK · S/N 087Cancelled Dec 2, 2019 · Second renewal notice · Built 1966 · Northrop Grumman Systems CorpN164WBritish BAC 1-11 401/AK · S/N BAC.090Cancelled Dec 2, 2019 · Built 1966 · Northrop Grumman Systems CorpN393NGNorthrup Grumman Systems 393 · S/N AV007Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Northrop Grumman Systems CorpN687NGDJI S900/A2 · S/N 370061687Cancelled Dec 7, 2018 · Registration expired, pending cancellation · Northrop Grumman Systems CorpN819NGDJI PHANTOM 3 PROFESSION · S/N P78DCD27011819Cancelled Dec 7, 2018 · Registration expired, pending cancellation · Northrop Grumman Systems CorpN241PRNorthrop Grumman Systems R02 · S/N 00001Cancelled Jul 17, 2018 · Second renewal notice · Built 2012 · Northrop Grumman Systems CorpN412DBNorthrop Grumman Systems R02 · S/N 00002Cancelled Jul 17, 2018 · First renewal notice · Built 2013 · Northrop Grumman Systems CorpN454LSBell Helicopter Textron Canada 407 · S/N 54083Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 2011 · Northrop Grumman Systems CorpN4945VBell Helicopter Textron Canada 407 · S/N 54142Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 2013 · Northrop Grumman Systems CorpN4946ABell Helicopter Textron Canada 407 · S/N 54144Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 2013 · Northrop Grumman Systems CorpN494YRBell Helicopter Textron Canada 407 · S/N 54139Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 2013 · Northrop Grumman Systems CorpN494ZBBell Helicopter Textron Canada 407 · S/N 54138Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 2013 · Northrop Grumman Systems CorpN489UBBell Helicopter Textron Canada 407 · S/N 54137Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 2013 · Northrop Grumman Systems CorpN4771BBell Helicopter Textron Canada 407 · S/N 54126Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Systems CorpN487RHBell Helicopter Textron Canada 407 · S/N 54132Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 2013 · Northrop Grumman Systems CorpN4700BBell Helicopter Textron Canada 407 · S/N 54105Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Systems CorpN470UBBell Helicopter Textron Canada 407 · S/N 54112Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Systems CorpN470VBBell Helicopter Textron Canada 407 · S/N 54107Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Systems CorpN472BBBell Helicopter Textron Canada 407 · S/N 54118Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Systems CorpN476WBBell Helicopter Textron Canada 407 · S/N 54122Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Systems CorpN477ZBBell Helicopter Textron Canada 407 · S/N 54123Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 2012 · Northrop Grumman Systems CorpN50UPiper PA-28R-201 · S/N 28R-7737092Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1977 · Hartman Equities IncN7624KPiper PA-20 · S/N 20-442Cancelled Nov 21, 2017 · Revoked, canceled · Built 1950 · Thompson SamN398NGNorthrup Grumman Systems 393 · S/N AV 022Cancelled Sep 27, 2017 · Registration expired, pending cancellation · Northrop Grumman Systems CorpN29NGRaytheon 1900D · S/N UE-303Cancelled Dec 15, 2016 · Exported to Canada · Built 1997 · Northrop Grumman Systems CorpN360TLBritten-Norman BN-2T-4R · S/N 2143Cancelled Oct 22, 2015 · Built 1986 · Northrop Grumman Systems CorpN4646WSchweizer SHU-40B · S/N P5Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 2005 · Northrop Grumman Systems CorpN255TPiper PA-18 · S/N 18-2369Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1953 · Schwarz Paul DBAN641AABoeing 757-223 · S/N 24599Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1991N20USPiccard AX-4 · S/N 102Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1969 · Elmstrom GeorgeN22451Aeronca 65-C · S/N C-3999Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1939N244YVBeech 1900D · S/N UE-244Cancelled Jul 10, 2012 · Exported to Egypt · Built 1996 · Raytheon Space And Airborne SystemsN171ZVBeech 1900D · S/N UE-171Cancelled Jun 6, 2012 · Exported to Egypt · Built 1995 · Raytheon Space And Airborne SystemsN699HBHawker Beechcraft B300 · S/N FL-699Cancelled Dec 9, 2011 · Exported to Saudi Arabia · Built 2010 · Raytheon Company Space And Airborne SystemsN714EUHawker Beechcraft B300 · S/N FL-714Cancelled Dec 9, 2011 · Exported to Saudi Arabia · Built 2010 · Raytheon Company Space And Airborne SytemsN893JURaytheon G58 · S/N TH2166Cancelled Nov 9, 2011 · Exported to Japan · Jalux Americas IncN894JVHawker Beechcraft G58 · S/N TH-2268Cancelled Nov 9, 2011 · Exported to Japan · Built 2009 · Jalux Americas IncN892JTRaytheon G58 · S/N TH2165Cancelled Nov 1, 2011 · Exported to Japan · Built 2001 · Jalux Americas IncN891JRRaytheon G58 · S/N TH2164Cancelled Oct 31, 2011 · Exported to Japan · Built 2007 · Jalux Americas Inc
Back to El Segundo, CA