Skip to content

Registered aircraft · 27

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

N4888UBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3258 N527NKGryphon Trading Company LLC · Fort Lauderdale, FLBuilt 2007 · S/N 2978 N730AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6132 N871UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1971 N872UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1986 N873UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 2004 N875UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2200 N876UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2203 N877UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 2232 N878UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2371 N879UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2408 N880UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2426 N881UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2435 N882UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2505 N883UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2574 N884UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2579 N889UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2667 N890UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2815 N891UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2901 N892UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2940 N893UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2948 N894UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2969 N895UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3020 N896UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3144 N897UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3269 N898UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3311 N899UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3342

Back to IAE V2524-A5