Pratt & Whitney Canada PT6A-27 series
Registered aircraft · 30
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 ('52247')
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 ('52247')
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.
N1544RRas Aviation LLC · Elyria, OHN162DETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN189GCCortez Fisher LLC · Kirkland, WAN190GCMonarch Enterprises Inc · Kirkland, WAN338SBSwitchback Aviation LLC · Cody, WYN359ARTwin Otter International Ltd · Las Vegas, NVN3655BWoodley Aerial Leasing LLC · Walnut, ILN365ARTwin Otter International Ltd · Las Vegas, NVN434ARTwin Otter Support Services LLC · Las Vegas, NVN450PPJ R S Sky Inc · Pound Ridge, NYN456SFFejes Samuel T Jr · Anchorage, AKN488WYFlexible Flyer LLC · Cody, WYN504WJVantage Air Corp · Kalispell, MTN512ARTwin Otter International Ltd · Las Vegas, NVN515ARTwin Otter International Ltd · Las Vegas, NVN537ARAvro Ltd · Las Vegas, NVN56RFUnited States Department Of Commerce · Lakeland, FLN593URUltimate Resort Vacations Inc · Weston, FLN615ARTwin Otter International Ltd · Las Vegas, NVN696EXSky West Aviation Inc Trustee · Albuquerque, NMN718KWWarren Transportation LLC · Dallas, TXN723ARTwin Otter International Ltd · Las Vegas, NVN7MCSt Tammany Parish Mosquito Abatement District · Slidell, LAN821ARFairey Ltd · Las Vegas, NVN856FAPlane Fun Inc Tr Trustee · Snellville, GAN88HEStol LLC · Santa Fe, NMN92FEWarren Transportation LLC · Dallas, TXN94ARTwin Otter International Ltd · Las Vegas, NVN979FAReid Colby J · Broomfield, CON999CZN999cz LLC · Milwaukee, WI
Back to Pratt & Whitney Canada PT6A-27 series