# Registered aircraft: AD 2008-08-21 A list on [AD 2008-08-21](https://openairdocs.org/ad/2008-08-21.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 15 · 729 aircraft - [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 - [N1073P](https://openairdocs.org/aircraft/N1073P.md): Tvpx Ars Inc Trustee · North Salt Lake, UT · S/N 19000107 - [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 - [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 - [N118SY](https://openairdocs.org/aircraft/N118SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000420 - [N119HQ](https://openairdocs.org/aircraft/N119HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000190 - [N119SY](https://openairdocs.org/aircraft/N119SY.md): Skywest Airlines Inc · Saint George, UT · Built 2014 · S/N 17000421 - [N120BZ](https://openairdocs.org/aircraft/N120BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000115 - [N120HQ](https://openairdocs.org/aircraft/N120HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000193 - [N120SY](https://openairdocs.org/aircraft/N120SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000425 - [N121HQ](https://openairdocs.org/aircraft/N121HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000194 - [N121SY](https://openairdocs.org/aircraft/N121SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000430 - [N122HQ](https://openairdocs.org/aircraft/N122HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000196 - [N122SY](https://openairdocs.org/aircraft/N122SY.md): Skywest Airlines Inc · Saint George, UT · Built 2014 · S/N 17000431 - [N123HQ](https://openairdocs.org/aircraft/N123HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000199 - [N124HQ](https://openairdocs.org/aircraft/N124HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000200 - [N124SY](https://openairdocs.org/aircraft/N124SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000439 - [N125HQ](https://openairdocs.org/aircraft/N125HQ.md): Republic Airways Inc · Carmel, IN · Built 2007 · S/N 17000202 - [N125SY](https://openairdocs.org/aircraft/N125SY.md): Sky West Airlines Inc · St George, UT · Built 2014 · S/N 17000440 - [N126BZ](https://openairdocs.org/aircraft/N126BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000124 - [N126HQ](https://openairdocs.org/aircraft/N126HQ.md): Republic Airways Inc · Carmel, IN · Built 2008 · S/N 17000204 - [N127HQ](https://openairdocs.org/aircraft/N127HQ.md): Republic Airways Inc · Carmel, IN · Built 2008 · S/N 17000206 - [N127SY](https://openairdocs.org/aircraft/N127SY.md): Skywest Airlines Inc · St George, UT · Built 2014 · S/N 17000441 - [N128BZ](https://openairdocs.org/aircraft/N128BZ.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2007 · S/N 19000132 Next page: https://openairdocs.org/ad/2008-08-21/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:2008-08-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-08-21') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2008-08-21/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.