Skip to content

Continental Airlines Inc

Earlier aircraft under this name · 99

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 = 'CONTINENTAL AIRLINES INC' OR list_contains(d.other_registrant_names, 'CONTINENTAL AIRLINES INC') 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 = 'CONTINENTAL AIRLINES INC' OR list_contains(d.other_registrant_names, 'CONTINENTAL AIRLINES INC')
  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 = 'CONTINENTAL AIRLINES INC' OR list_contains(d.other_registrant_names, 'CONTINENTAL AIRLINES INC')
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.

N11244Boeing 737-2CO · S/N 20073Cancelled Mar 21, 2013 · Triennial form not returned · Built 1969 · Houston, TX N11984Airbus Industrie A300 B4 · S/N 108Cancelled Mar 21, 2013 · Triennial form not returned · Built 1980 · Houston, TX N11985Airbus Industrie A300 B4 · S/N 119Cancelled Mar 21, 2013 · Triennial form not returned · Built 1980 · Houston, TX N12318Boeing 737-3TO · S/N 23369Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N12322Boeing 737-3TO · S/N 23373Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N14308Boeing 737-3TO · S/N 23359Cancelled Mar 21, 2013 · Built 1985 · Houston, TX N14325Boeing 737-3TO · S/N 23455Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N14334Boeing 737-3TO · S/N 23572Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N14335Boeing 737-3TO · S/N 23573Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N14336Boeing 737-3TO · S/N 23574Cancelled Mar 21, 2013 · Third renewal notice · Built 1987 · Houston, TX N14346Boeing 737-3TO · S/N 23584Cancelled Mar 21, 2013 · Built 1987 · Houston, TX N14347Boeing 737-3TO · S/N 23585Cancelled Mar 21, 2013 · Built 1987 · Houston, TX N14358Boeing 737-3TO · S/N 23943Cancelled Mar 21, 2013 · Third renewal notice · Built 1988 · Houston, TX N14931Embraer EMB-145 · S/N 145.013Cancelled Mar 21, 2013 · Third renewal notice · Built 1997 · Houston, TX N15820Mcdonnell Douglas DC-9-82(MD-82) · S/N 49480Cancelled Mar 21, 2013 · Built 1986 · Houston, TX N16301Boeing 737-3TO · S/N 23352Cancelled Mar 21, 2013 · Third renewal notice · Built 1985 · Houston, TX N17329Boeing 737-3TO · S/N 23459Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N17344Boeing 737-3TO · S/N 23582Cancelled Mar 21, 2013 · Third renewal notice · Built 1987 · Houston, TX N17356Boeing 737-3TO · S/N 23942Cancelled Mar 21, 2013 · Third renewal notice · Built 1988 · Houston, TX N18611Boeing 737-524 · S/N 27324Cancelled Mar 21, 2013 · Built 1994 · Houston, TX N477ACMcdonnell Douglas DC-9-82(MD-82) · S/N 48062Cancelled Mar 21, 2013 · Third renewal notice · Houston, TX N478ACMcdonnell Douglas DC-9-82(MD-82) · S/N 48063Cancelled Mar 21, 2013 · Third renewal notice · Built 1981 · Houston, TX N59338Boeing 737-3TO · S/N 23576Cancelled Mar 21, 2013 · Third renewal notice · Built 1987 · Houston, TX N61304Boeing 737-3TO · S/N 23355Cancelled Mar 21, 2013 · Built 1985 · Houston, TX N626TXDouglas DC-9-14 · S/N 45726Cancelled Mar 21, 2013 · Third renewal notice · Built 1966 · Houston, TX N63305Boeing 737-3TO · S/N 23356Cancelled Mar 21, 2013 · Triennial form not returned · Built 1985 · Houston, TX N69333Boeing 737-3TO · S/N 23571Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N70330Boeing 737-3TO · S/N 23460Cancelled Mar 21, 2013 · Built 1986 · Houston, TX N77303Boeing 737-3TO · S/N 23354Cancelled Mar 21, 2013 · Third renewal notice · Built 1985 · Houston, TX N92874Mcdonnell Douglas DC-9-82(MD-82) · S/N 49122Cancelled Mar 21, 2013 · Built 1982 · Houston, TX N936ASMcdonnell Douglas DC-9-82(MD-82) · S/N 49363Cancelled Mar 21, 2013 · Second renewal notice · Built 1986 · Houston, TX N937MCMcdonnell Douglas DC-9-82(MD-82) · S/N 49450Cancelled Mar 21, 2013 · Third renewal notice · Built 1986 · Houston, TX N938ASMcdonnell Douglas DC-9-82(MD-82) · S/N 49365Cancelled Mar 21, 2013 · First renewal notice · Built 1986 · Houston, TX N70353Boeing 737-3TO · S/N 23591Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1987 · Houston, TX N17321Boeing 737-3TO · S/N 23372Cancelled Oct 8, 2009 · Built 1986 · Houston, TX N17345Boeing 737-3TO · S/N 23583Cancelled Aug 21, 2009 · Built 1987 · Houston, TX N39343Boeing 737-3TO · S/N 23581Cancelled Aug 21, 2009 · Built 1987 · Houston, TX N14609Boeing 737-524 · S/N 27322Cancelled Aug 7, 2009 · Exported to Bermuda · Built 1994 · Houston, TX N14337Boeing 737-3TO · S/N 23575Cancelled Jul 21, 2009 · Built 1987 · Houston, TX N14342Boeing 737-3TO · S/N 23580Cancelled Jul 21, 2009 · Built 1987 · Houston, TX N10556Douglas DC-9-32 · S/N 47423Cancelled Aug 11, 2008 · Triennial form not returned · Built 1970 · Houston, TX N66734Boeing 727-224 · S/N 20663Cancelled Aug 11, 2008 · Triennial form not returned · Built 1974 · Houston, TX N77827Mcdonnell Douglas DC-9-82(MD-82) · S/N 49487Cancelled Aug 11, 2008 · Triennial form not returned · Built 1986 · Houston, TX N13665Boeing 737-524 · S/N 28926Cancelled Dec 7, 2007 · Exported to Bermuda · Built 1998 · Houston, TX N10834Mcdonnell Douglas DC-9-82(MD-82) · S/N 49494Cancelled Jun 1, 2007 · Triennial form not returned · Built 1987 · Houston, TX N12811Mcdonnell Douglas DC-9-82(MD-82) · S/N 49265Cancelled Jun 1, 2007 · Triennial form not returned · Built 1985 · Houston, TX N18833Mcdonnell Douglas DC-9-82(MD-82) · S/N 49493Cancelled Jun 1, 2007 · Triennial form not returned · Built 1987 · Houston, TX N34817Aerospatiale/Aeritalia ATR 42-320 · S/N 152Cancelled Sep 28, 2005 · Exported to Myanmar · Houston, TX N819NYMcdonnell Douglas DC-9-82(MD-82) · S/N 49479Cancelled Aug 3, 2005 · Exported to Thailand · Built 1986 · Houston, TX N72825Mcdonnell Douglas DC-9-82(MD-82) · S/N 49485Cancelled Jul 14, 2005 · Exported to Thailand · Built 1986 · Houston, TX

Back to Continental Airlines Inc