# Registered aircraft: Embraer ERJ 170-200 LR A list on [Embraer ERJ 170-200 LR](https://openairdocs.org/model/embraer-erj-170-200-lr.md). Aircraft of this model in the FAA registry, by N-number. - [N105HQ](https://openairdocs.org/aircraft/N105HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000163 - [N106HQ](https://openairdocs.org/aircraft/N106HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000164 - [N112HQ](https://openairdocs.org/aircraft/N112HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000174 - [N114SY](https://openairdocs.org/aircraft/N114SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000410 - [N118HQ](https://openairdocs.org/aircraft/N118HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000189 - [N122HQ](https://openairdocs.org/aircraft/N122HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000196 - [N123HQ](https://openairdocs.org/aircraft/N123HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000199 - [N130HQ](https://openairdocs.org/aircraft/N130HQ.md): Republic Airways Inc · Carmel, IN · Built 2008 · S/N 17000212 - [N133HQ](https://openairdocs.org/aircraft/N133HQ.md): Republic Airways Inc · Carmel, IN · Built 2008 · S/N 17000217 - [N156SY](https://openairdocs.org/aircraft/N156SY.md): Skywest Airlines Inc · St George, UT · Built 2016 · S/N 17000557 - [N160SY](https://openairdocs.org/aircraft/N160SY.md): Skywest Airlines Inc · St George, UT · Built 2016 · S/N 17000568 - [N161SY](https://openairdocs.org/aircraft/N161SY.md): Skywest Airlines Inc · St George, UT · Built 2016 · S/N 17000569 - [N164SY](https://openairdocs.org/aircraft/N164SY.md): Skywest Airlines Inc · St George, UT · Built 2016 · S/N 17000603 - [N185SY](https://openairdocs.org/aircraft/N185SY.md): Skywest Airlines Inc · Saint George, UT · Built 2016 · S/N 17000600 - [N186SY](https://openairdocs.org/aircraft/N186SY.md): Skywest Airlines Inc · Saint George, UT · Built 2016 · S/N 17000606 - [N207AN](https://openairdocs.org/aircraft/N207AN.md): American Airlines Inc · Fort Worth, TX · Built 2015 · S/N 17000490 - [N220JQ](https://openairdocs.org/aircraft/N220JQ.md): Delta Air Lines Inc · Atlanta, GA · Built 2007 · S/N 17000195 - [N220NN](https://openairdocs.org/aircraft/N220NN.md): American Airlines Inc · Fort Worth, TX · Built 2015 · S/N 17000523 - [N221JQ](https://openairdocs.org/aircraft/N221JQ.md): Delta Air Lines Inc · Atlanta, GA · Built 2007 · S/N 17000197 - [N222NS](https://openairdocs.org/aircraft/N222NS.md): American Airlines Inc · Fort Worth, TX · Built 2015 · S/N 17000528 - [N224SW](https://openairdocs.org/aircraft/N224SW.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · S/N 17000232 - [N225JQ](https://openairdocs.org/aircraft/N225JQ.md): Delta Air Lines Inc · Atlanta, GA · Built 2008 · S/N 17000210 - [N226JQ](https://openairdocs.org/aircraft/N226JQ.md): Delta Air Lines Inc · Atlanta, GA · Built 2008 · S/N 17000213 - [N227JQ](https://openairdocs.org/aircraft/N227JQ.md): Delta Air Lines Inc · Atlanta, GA · Built 2008 · S/N 17000214 - [N228JQ](https://openairdocs.org/aircraft/N228JQ.md): Delta Air Lines Inc · Atlanta, GA · Built 2008 · S/N 17000218 - [N232NN](https://openairdocs.org/aircraft/N232NN.md): American Airlines Inc · Fort Worth, TX · Built 2016 · S/N 17000560 - [N233NN](https://openairdocs.org/aircraft/N233NN.md): American Airlines Inc · Fort Worth, TX · Built 2016 · S/N 17000561 - [N235JQ](https://openairdocs.org/aircraft/N235JQ.md): Delta Air Lines Inc · Atlanta, GA · Built 2008 · S/N 17000233 - [N247NN](https://openairdocs.org/aircraft/N247NN.md): American Airlines Inc · Fort Worth, TX · Built 2016 · S/N 17000619 - [N257NN](https://openairdocs.org/aircraft/N257NN.md): American Airlines Inc · Fort Worth, TX · Built 2017 · S/N 17000674 - [N258NN](https://openairdocs.org/aircraft/N258NN.md): American Airlines Inc · Fort Worth, TX · Built 2017 · S/N 17000675 - [N261SY](https://openairdocs.org/aircraft/N261SY.md): Skywest Airlines Inc · St George, UT · Built 2017 · S/N 17000704 - [N328DS](https://openairdocs.org/aircraft/N328DS.md): American Airlines Inc · Fort Worth, TX · Built 2024 · S/N 17000984 - [N337MR](https://openairdocs.org/aircraft/N337MR.md): American Airlines Inc · Fort Worth, TX · S/N 17001013 - [N359MH](https://openairdocs.org/aircraft/N359MH.md): American Airlines Inc · Fort Worth, TX · S/N 17001046 - [N408YX](https://openairdocs.org/aircraft/N408YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000371 - [N409YX](https://openairdocs.org/aircraft/N409YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000372 - [N410YX](https://openairdocs.org/aircraft/N410YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000373 - [N411YX](https://openairdocs.org/aircraft/N411YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000374 - [N412YX](https://openairdocs.org/aircraft/N412YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000375 - [N413YX](https://openairdocs.org/aircraft/N413YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000376 - [N414YX](https://openairdocs.org/aircraft/N414YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000377 - [N415YX](https://openairdocs.org/aircraft/N415YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000378 - [N416YX](https://openairdocs.org/aircraft/N416YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000381 - [N417YX](https://openairdocs.org/aircraft/N417YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000382 - [N418YX](https://openairdocs.org/aircraft/N418YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000383 - [N419YX](https://openairdocs.org/aircraft/N419YX.md): Republic Airways Inc · Carmel, IN · Built 2013 · S/N 17000384 - [N743YX](https://openairdocs.org/aircraft/N743YX.md): United Airlines Inc · Chicago, IL · Built 2017 · S/N 17000660 - [N749YX](https://openairdocs.org/aircraft/N749YX.md): United Airlines Inc · Chicago, IL · Built 2017 · S/N 17000685 - [N88359](https://openairdocs.org/aircraft/N88359.md): United Airlines Inc · Chicago, IL · Built 2017 · S/N 17000696 ## 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 ('3260410') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/model/embraer-erj-170-200-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.