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_numberRun 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.
N596NWDelta Air Lines Inc · Atlanta, GAN673DLDelta Air Lines Inc · Atlanta, GAN68087Federal Express Corp · Memphis, TNN688SLAero Micronesia Inc DBA · Barrigada, GUN751CSUmb Bank Na Trustee · Salt Lake City, UTN757QMAero Micronesia Inc DBA · Barrigada, GUN758SSRed River Aircraft Leasing LLC · Anchorage, AKN770FDFederal Express Corp · Memphis, TNN771FDFederal Express Corp · Memphis, TNN772FDFederal Express Corp · Memphis, TNN773FDFederal Express Corp · Memphis, TNN774FDFederal Express Corp · Memphis, TNN775FDFederal Express Corp · Memphis, TNN776FDFederal Express Corp · Memphis, TNN777FDFederal Express Corp · Memphis, TNN778FDFederal Express Corp · Memphis, TNN779FDFederal Express Corp · Memphis, TNN780FDFederal Express Corp · Memphis, TNN781FDFederal Express Corp · Memphis, TNN782FDFederal Express Corp · Memphis, TNN783FDFederal Express Corp · Memphis, TNN784FDFederal Express Corp · Memphis, TNN785FDFederal Express Corp · Memphis, TNN787FDFederal Express Corp · Memphis, TNN788FDFederal Express Corp · Memphis, TNN789FDFederal Express Corp · Memphis, TNN790FDFederal Express Corp · Memphis, TNN791FDFederal Express Corp · Memphis, TNN792FDFederal Express Corp · Memphis, TNN793FDFederal Express Corp · Memphis, TNN795FDFederal Express Corp · Memphis, TNN796FDFederal Express Corp · Memphis, TNN797FDFederal Express Corp · Memphis, TNN798FDFederal Express Corp · Memphis, TNN799FDFederal Express Corp · Memphis, TNN987FDFederal Express Corp · Memphis, TNN988FDFederal Express Corp · Memphis, TNN999AQAeroacq Partners LLC · Laud By Sea, FL
Back to Pratt & Whitney PW2040