Skip to content

Mcdonnell Douglas MD-11F

Registered aircraft · 100

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('3023600')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('3023600')
ORDER BY 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.

N250UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48745 N251UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48744 N252UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48768 N253UPUnited Parcel Service Co · Louisville, KYS/N 48439 N254UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48406 N255UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48404 N256UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48405 N257UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48451 N258UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48416 N260UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48418 N261UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48805 N262UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48806 N263UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 48782 N273UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48574 N274UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48575 N275UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48774 N276UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48579 N278UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48577 N281UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48538 N284UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48541 N286UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48453 N287UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48539 N288UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48540 N289UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48455 N290UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48456 N291UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48477 N292UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48566 N293UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48473 N294UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48472 N411SNAtares Funding LLC · Fisher Island, FLBuilt 1990 · S/N 48411 N412SNM48412 LLC · Estero, FLBuilt 1990 · S/N 48412 N415JNAtares Funding LLC · Fisher Island, FLS/N 48415 N521FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48478 N522FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48476 N523FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48479 N525FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48565 N528FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48623 N529FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 48624 N543JNAtares Funding LLC · Fisher Island, FLBuilt 1994 · S/N 48543 N545JNAtares Funding LLC · Miami Beach, FLBuilt 1995 · S/N 48545 N572FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 48755 N573FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48769 N574FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48499 N575FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48500 N576FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48501 N578FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48458 N582FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48420 N583FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48421 N584FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48436 N585FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48481

Back to Mcdonnell Douglas MD-11F