# Registered aircraft: Embraer ERJ 170-100SU

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

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

- [N741AK](https://openairdocs.org/aircraft/N741AK.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2006 · S/N 17000138
- [N742GR](https://openairdocs.org/aircraft/N742GR.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2006 · S/N 17000140
- [N743MB](https://openairdocs.org/aircraft/N743MB.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2006 · S/N 17000143
- [N744DB](https://openairdocs.org/aircraft/N744DB.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2006 · S/N 17000130
- [N780AH](https://openairdocs.org/aircraft/N780AH.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2006 · S/N 17000131
- [N781EJ](https://openairdocs.org/aircraft/N781EJ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2006 · S/N 17000148
- [N782SM](https://openairdocs.org/aircraft/N782SM.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2004 · S/N 17000022
- [N783LC](https://openairdocs.org/aircraft/N783LC.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2004 · S/N 17000018
- [N784DP](https://openairdocs.org/aircraft/N784DP.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2006 · S/N 17000144
- [N810MD](https://openairdocs.org/aircraft/N810MD.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2004 · S/N 17000026
- [N815MD](https://openairdocs.org/aircraft/N815MD.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2004 · S/N 17000034
- [N818MD](https://openairdocs.org/aircraft/N818MD.md): Umb Bank Na Trustee · Salt Lake City, UT · S/N 17000039
- [N823MD](https://openairdocs.org/aircraft/N823MD.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2005 · S/N 17000044
- [N824MD](https://openairdocs.org/aircraft/N824MD.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2005 · S/N 17000045

## 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 ('3260403')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/embraer-erj-170-100su/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.
