# Registered aircraft: Embraer EMB-145

A list on [Embraer EMB-145](https://openairdocs.org/model/embraer-emb-145.md).

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

- [N47VA](https://openairdocs.org/aircraft/N47VA.md): Advanced Air LLC · Statesville, NC · Built 1999 · S/N 145110
- [N607AE](https://openairdocs.org/aircraft/N607AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145064
- [N610AE](https://openairdocs.org/aircraft/N610AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145073
- [N611AE](https://openairdocs.org/aircraft/N611AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145074
- [N612AE](https://openairdocs.org/aircraft/N612AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145079
- [N613AE](https://openairdocs.org/aircraft/N613AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145081
- [N697EE](https://openairdocs.org/aircraft/N697EE.md): Embraer Executive Aircraft Inc · Melbourne, FL · S/N 145-1197

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

This list as a web page: https://openairdocs.org/model/embraer-emb-145/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.