Skip to content

Rolls-Royce 250-C10D

Registered aircraft · 8

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 ('54172')
  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 ('54172')
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.

N112SHBank Of Utah Trustee · Salt Lake City, UTBuilt 1966 · S/N 6567 N158DWSolamente Air LLC · Fort Wayne, INBuilt 1972 · S/N 72-21365 N17801Mckee John R · Central Point, ORBuilt 1968 · S/N 380352 N41776Warbirds-3 LLC · Kalispell, MTBuilt 1967 · S/N 1080820 N728LAJones Flying Association · Wilmington, DEBuilt 1972 · S/N 71-20818 N8136TEdgefield Aviation LLC · Sandy, ORBuilt 1972 · S/N 72-21213 N863LAEngage Helicopters LLC · Sarasota, FLBuilt 1968 · S/N 68-16904 N888DXAlexander Mary · Grants Pass, ORBuilt 1968 · S/N 380362

Back to Rolls-Royce 250-C10D