# Registered aircraft: AD 2017-09-09 A list on [AD 2017-09-09](https://openairdocs.org/ad/2017-09-09.md). Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability. Page 1 of 28 · 1,400 aircraft - [N10156](https://openairdocs.org/aircraft/N10156.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 145786 - [N101HQ](https://openairdocs.org/aircraft/N101HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000156 - [N102HQ](https://openairdocs.org/aircraft/N102HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000157 - [N103HQ](https://openairdocs.org/aircraft/N103HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000159 - [N104HQ](https://openairdocs.org/aircraft/N104HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000160 - [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 - [N106SY](https://openairdocs.org/aircraft/N106SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000399 - [N107HQ](https://openairdocs.org/aircraft/N107HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000165 - [N107SY](https://openairdocs.org/aircraft/N107SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000400 - [N108HQ](https://openairdocs.org/aircraft/N108HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000166 - [N108MP](https://openairdocs.org/aircraft/N108MP.md): Aircraft Propeller Service LLC · Lake Zurich, IL · S/N 19000108 - [N109HQ](https://openairdocs.org/aircraft/N109HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000168 - [N109SY](https://openairdocs.org/aircraft/N109SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000404 - [N110HQ](https://openairdocs.org/aircraft/N110HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000172 - [N11106](https://openairdocs.org/aircraft/N11106.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 145650 - [N11107](https://openairdocs.org/aircraft/N11107.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 145654 - [N11113](https://openairdocs.org/aircraft/N11113.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 145662 - [N11119](https://openairdocs.org/aircraft/N11119.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 145677 - [N11121](https://openairdocs.org/aircraft/N11121.md): United Airlines Inc · Chicago, IL · Built 2003 · S/N 145683 - [N11127](https://openairdocs.org/aircraft/N11127.md): United Airlines Inc · Chicago, IL · Built 2003 · S/N 145697 - [N11140](https://openairdocs.org/aircraft/N11140.md): United Airlines Inc · Chicago, IL · Built 2003 · S/N 145732 - [N11150](https://openairdocs.org/aircraft/N11150.md): United Airlines Inc · Chicago, IL · Built 2003 · S/N 145756 - [N11164](https://openairdocs.org/aircraft/N11164.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 14500817 - [N11165](https://openairdocs.org/aircraft/N11165.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 14500819 - [N11176](https://openairdocs.org/aircraft/N11176.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 14500881 - [N11181](https://openairdocs.org/aircraft/N11181.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500904 - [N11184](https://openairdocs.org/aircraft/N11184.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500917 - [N11187](https://openairdocs.org/aircraft/N11187.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500927 - [N11189](https://openairdocs.org/aircraft/N11189.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500931 - [N11191](https://openairdocs.org/aircraft/N11191.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500935 - [N11192](https://openairdocs.org/aircraft/N11192.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500936 - [N11193](https://openairdocs.org/aircraft/N11193.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500938 - [N11194](https://openairdocs.org/aircraft/N11194.md): United Airlines Inc · Chicago, IL · Built 2005 · S/N 14500940 - [N11199](https://openairdocs.org/aircraft/N11199.md): United Airlines Inc · Chicago, IL · Built 2006 · S/N 14500953 - [N111HQ](https://openairdocs.org/aircraft/N111HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000173 - [N111NH](https://openairdocs.org/aircraft/N111NH.md): E190 Msn111 LLC · Dover, DE · Built 2007 · S/N 19000111 - [N112BZ](https://openairdocs.org/aircraft/N112BZ.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 19000077 - [N112HQ](https://openairdocs.org/aircraft/N112HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000174 - [N113HQ](https://openairdocs.org/aircraft/N113HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000177 - [N114BZ](https://openairdocs.org/aircraft/N114BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000092 - [N114HQ](https://openairdocs.org/aircraft/N114HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000179 - [N114SY](https://openairdocs.org/aircraft/N114SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000410 - [N115BZ](https://openairdocs.org/aircraft/N115BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · S/N 19000096 - [N115HQ](https://openairdocs.org/aircraft/N115HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000182 - [N116BZ](https://openairdocs.org/aircraft/N116BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · S/N 19000101 - [N116HQ](https://openairdocs.org/aircraft/N116HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000183 - [N117HQ](https://openairdocs.org/aircraft/N117HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000184 - [N117SY](https://openairdocs.org/aircraft/N117SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000416 - [N118HQ](https://openairdocs.org/aircraft/N118HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000189 Next page: https://openairdocs.org/ad/2017-09-09/aircraft.md?page=2 ## 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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2017-09-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-09-09') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2017-09-09/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.