Federal Express Corporation
Registered aircraft · 172
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 CORPORATION' OR list_contains(g.other_registrant_names, 'FEDERAL EXPRESS CORPORATION') 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 CORPORATION' OR list_contains(g.other_registrant_names, 'FEDERAL EXPRESS CORPORATION') 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.
N120FEBoeing 767-3S2F · S/N 44380N249FEBoeing 767-300F · S/N 67544N255FEBoeing 767-300F · S/N 67538N303FEMcdonnell Douglas MD-10-30F · S/N 46802N304FEMcdonnell Douglas MD-10-30F · S/N 46992N367FEMcdonnell Douglas MD-10-10F · S/N 46605N369FEMcdonnell Douglas MD-10-10F · S/N 46607N408FETextron 408 · S/N 408-0003N651FEAirbus Industrie A300 F4-605R · S/N 728N663FEAirbus Industrie A300 F4-605R · S/N 766N667FEAirbus Industrie A300 F4-605R · S/N 771N675FEAirbus Industrie A300 F4-605R · S/N 789N681FEAirbus Industrie A300 F4-605R · S/N 0799N700FXCessna 208B · S/N 208B0419N701FXCessna 208B · S/N 208B0420N702FXCessna 208B · S/N 208B0422N703FXCessna 208B · S/N 208B0423N705FXCessna 208B · S/N 208B0425N707FXCessna 208B · S/N 208B0427N709FEAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 1750N709FXCessna 208B · S/N 208B0430N710FXCessna 208B · S/N 208B0431N711FXCessna 208B · S/N 208B0433N712FXCessna 208B · S/N 208B0435N713FXCessna 208B · S/N 208B0438N715FXCessna 208B · S/N 208B0440N716FXCessna 208B · S/N 208B0442N717FXCessna 208B · S/N 208B0445N718FXCessna 208B · S/N 208B0448N719FXCessna 208B · S/N 208B0450N720FXCessna 208B · S/N 208B0452N722FXCessna 208B · S/N 208B0454N723FXCessna 208B · S/N 208B0456N724FXCessna 208B · S/N 208B0458N725FXCessna 208B · S/N 208B0460N726FXCessna 208B · S/N 208B0465N727FXCessna 208B · S/N 208B0468N728FDAirbus A300 B4-622R · S/N 581N728FXCessna 208B · S/N 208B0471N729FXCessna 208B · S/N 208B0474N730FXCessna 208B · S/N 208B0477N731FXCessna 208B · S/N 208B0480N732FDAirbus Industrie A300 B4-605R · S/N 713N746FXCessna 208B · S/N 208B0498N747FECessna 208B · S/N 208B0238N747FXCessna 208B · S/N 208B0501N748FECessna 208B · S/N 208B0241N748FXCessna 208B · S/N 208B0503N749FXTextron 408 · S/N 408-0011N750FXCessna 208B · S/N 208B0511
Back to Federal Express Corporation