Skip to content

IAE V2500SERIES

Registered aircraft · 262

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

N562JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1948 N563JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2006 N564JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2020 N565JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2031 N566JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2042 N568JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2063 N569JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2075 N570JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2099 N571JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2125 N579JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2132 N580JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2136 N583JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2150 N584JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2149 N585JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2159 N586JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2160 N587JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2177 N588JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2201 N589JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2215 N590JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2231 N591JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2246 N592JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2259 N593JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2280 N594JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2284 N595JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2286 N597JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2307 N598JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2314 N599JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2336 N601AWAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 1935 N603JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2352 N604AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1196 N605JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2368 N606JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2384 N607JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2386 N608JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2415 N612JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2447 N613JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2449 N615JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2461 N618JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2489 N621JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2491 N623JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2504 N624JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2520 N625JBJetblue Airways Corporation · Long Island City, NYBuilt 2005 · S/N 2535 N627JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2577 N629JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2580 N630JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2640 N632JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2647 N633JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2671 N634JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2710 N635JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2725 N647AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1997 · S/N 762

Back to IAE V2500SERIES