Federal Express Corporation
Earlier aircraft under this name · 193
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 = 'FEDERAL EXPRESS CORPORATION' OR list_contains(d.other_registrant_names, 'FEDERAL EXPRESS CORPORATION') 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 = 'FEDERAL EXPRESS CORPORATION' OR list_contains(d.other_registrant_names, 'FEDERAL EXPRESS CORPORATION') 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.
N426FEAirbus Industrie A310-203 · S/N 245N368FEMcdonnell Douglas MD-10-10F · S/N 46606N375FEMcdonnell Douglas MD-10-10F · S/N 46613N377FEMcdonnell Douglas MD-10-10F · S/N 47965N429FEAirbus Industrie A310-203 · S/N 364N427FEAirbus Industrie A310-203 · S/N 362N302FEMcdonnell Douglas MD-10-30F · S/N 46801N312FEMcdonnell Douglas MD-10-30F · S/N 48300N443FEAirbus Industrie A310-203 · S/N 283N68053Mcdonnell Douglas MD-10-10F · S/N 47807N68054Mcdonnell Douglas MD-10-10F · S/N 47808N372FEMcdonnell Douglas MD-10-10F · S/N 46610N365FEMcdonnell Douglas MD-10-10F · S/N 46601N366FEMcdonnell Douglas MD-10-10F · S/N 46602N371FEMcdonnell Douglas MD-10-10F · S/N 46609N373FEMcdonnell Douglas MD-10-10F · S/N 46611N385FEMcdonnell Douglas MD-10-10F · S/N 46619N392FEMcdonnell Douglas MD-10-10F · S/N 46626N397FEMcdonnell Douglas MD-10-10F · S/N 46631N566FEMcdonnell Douglas MD-10-10F · S/N 46989N68052Mcdonnell Douglas MD-10-10F · S/N 47806N423FEAirbus Industrie A310-203 · S/N 281N450FEAirbus Industrie A310-222 · S/N 162N68049Mcdonnell Douglas MD-10-10F · S/N 47803N68057Mcdonnell Douglas MD-10-10F · S/N 48264N370FEMcdonnell Douglas MD-10-10F · S/N 46608N938FECessna 208B · S/N 208B0038N374FEMcdonnell Douglas MD-10-10F · S/N 46612N418FEAirbus Industrie A310-222 · S/N 343N421FEAirbus Industrie A310-222 · S/N 342N425FEAirbus Industrie A310-203 · S/N 264N924FECessna 208B · S/N 208B0024N221FEBoeing 727-233 · S/N 20932N257FEBoeing 727-233 · S/N 20939N258FEBoeing 727-233 · S/N 20940N264FEBoeing 727-233 · S/N 21626N275FEBoeing 727-233 · S/N 22040N276FEBoeing 727-233 · S/N 22041N465FEBoeing 727-225 · S/N 21289N469FEBoeing 727-225 · S/N 21581N479FEBoeing 727-227 · S/N 21461N488FEBoeing 727-227 · S/N 21491N852FECessna 208B · S/N 208B0168N269FEBoeing 727-233 · S/N 21675N495FEBoeing 727-227 · S/N 21669N113FEBoeing 727-22C · S/N 19894N237FEBoeing 727-247 · S/N 21331N263FEBoeing 727-233 · S/N 21625N280FEBoeing 727-233 · S/N 22347N281FEBoeing 727-233 · S/N 22348
Back to Federal Express Corporation