Northwest Airlines Inc
Earlier aircraft under this name · 167
Cancelled registrations that named this owner when they ended, newest first.
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_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.
N955NDouglas DC-9-31 · S/N 47160N684CABoeing 727-2S7 · S/N 22491N952NDouglas DC-9-31 · S/N 47073N613USBoeing 747-251B · S/N 20358N144JCDouglas DC-10-40 · S/N 46753N201USBoeing 727-251 · S/N 22154N284USBoeing 727-251 · S/N 21323N285USBoeing 727-251 · S/N 21324N286USBoeing 727-251 · S/N 21325N287USBoeing 727-251 · S/N 21375N295USBoeing 727-251 · S/N 21506N296USBoeing 727-251 · S/N 21788N615USBoeing 747-251B · S/N 20360N313NBAirbus Industrie A319-114 · S/N 1186N930RCDouglas DC-9-14 · S/N 45729N614USBoeing 747-251B · S/N 20359N913RWDouglas DC-9-31 · S/N 47171N153USDouglas DC-10-40 · S/N 46762N159USDouglas DC-10-40 · S/N 46768N145USDouglas DC-10-40 · S/N 46754N146USDouglas DC-10-40 · S/N 46755N152USDouglas DC-10-40 · S/N 46761N157USDouglas DC-10-40 · S/N 46766N161USDouglas DC-10-40 · S/N 46770N151USDouglas DC-10-40 · S/N 46760N149USDouglas DC-10-40 · S/N 46758N162USDouglas DC-10-40 · S/N 46771N155USDouglas DC-10-40 · S/N 46764N158USDouglas DC-10-40 · S/N 46767N141USDouglas DC-10-40 · S/N 46750N147USDouglas DC-10-40 · S/N 46756N156USDouglas DC-10-40 · S/N 46765N948LDouglas DC-9-14 · S/N 47049N912RWDouglas DC-9-31 · S/N 47150N148USDouglas DC-10-40 · S/N 46757N150USDouglas DC-10-40 · S/N 46759N160USDouglas DC-10-40 · S/N 46769N608USBoeing 747-151 · S/N 19785N154USDouglas DC-10-40 · S/N 46763N611USBoeing 747-251B · S/N 20356N601USBoeing 747-151 · S/N 19778N301RCMcdonnell Douglas DC-9-82(MD-82) · S/N 48054N911RWDouglas DC-9-31 · S/N 47149N603USBoeing 747-151 · S/N 19780N3310LDouglas DC-9-14 · S/N 45705N8903EDouglas DC-9-14 · S/N 45744N93SDouglas DC9-15 · S/N 47078N3312LDouglas DC-9-14 · S/N 45707N605USBoeing 747-151 · S/N 19782N621USBoeing 747-268F · S/N 19919
Back to Northwest Airlines Inc