Skip to content

Embraer ERJ 170-100SU

Registered aircraft · 14

Aircraft of this model 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 aircraft_model_code IN ('3260403')
  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 aircraft_model_code IN ('3260403')
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.

N741AKWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000138 N742GRWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000140 N743MBWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000143 N744DBWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000130 N780AHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000131 N781EJWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000148 N782SMWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000022 N783LCWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000018 N784DPWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000144 N810MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000026 N815MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000034 N818MDUmb Bank Na Trustee · Salt Lake City, UTS/N 17000039 N823MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000044 N824MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000045

Back to Embraer ERJ 170-100SU