Dhl Network Operations (USA) Inc
Earlier aircraft under this name · 35
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 = 'DHL NETWORK OPERATIONS (USA) INC' OR list_contains(d.other_registrant_names, 'DHL NETWORK OPERATIONS (USA) 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 = 'DHL NETWORK OPERATIONS (USA) INC' OR list_contains(d.other_registrant_names, 'DHL NETWORK OPERATIONS (USA) 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.
N972AXMcdonnell Douglas DC-9-41 · S/N 47631N903AXMcdonnell Douglas DC-9-32 · S/N 47427N929AXDouglas DC-9-31 · S/N 45874N939AXMcdonnell Douglas DC-9-32 · S/N 47201N981AXDouglas DC-9-32 · S/N 47273N953AXDouglas DC-9-41 · S/N 47608N956AXMcdonnell Douglas DC-9-41 · S/N 47620N967AXMcdonnell Douglas DC-9-41 · S/N 47509N977AXMcdonnell Douglas DC-9-41 · S/N 47513N979AXMcdonnell Douglas DC-9-41 · S/N 47492N990AXMcdonnell Douglas DC-9-41 · S/N 47493N975AXDouglas DC-9-41 · S/N 47512N960AXMcdonnell Douglas DC-9-41 · S/N 47762N983AXDouglas DC-9-32 · S/N 47257N978AXMcdonnell Douglas DC-9-41 · S/N 47628N962AXDouglas DC-9-41 · S/N 47768N973AXMcdonnell Douglas DC-9-41 · S/N 47511N943AXMcdonnell Douglas DC-9-31 · S/N 47528N965AXMcdonnell Douglas DC-9-41 · S/N 47498N966AXDouglas DC-9-41 · S/N 47510N969AXMcdonnell Douglas DC-9-41 · S/N 47464N974AXMcdonnell Douglas DC-9-41 · S/N 47623N949AXDouglas DC-9-31 · S/N 47325N900AXDouglas DC-9-32 · S/N 47380N957AXDouglas DC-9-41 · S/N 47759N963AXMcdonnell Douglas DC-9-41 · S/N 47780N928AXMcdonnell Douglas DC-9-32 · S/N 47392N924AXDouglas DC-9-31 · S/N 47403N937AXDouglas DC-9-31 · S/N 47074N968AXMcdonnell Douglas DC-9-41 · S/N 47499N954AXMcdonnell Douglas DC-9-41 · S/N 47612N984AXDouglas DC-9-32 · S/N 47258N955AXDouglas DC-9-41 · S/N 47619N946AXDouglas DC-9-31 · S/N 47003N947AXDouglas DC-9-31 · S/N 47004
Back to Dhl Network Operations (USA) Inc