# Registered aircraft: Embraer ERJ 170-100 LR

A list on [Embraer ERJ 170-100 LR](https://openairdocs.org/model/embraer-erj-170-100-lr.md).

Aircraft of this model in the FAA registry, by N-number.

- [N170EH](https://openairdocs.org/aircraft/N170EH.md): Honeywell Aerospace US LLC · Phoenix, AZ · Built 2004 · S/N 17000059
- [N175RS](https://openairdocs.org/aircraft/N175RS.md): Ang USA III LLC · Naples, FL · Built 2006 · S/N 17000141
- [N731SY](https://openairdocs.org/aircraft/N731SY.md): Skywest Airlines Inc · St George, UT · Built 2004 · S/N 17000009
- [N732SY](https://openairdocs.org/aircraft/N732SY.md): Skywest Airlines Inc · St George, UT · Built 2004 · S/N 17000011
- [N746CC](https://openairdocs.org/aircraft/N746CC.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2004 · S/N 17000042
- [N765ST](https://openairdocs.org/aircraft/N765ST.md): American Airlines Inc · Fort Worth, TX · Built 2006 · S/N 17000128
- [N769KW](https://openairdocs.org/aircraft/N769KW.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 17000024
- [N770JM](https://openairdocs.org/aircraft/N770JM.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 17000025
- [N771JV](https://openairdocs.org/aircraft/N771JV.md): American Airlines Inc · Fort Worth, TX · Built 2005 · S/N 17000087
- [N772MR](https://openairdocs.org/aircraft/N772MR.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 17000092
- [N787BP](https://openairdocs.org/aircraft/N787BP.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2005 · S/N 17000046
- [N791DK](https://openairdocs.org/aircraft/N791DK.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2004 · S/N 17000019
- [N875RW](https://openairdocs.org/aircraft/N875RW.md): Delta Air Lines Inc · Atlanta, GA · Built 2007 · S/N 17000180
- [N878RW](https://openairdocs.org/aircraft/N878RW.md): Delta Air Lines Inc · Atlanta, GA · Built 2007 · S/N 17000191
- [N879RW](https://openairdocs.org/aircraft/N879RW.md): Delta Air Lines Inc · Atlanta, GA · Built 2008 · S/N 17000227
- [N880RW](https://openairdocs.org/aircraft/N880RW.md): Delta Air Lines Inc · Atlanta, GA · S/N 17000247
- [N882RW](https://openairdocs.org/aircraft/N882RW.md): Delta Air Lines Inc · Atlanta, GA · Built 2008 · S/N 17000255

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 ('326040B')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/embraer-erj-170-100-lr/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.