Skip to content

Embraer ERJ 170-100 SE

Registered aircraft · 40

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

N638RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000053 N639RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000057 N640RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000058 N641RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000062 N642RWRepublic Airways Inc · Carmel, INBuilt 2004 · S/N 17000063 N647RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000067 N648RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000068 N653RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000076 N654RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000104 N655RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000105 N656RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000113 N657RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000115 N739AEWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000080 N740MRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000082 N745JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000071 N748RRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000072 N749BMWilmington Trust Company Trustee · Wilmington, DEBuilt 2006 · S/N 17000133 N750BDWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000075 N751ABWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000078 N774JGWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000007 N776MSWilmington Trust Company Trustee · Wilmington, DEBuilt 2004 · S/N 17000050 N778RHWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000054 N779RNWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000055 N785BRWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000056 N786SMWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000052 N788CJWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000051 N789SSWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000060 N790MKWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000061 N792JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000064 N794JHWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000066 N798CCWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000070 N855RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000077 N857RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000079 N860RWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000084 N861RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000094 N862RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000098 N863RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000100 N864RWRepublic Airways Inc · Carmel, INBuilt 2006 · S/N 17000117 N865RWRepublic Airways Inc · Carmel, INBuilt 2006 · S/N 17000122 N979RPRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000088

Back to Embraer ERJ 170-100 SE