Pratt & Whitney PW4158
Registered aircraft · 65
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 ('52061')
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 ('52061')
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.
N727FDFederal Express Corp · Memphis, TNN728FDFederal Express Corporation · Memphis, TNN729FDFederal Express Corp · Memphis, TNN730FDFederal Express Corp · Memphis, TNN740FDFederal Express Corp · Memphis, TNN741FDFederal Express Corp · Memphis, TNN742FDFederal Express Corp · Memphis, TNN743FDFederal Express Corp · Memphis, TNN744FDFederal Express Corp · Memphis, TNN745FDFederal Express Corp · Memphis, TNN746FDFederal Express Corp · Memphis, TNN748FDFederal Express Corp · Memphis, TNN749FDFederal Express Corp · Memphis, TNN750FDFederal Express Corp · Memphis, TNN751FDFederal Express Corp · Memphis, TN
Back to Pratt & Whitney PW4158