Skip to content

Pratt & Whitney Canada JT15D-4C

Registered aircraft · 9

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 ('52195')
  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 ('52195')
ORDER BY n_number

Run 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.

N211UTAviation Performance Solutions LLC · Mesa, AZBuilt 1986 · S/N 022/02-012 N212UTAviation Performance Solutions LLC · Mesa, AZBuilt 1985 · S/N 004/02-001 N250CFS211-023 LLC · Keller, TXBuilt 1987 · S/N 034/02-023 N255CFAvstar Inc · Seattle, WABuilt 1987 · S/N 44/08-002 N265CFBank Of Utah Trustee · Salt Lake City, UTBuilt 1987 · S/N 45/08-003 N280CF280 LLC · Hartford, WIBuilt 1985 · S/N 030/02-028 N40TGRinehart Orville J · Stillwater, MNBuilt 1985 · S/N 029/02-019 N521SAviation Performance Solutions LLC · Mesa, AZBuilt 1985 · S/N 032/02-021 N877BMarchetti 211 LLC · Alva, OKBuilt 1987 · S/N 46/08-004

Back to Pratt & Whitney Canada JT15D-4C