Skip to content

Pratt & Whitney PW4462

Registered aircraft · 8

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 ('52171')
  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 ('52171')
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.

N275UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48774 N276UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48579 N521FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48478 N522FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48476 N525FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48565 N529FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 48624 N631FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48454 N642FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48485

Back to Pratt & Whitney PW4462