Pratt & Whitney Canada PT6A-21
Registered aircraft · 78
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 ('52172')
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 ('52172')
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.
N640RJMidwest Executive LLC · Reno, NVN644JCBic Aviation LLC · Fort Smith, ARN6754HAviation Communication And Surveillance Systems · Phoenix, AZN681SDJefferson County Sheriffs Office · Beaumont, TXN687MMBuckeye Fluids LLC · Wilmington, DEN690KABank Of Utah Trustee · Salt Lake City, UTN692WGuardian Flight LLC · Lewisville, TXN709EAAerolease LLC · Fargo, NDN728DWNela Management Services LLC · Monroe, LAN751WYMcclain Dean L · Torrington, WYN757BAWw Air LLC · Burwell, NEN771PDGuardian Flight LLC · Lewisville, TXN785JPGuardian Flight LLC · Lewisville, TXN787TTMjw Aviation LLC · Beaumont, TXN80RDynamic Avlease Inc · Bridgewater, VAN8254DWest Pacific Air LLC · Spokane, WAN82BCGulf Air Aviation Inc · Wilmington, DEN85TBCentral Virginia Aviation Inc · Petersburg, VAN888EFPlane Fun Inc Tr Trustee · Snellville, GAN904DKAerolease LLC · Fargo, NDN904HBState Of Louisiana · Baton Rouge, LAN904PSpeed Aviation Inc · Bay Minette, ALN909MJSteel Rock Services LLC · Taylorsville, MSN90AWAircraft Guaranty Corp Trustee · Oklahoma City, OKN910EHGuardian Flight LLC · Lewisville, TXN925ARRnjs Products LLC · Lewes, DEN92WEInce Aviation LLC · Dover, DEN997MDHaynes Aviation LLC · Wetumpka, AL
Back to Pratt & Whitney Canada PT6A-21