Federal Express Corp
Registered aircraft · 587
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'FEDERAL EXPRESS CORP' OR list_contains(g.other_registrant_names, 'FEDERAL EXPRESS CORP') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'FEDERAL EXPRESS CORP' OR list_contains(g.other_registrant_names, 'FEDERAL EXPRESS CORP') ORDER BY g.n_number
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.
N101FEBoeing 767-3S2F · S/N 42706N102FEBoeing 767-3S2F · S/N 42707N103FEBoeing 767-3S2F · S/N 43544N104FEBoeing 767-3S2F · S/N 42708N105FEBoeing 767-300F · S/N 64055N106FEBoeing 767-3S2F · S/N 42709N107FEBoeing 767-3S2F · S/N 44377N108FEBoeing 767-3S2F · S/N 44378N109FEBoeing 767-3S2F · S/N 42710N110FEBoeing 767-3S2F · S/N 43542N111FEBoeing 767-300F · S/N 64060N112FEBoeing 767-3S2F · S/N 43543N113FEBoeing 767-3S2F · S/N 42711N114FEBoeing 767-3S2F · S/N 42712N115FEBoeing 767-3S2F · S/N 42713N117FEBoeing 767-3S2F · S/N 44379N118FEBoeing 767-3S2F · S/N 42714N119FEBoeing 767-300F · S/N 64057N121FEBoeing 767-3S2F · S/N 43545N122FEBoeing 767-3S2F · S/N 42715N123FEBoeing 767-3S2F · S/N 42716N124FEBoeing 767-3S2F · S/N 43546N125FEBoeing 767-3S2F · S/N 42717N126FEBoeing 767-3S2F · S/N 42718N127FEBoeing 767-3S2F · S/N 43547N128FEBoeing 767-3S2F · S/N 42719N129FEBoeing 767-3S2F · S/N 43548N130FEBoeing 767-3S2F · S/N 42720N131FEBoeing 767-3S2F · S/N 61205N132FEBoeing 767-3S2F · S/N 42721N133FEBoeing 767-3S2F · S/N 43549N134FEBoeing 767-3S2F · S/N 43550N135FEBoeing 767-3S2F · S/N 42722N136FEBoeing 767-300F · S/N 64058N137FEBoeing 767-3S2F · S/N 61206N138FEBoeing 767-300F · S/N 42723N139FEBoeing 767-300F · S/N 43538N140FEBoeing 767-300F · S/N 43541N141FEBoeing 767-300F · S/N 42724N142FEBoeing 767-300F · S/N 42725N143FEBoeing 767-300F · S/N 62497N144FEBoeing 767-300F · S/N 42726N145FEBoeing 767-300F · S/N 42727N146FEBoeing 767-300F · S/N 43551N147FEBoeing 767-300F · S/N 63094N148FEBoeing 767-300F · S/N 42728N149FEBoeing 767-300F · S/N 62498N150FEBoeing 767-300F · S/N 42729N151FEBoeing 767-300F · S/N 43630N152FEBoeing 767-300F · S/N 43552
Back to Federal Express Corp