Skip to content

Northwest Airlines Inc

Earlier aircraft under this name · 167

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

N4576Waco 125 · S/N 1397Cancelled Dec 21, 2009 · Triennial form not returned · Built 1928 · St Paul, MN N610NWMcdonnell Douglas DC-9-32 · S/N 47432Cancelled Nov 24, 2008 · Triennial form not returned · Built 1969 · St Paul, MN N612NWMcdonnell Douglas DC-9-32 · S/N 47436Cancelled Nov 24, 2008 · Triennial form not returned · Built 1969 · St Paul, MN N622USBoeing 747-251B · S/N 21704Cancelled Nov 24, 2008 · Built 1979 · Minneapolis, MN N908HDouglas DC-9-31 · S/N 47517Cancelled Nov 24, 2008 · Built 1970 · Minneapolis, MN N982USMcdonnell Douglas DC-9-32 · S/N 45790Cancelled Nov 24, 2008 · Triennial form not returned · Built 1968 · St Paul, MN N633USBoeing 747-227 · S/N 21991Cancelled Oct 10, 2008 · Built 1980 · Minneapolis, MN N960NDouglas DC-9-31 · S/N 47256Cancelled Sep 25, 2008 · Triennial form not returned · Built 1968 · St Paul, MN N924RWDouglas DC-9-31 · S/N 47185Cancelled Aug 28, 2008 · Triennial form not returned · Built 1968 · Saint Paul, MN N8950EDouglas DC-9-31 · S/N 47186Cancelled Aug 13, 2008 · Triennial form not returned · Built 1968 · St Paul, MN N3991CMcdonnell Douglas DC-9-32 · S/N 47175Cancelled Aug 4, 2008 · Triennial form not returned · Built 1968 · Minneapolis, MN N961NDouglas DC-9-31 · S/N 47405Cancelled Aug 4, 2008 · Triennial form not returned · Built 1969 · Minneapolis, MN N962NDouglas DC-9-31 · S/N 47406Cancelled Aug 4, 2008 · Triennial form not returned · Built 1969 · Minneapolis, MN N963NDouglas DC-9-31 · S/N 47415Cancelled Aug 4, 2008 · Triennial form not returned · Built 1969 · Minneapolis, MN N627USBoeing 747-251B · S/N 21709Cancelled Jul 16, 2008 · Built 1979 · Minneapolis, MN N9337Douglas DC-9-31 · S/N 47346Cancelled Jul 11, 2008 · Triennial form not returned · Built 1969 · St Paul, MN N611NAMcdonnell Douglas DC-9-32 · S/N 47435Cancelled Jun 18, 2008 · Triennial form not returned · Built 1969 · St Paul, MN N9331Douglas DC-9-31 · S/N 47263Cancelled May 19, 2008 · Triennial form not returned · Built 1968 · St Paul, MN N605NWMcdonnell Douglas DC-9-32 · S/N 47223Cancelled May 5, 2008 · Triennial form not returned · Built 1968 · Saint Paul, MN N603NWMcdonnell Douglas DC-9-32 · S/N 47101Cancelled Apr 4, 2008 · Triennial form not returned · Built 1967 · St Paul, MN N8934EDouglas DC-9-31 · S/N 47143Cancelled Jan 2, 2008 · Triennial form not returned · Built 1968 · Minneapolis, MN N8957EDouglas DC-9-31 · S/N 47215Cancelled Jan 2, 2008 · Triennial form not returned · Built 1968 · St Paul, MN N227NWMcdonnell-Douglas DC-10-30 · S/N 46969Cancelled Dec 1, 2007 · Triennial form not returned · Built 1977 · St Paul, MN N609NWMcdonnell Douglas DC-9-32 · S/N 47234Cancelled Dec 1, 2007 · Triennial form not returned · Built 1969 · St Paul, MN N8979EDouglas DC-9-31 · S/N 47328Cancelled Dec 1, 2007 · Triennial form not returned · Built 1968 · St Paul, MN N942NMcdonnell Douglas DC-9-32 · S/N 47459Cancelled Dec 1, 2007 · Triennial form not returned · Built 1969 · St Paul, MN N1308TDouglas DC-9-31 · S/N 47315Cancelled Oct 31, 2007 · Triennial form not returned · Built 1968 · Minneapolis, MN N918RWDouglas DC-9-31 · S/N 47158Cancelled Oct 24, 2007 · Triennial form not returned · Built 1968 · St Paul, MN N299USBoeing 727-251 · S/N 22153Cancelled Sep 20, 2007 · Triennial form not returned · Built 1980 · St Paul, MN N288USBoeing 727-251 · S/N 21376Cancelled Sep 19, 2007 · Triennial form not returned · Built 1977 · St Paul, MN N290USBoeing 727-251 · S/N 21378Cancelled Sep 19, 2007 · Triennial form not returned · Built 1977 · St Paul, MN N202USBoeing 727-251 · S/N 22155Cancelled Sep 18, 2007 · Triennial form not returned · Built 1980 · St Paul, MN N204USBoeing 727-251 · S/N 22544Cancelled Sep 18, 2007 · Triennial form not returned · Built 1981 · St Paul, MN N275USBoeing 727-251 · S/N 21154Cancelled Sep 18, 2007 · Triennial form not returned · Built 1975 · St Paul, MN N374NBAirbus A319-114 · S/N 2464Cancelled Aug 1, 2007 · Exported to Bermuda · Built 2005 · Minneapolis, MN N373NBAirbus A319-114 · S/N 2373Cancelled Jul 20, 2007 · Exported to Bermuda · Built 2005 · Minneapolis, MN N377NBAirbus A319-114 · S/N 2641Cancelled Jul 20, 2007 · Exported to Bermuda · Built 2005 · Minneapolis, MN N375NBAirbus A319-114 · S/N 2474Cancelled Jul 17, 2007 · Exported to Bermuda · Built 2005 · Minneapolis, MN N376NBAirbus A319-114 · S/N 2618Cancelled Jul 17, 2007 · Exported to Bermuda · Built 2005 · Minneapolis, MN N350NBAirbus A319-114 · S/N 1819Cancelled Jul 11, 2007 · Exported to Bermuda · Built 2002 · Minneapolis, MN N356NBAirbus A319-114 · S/N 1870Cancelled Jul 11, 2007 · Exported to Bermuda · Built 2002 · Minneapolis, MN N367NBAirbus A319-114 · S/N 2028Cancelled Jul 11, 2007 · Exported to Bermuda · Built 2003 · Minneapolis, MN N372NBAirbus A319-114 · S/N 2369Cancelled Jul 11, 2007 · Exported to Bermuda · Built 2005 · Minneapolis, MN N291USBoeing 727-251 · S/N 21379Cancelled May 5, 2007 · Triennial form not returned · Built 1977 · St Paul, MN N133JCDouglas DC-10-40 · S/N 46752Cancelled May 3, 2007 · Triennial form not returned · Built 1972 · Saint Paul, MN N763NCMcdonnell Douglas DC-9-51 · S/N 47716Cancelled Jan 5, 2007 · Triennial form not returned · Built 1976 · St Paul, MN N302USAirbus Industrie A320-211 · S/N 032Cancelled Aug 3, 2006 · Triennial form not returned · Built 1989 · St Paul, MN N306USAirbus Industrie A320-211 · S/N 060Cancelled Aug 3, 2006 · Triennial form not returned · Built 1989 · Saint Paul, MN N307USAirbus Industrie A320-211 · S/N 106Cancelled Aug 3, 2006 · Triennial form not returned · Built 1990 · St Paul, MN N308USAirbus Industrie A320-211 · S/N 107Cancelled Aug 3, 2006 · Triennial form not returned · Built 1990 · St Paul, MN

Back to Northwest Airlines Inc