Pratt & Whitney Canada PT6T-3 series
Registered aircraft · 17
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 ('52103')
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 ('52103')
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.
N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEN143PHWestern USA Solutions Inc · Kodiak, AKN16920Temsco Helicopters Inc · Ketchikan, AKN17LASan Juan Aviation LLC · Wilmington, DEN18LACounty Of Los Angeles Fire Department · Pacoima, CAN212AHAspen Helicopters Inc · Oxnard, CAN212THCougar Aviation LLC · Fresno, CAN219MGAir Methods LLC · Greenwood Village, CON233LCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN281SDCity Of San Diego · San Diego, CAN411DEU S Department Of Energy · Las Vegas, NVN470QLVertol Systems Co Inc · Destin, FLN621FCFlorida Depart Of Agriculture And Consumer Svcs · Tallahassee, FLN624FCFlorida Forest Service - Fp/Ac · Tallahassee, FLN816SSHilcorp Equipment LLC · Anchorage, AKN82WWeyerhaeuser Nr Co · Eugene, ORN853QAHeli-Consignment Inc · Chicago, IL
Back to Pratt & Whitney Canada PT6T-3 series