Skip to content

Earlier aircraft under this name · 144

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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_name = 'BOEING COMPANY' OR list_contains(d.other_registrant_names, 'BOEING COMPANY') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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_name = 'BOEING COMPANY' OR list_contains(d.other_registrant_names, 'BOEING COMPANY')
  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.

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_name = 'BOEING COMPANY' OR list_contains(d.other_registrant_names, 'BOEING COMPANY')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2057RBoeing CH47-414 · S/N M4478Cancelled May 14, 2015 · Registration expired, pending cancellation · Built 1998 · Philadelphia, PA N701UKBoeing MK6 · S/N M7701Cancelled Jun 17, 2014 · Exported to United Kingdom · Built 2013 · Ridley Park, PA N762DSBoeing 737-8FV · S/N 42255Cancelled Jun 13, 2014 · Renton, WA N959BABoeing 747-8HVF · S/N 37670Cancelled Dec 5, 2013 · Exported to Bermuda · Built 2013 · Seattle, WA N393DSBoeing 737-8FV · S/N 40610Cancelled Nov 21, 2013 · Exported to India · Built 2011 · Seattle, WA N772BABoeing 747-8KZF · S/N 37394Cancelled Nov 7, 2013 · Exported to Japan · Built 2013 · Seattle, WA N257CNBoeing CH147 · S/N M2052Cancelled Oct 28, 2013 · Exported to Canada · Built 2012 · Ridley Park, PA N258CNBoeing CH147 · S/N M2053Cancelled Oct 28, 2013 · Exported to Canada · Ridley Park, PA N360BVBoeing Vertol 360 · S/N 001Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1987 · Philadelphia, PA N708DSBoeing 737-8FV · S/N 40820Cancelled Jun 19, 2013 · Tukwila, WA N765BABoeing 747-8R7F · S/N 35821Cancelled Apr 22, 2013 · Exported to Luxembourg · Seattle, WA N327DSBoeing 737-8FV · S/N 40818Cancelled Mar 29, 2013 · Seattle, WA N537DSBoeing 737-8FV · S/N 40817Cancelled Mar 6, 2013 · Seattle, WA N80704Hawker Beechcraft B300 · S/N FL-734Cancelled Feb 14, 2013 · Built 2010 · Ridley Park, PA N81478Hawker Beechcraft B300 · S/N FL-738Cancelled Feb 14, 2013 · Built 2010 · Ridley Park, PA N606TWBoeing 767-231 · S/N 22569Cancelled Aug 24, 2012 · Built 1983 · Oklahoma City, OK N5218WMcdonnell Douglas Heli 369FF · S/N 0089FFCancelled Jul 2, 2012 · Exported to Mexico · Built 1992 · Renton, WA N5002NMcdonnell Douglas Helicopter AH-64DHA · S/N 03-1022Cancelled Jun 29, 2012 · Exported to Greece · Renton, WA N5221DMcdonnell Douglas Heli 369FF · S/N 0094FCancelled Jun 29, 2012 · Exported to Mexico · Built 1992 · Renton, WA N977TKBoeing 737-9F2ER · S/N 40977Cancelled May 23, 2012 · Exported to Turkey · Built 2012 · Seattle, WA N762BABoeing 737-8AS · S/N 34993Cancelled Dec 9, 2011 · Exported to Ireland · Tukwila, WA N736JSBoeing 737-7DM · S/N 40706Cancelled Nov 1, 2011 · Exported to South Korea · Built 2011 · Seattle, WA N735JSBoeing 737-7ES · S/N 34700Cancelled Sep 21, 2011 · Exported to South Korea · Built 2009 · Seattle, WA N392DSBoeing 737-8FV · S/N 40808Cancelled Aug 18, 2011 · Seattle, WA N5030AInsitu Group SCANEAGLE A-15 EO · S/N 05-78Cancelled May 10, 2011 · Triennial form not returned · St Louis, MO N762TTBoeing 767-2EY · S/N 33687Cancelled Mar 11, 2011 · Exported to Italy · Built 2005 · Seattle, WA N559BABoeing 777-35EER · S/N 32644Cancelled Nov 19, 2010 · Exported to Taiwan · Seattle, WA N541BABoeing 737-8FV · S/N 34394Cancelled Jun 2, 2009 · Built 2008 · Seattle, WA N371BJBoeing 737-7DM · S/N 29971Cancelled Aug 29, 2008 · Built 2000 · Seattle, WA N812SYBoeing 737-8Q8 · S/N 35278Cancelled Jun 5, 2008 · Exported to Germany · Seattle, WA N370BJBoeing 737-7HI · S/N 36106Cancelled Oct 18, 2007 · Exported to India · Built 2006 · Seattle, WA N369BJBoeing 737-8Z6 · S/N 35478Cancelled Apr 16, 2007 · Exported to Thailand · Seattle, WA N37030Boeing-Vertol CH-47(352) · S/N MA014Cancelled Jul 20, 2006 · Exported to United Kingdom · Seattle, WA N230UABoeing 777-222 · S/N 30227Cancelled Sep 26, 2005 · Seattle, WA N717XABoeing 717-200 · S/N 55000Cancelled Sep 26, 2005 · Built 1998 · Long Beach, CA N323CTBoeing 737-8BK · S/N 33023Cancelled Apr 7, 2005 · Exported to India · Seattle, WA N3775Boeing 737-832 · S/N 30826Cancelled Mar 10, 2005 · Exported to Spain · Seattle, WA N594HABoeing 767-3CB · S/N 33469Cancelled Sep 8, 2003 · Exported to Bermuda · Built 2003 · Seattle, WA N2083KBoeing CH47-414 · S/N M4483Cancelled Jan 23, 2002 · Exported to United Kingdom · Built 1999 · Philadelphia, PA N20671Boeing CH47-414 · S/N M4482Cancelled Dec 31, 2001 · Exported to United Kingdom · Built 1999 · Philadelphia, PA N979ANBoeing 737-823 · S/N 29551Cancelled Dec 13, 2001 · Exported to Australia · Seattle, WA N980ANBoeing 737-823 · S/N 30101Cancelled Dec 12, 2001 · Exported to Australia · Seattle, WA N981ANBoeing 737-823 · S/N 30897Cancelled Dec 12, 2001 · Exported to Australia · Seattle, WA N982ANBoeing 737-823 · S/N 29552Cancelled Dec 12, 2001 · Exported to Australia · Seattle, WA N983ANBoeing 737-823 · S/N 30899Cancelled Dec 12, 2001 · Exported to Australia · Seattle, WA N984AMBoeing 737-823 · S/N 29553Cancelled Dec 12, 2001 · Exported to Australia · Seattle, WA N985AMBoeing 737-823 · S/N 30901Cancelled Dec 12, 2001 · Exported to Australia · Seattle, WA N177UKMcdonnell Douglas C17A · S/N 17A080Cancelled Nov 7, 2001 · Long Beach, CA N178UKMcdonnell Douglas C17A · S/N 17A081Cancelled Nov 7, 2001 · Long Beach, CA N179UKMcdonnell Douglas C17A · S/N 17A082Cancelled Nov 7, 2001 · Long Beach, CA

Back to Boeing Company