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.

N649AWBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 803 N650AWU S Bank N A Trustee · Boston, MABuilt 1998 · S/N 856 N652AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 0953 N653AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1003 N654AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1050 N655AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1075 N656AWU S Bank N A Trustee · Boston, MABuilt 1999 · S/N 1079 N657AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1083 N658AWWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 1110 N659AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1166 N660AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1234 N661AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1284 N662AWUS Bank National Association Trustee · Boston, MABuilt 2000 · S/N 1274 N663AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1419 N664AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1621 N665AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1644 N667AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1710 N668AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1764 N669AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1792 N679AWBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 2613 N680AWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2005 · S/N 2630 N801AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0889 N801UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 686 N802AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0924 N802UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 690 N803AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0931 N803UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 0748 N804AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1043 N804UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 0759 N805AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1049 N805UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0783 N806AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1056 N806UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0788 N807AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1064 N807UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0798 N808AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1088 N808UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0804 N809AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1111 N809UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0825 N810AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1116 N810UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0843 N811UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0847 N812AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1178 N812UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0850 N813AWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 1223 N813UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0858 N814AWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 1281 N814UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0862 N815AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1323 N815UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0867

Back to IAE V2500SERIES