Skip to content

Pratt & Whitney PW2040

Registered aircraft · 88

Aircraft with this engine 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 engine_model_code IN ('52121')
  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 engine_model_code IN ('52121')
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.

N122UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0807 N182UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25279 N401UPUnited Parcel Service Co · Louisville, KYBuilt 1987 · S/N 23723 N402UPUnited Parcel Service Co · Louisville, KYBuilt 1987 · S/N 23724 N403UPUnited Parcel Service Oc · Louisville, KYBuilt 1987 · S/N 23725 N404UPUnited Parcel Service Co · Louisville, KYBuilt 1987 · S/N 23726 N405UPUnited Parcel Service Co · Louisville, KYBuilt 1987 · S/N 23727 N406UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23728 N407UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23729 N408UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23730 N409UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23731 N410UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23732 N411UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23851 N412UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23852 N413UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23853 N414UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23854 N415UPUnited Parcel Service Co · Louisville, KYBuilt 1988 · S/N 23855 N417UPUnited Parcel Service Co · Louisville, KYBuilt 1990 · S/N 23904 N418UPUnited Parcel Service Co · Louisville, KYBuilt 1990 · S/N 23905 N420UPUnited Parcel Service Co · Louisville, KYBuilt 1990 · S/N 23907 N421UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 25281 N422UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 25324 N424UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 25369 N426UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 25457 N427UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 25458 N428UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 25459 N429UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 25460 N430UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 25461 N431UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 25462 N432UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 25463 N434UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 25465 N435UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 25466 N503UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24624 N508UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24744 N518UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24871 N581NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32982 N582NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32981 N583NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32983 N584NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32984 N585NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32985 N586NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32987 N587NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32986 N588NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32988 N589NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32989 N590NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32990 N591NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32991 N592NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32992 N593NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32993 N594NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32994 N595NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32995

Back to Pratt & Whitney PW2040