# Registered aircraft: Embraer ERJ 190-100 ECJ

A list on [Embraer ERJ 190-100 ECJ](https://openairdocs.org/model/embraer-erj-190-100-ecj.md).

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

- [N527AH](https://openairdocs.org/aircraft/N527AH.md): Lineage Asset Company LLC · Wilmington, DE · Built 2016 · S/N 19000691
- [N713TS](https://openairdocs.org/aircraft/N713TS.md): Cactus Jack Airlines LLC · Beverly Hills, CA · Built 2015 · S/N 19000632
- [N783MM](https://openairdocs.org/aircraft/N783MM.md): Mandalay Resort Group LLC · Las Vegas, NV · Built 2016 · S/N 19000705
- [N785MM](https://openairdocs.org/aircraft/N785MM.md): Mirage Resorts LLC · Las Vegas, NV · Built 2016 · S/N 19000709

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

This list as a web page: https://openairdocs.org/model/embraer-erj-190-100-ecj/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, except the copies of manufacturers’ service documents, which belong to their rights holders.