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.

N2064WBoeing CH47-414 · S/N M4481Cancelled Nov 7, 2001 · Exported to United Kingdom · Built 1998 · Philadelphia, PA N2060HBoeing CH47-414 · S/N M4479Cancelled Jul 12, 2001 · Exported to United Kingdom · Philadelphia, PA N2060MBoeing CH47-414 · S/N M4480Cancelled Jun 8, 2001 · Philadelphia, PA N2045GBoeing CH47-414 · S/N M4476Cancelled Feb 28, 2001 · Exported to United Kingdom · Philadelphia, PA N7771Boeing 777-200 · S/N 27116Cancelled Dec 6, 2000 · Exported to China · Seattle, WA N2093UBoeing CH47-414 · S/N M4033Cancelled May 15, 2000 · Exported to Egypt · Philadelphia, PA N2105XBoeing CH47-414 · S/N M4034Cancelled May 15, 2000 · Exported to Egypt · Philadelphia, PA N2116DBoeing CH47-414 · S/N M4035Cancelled May 15, 2000 · Exported to Egypt · Philadelphia, PA N757XBoeing 757-330 · S/N 29016Cancelled Jun 22, 1999 · Exported to Germany · Seattle, WA N2069SBoeing CH47-414 · S/N M4105Cancelled Feb 24, 1999 · Exported to Netherlands · Philadelphia, PA N2093ABoeing CH47-414 · S/N M4522Cancelled Jan 20, 1999 · Exported to South Korea · Philadelphia, PA N2088MBoeing CH47-414 · S/N M4520Cancelled Jan 15, 1999 · Exported to South Korea · Philadelphia, PA N2088VBoeing CH47-414 · S/N M4521Cancelled Jan 15, 1999 · Exported to South Korea · Philadelphia, PA N2026EBoeing CH47-414 · S/N M4457Cancelled Nov 10, 1998 · Exported to United Kingdom · Ridley Park, PA N2087MBoeing CH47-414 · S/N M4519Cancelled Oct 21, 1998 · Exported to South Korea · Philadelphia, PA N2025LBoeing Defense & Space GRP CH47-414 · S/N M4456Cancelled Oct 15, 1998 · Exported to United Kingdom · Built 1998 · Philadelphia, PA N2034KBoeing CH47-414 · S/N M4458Cancelled Oct 15, 1998 · Exported to United Kingdom · Philadelphia, PA N2019VBoeing Defense & Space GRP CH47-414 · S/N M4455Cancelled Oct 14, 1998 · Exported to United Kingdom · Built 1997 · Philadelphia, PA N2069ABoeing Defense & Space GRP CH47-414 · S/N M4104Cancelled Sep 30, 1998 · Exported to Netherlands · Philadelphia, PA N7425ABoeing CH47-414 · S/N M4515Cancelled Jul 25, 1996 · Exported to Singapore · Philadelphia, PA N7425CBoeing CH47-414 · S/N M4516Cancelled Jul 25, 1996 · Exported to Singapore · Philadelphia, PA N74246Boeing CH47-414 · S/N M4513Cancelled May 23, 1996 · Exported to Singapore · Philadelphia, PA N74248Boeing CH47-414 · S/N M4514Cancelled May 23, 1996 · Exported to Singapore · Philadelphia, PA N77779Boeing 777-236 · S/N 27105Cancelled May 13, 1996 · Exported to United Kingdom · Seattle, WA N7424MBoeing CH47-414 · S/N M4453Cancelled May 2, 1996 · Exported to United Kingdom · Philadelphia, PA N7424JBoeing CH47-414 · S/N M4451Cancelled Mar 14, 1996 · Exported to United Kingdom · Philadelphia, PA N7424UBoeing CH47-414 · S/N M4511Cancelled Mar 13, 1996 · Exported to Singapore · Philadelphia, PA N7424YBoeing CH47-414 · S/N M4512Cancelled Mar 13, 1996 · Exported to Singapore · Philadelphia, PA N150BBMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S25Cancelled Nov 24, 1992 · Exported to Canada · Philadelphia, PA N37088Boeing-Vertol CH-47(352) · S/N MA041Cancelled May 21, 1992 · Exported to United Kingdom · Philadelphia, PA N132EABoeing 707-331C · S/N 19566Cancelled Mar 17, 1992 · Triennial form not returned · Wichita, KS N37085Boeing-Vertol CH-47(352) · S/N MA039Cancelled Jan 30, 1986 · Exported to United Kingdom · Philadelphia, PA N31770Boeing-Vertol 219 CH47C · S/N D037Cancelled Aug 11, 1977 · Exported to Italy · Built 1977 · Philadelphia, PA N1507WBoeing 707-347C · S/N 20316Cancelled Feb 5, 1975 · Built 1969 · Seattle, WA N6690DBoeing CH47C · S/N D009Cancelled May 12, 1972 · Exported to Italy · Philadelphia, PA N6689DBoeing CH47C · S/N P008Cancelled Feb 25, 1972 · Exported to Italy · Philadelphia, PA N6687DBoeing CH47C · S/N D006Cancelled Sep 30, 1971 · Exported to Italy · Philadelphia, PA N6686DBoeing CH47C · S/N D005Cancelled Sep 1, 1971 · Exported to Italy · Philadelphia, PA N6683DBoeing CH47C · S/N D001Cancelled Jul 30, 1971 · Exported to Italy · Built 1971 · Philadelphia, PA N6688DBoeing CH47C · S/N P007Cancelled Jan 25, 1971 · Exported to Italy · Philadelphia, PA N197FMesserschmitt-Boelkow-Blohm BO-105S · S/N V5Cancelled Sep 21, 1970 · Built 1969 · Philadelphia, PA N8707EBoeing 720-025 · S/N 18161Cancelled Jun 30, 1970 · Exported to Denmark · Seattle, WA N1022VBoeing B377PG · S/N 15922Cancelled Oct 31, 1963 · Exported to Venezuela · Built 1947 · Renton, WA N93138Boeing 707-328 · S/N 18245Cancelled Mar 5, 1962 · Exported to France · Built 1961 · Renton, WA

Back to Boeing Company