# Registered aircraft: AD 2017-24-03 A list on [AD 2017-24-03](https://openairdocs.org/ad/2017-24-03.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 19 · 938 aircraft - [N101NN](https://openairdocs.org/aircraft/N101NN.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2013 · S/N 5834 - [N102NN](https://openairdocs.org/aircraft/N102NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2013 · S/N 5860 - [N102UW](https://openairdocs.org/aircraft/N102UW.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1998 · S/N 0844 - [N103NN](https://openairdocs.org/aircraft/N103NN.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2013 · S/N 5884 - [N103US](https://openairdocs.org/aircraft/N103US.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1999 · S/N 0861 - [N104NN](https://openairdocs.org/aircraft/N104NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2013 · S/N 5895 - [N104UW](https://openairdocs.org/aircraft/N104UW.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1999 · S/N 0863 - [N105NN](https://openairdocs.org/aircraft/N105NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2013 · S/N 5904 - [N105UW](https://openairdocs.org/aircraft/N105UW.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1999 · S/N 0868 - [N106NN](https://openairdocs.org/aircraft/N106NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2014 · S/N 5932 - [N107NN](https://openairdocs.org/aircraft/N107NN.md): Umb Bank N A Trustee · Salt Lake City, UT · Built 2014 · S/N 5938 - [N107US](https://openairdocs.org/aircraft/N107US.md): American Airlines Inc · Fort Worth, TX · Built 1999 · S/N 1052 - [N108NN](https://openairdocs.org/aircraft/N108NN.md): American Airlines Inc · Fort Worth, TX · Built 2014 · S/N 5946 - [N108UW](https://openairdocs.org/aircraft/N108UW.md): American Airlines Inc · Fort Worth, TX · Built 1999 · S/N 1061 - [N109NN](https://openairdocs.org/aircraft/N109NN.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2014 · S/N 5955 - [N109UW](https://openairdocs.org/aircraft/N109UW.md): American Airlines Inc · Fort Worth, TX · Built 1999 · S/N 1065 - [N110AN](https://openairdocs.org/aircraft/N110AN.md): American Airlines Inc · Fort Worth, TX · Built 2014 · S/N 5975 - [N110UW](https://openairdocs.org/aircraft/N110UW.md): American Airlines Inc · Fort Worth, TX · Built 1999 · S/N 1112 - [N111US](https://openairdocs.org/aircraft/N111US.md): American Airlines Inc · Fort Worth, TX · Built 1999 · S/N 1114 - [N111ZM](https://openairdocs.org/aircraft/N111ZM.md): American Airlines Inc · Fort Worth, TX · Built 2014 · S/N 5983 - [N112AN](https://openairdocs.org/aircraft/N112AN.md): American Airlines Inc · Fort Worth, TX · Built 2014 · S/N 5991 - [N112US](https://openairdocs.org/aircraft/N112US.md): American Airlines Inc · Fort Worth, TX · Built 1999 · S/N 1134 - [N113AN](https://openairdocs.org/aircraft/N113AN.md): American Airlines Inc · Fort Worth, TX · Built 2014 · S/N 6020 - [N114UW](https://openairdocs.org/aircraft/N114UW.md): American Airlines Inc · Fort Worth, TX · Built 1999 · S/N 1148 - [N115NN](https://openairdocs.org/aircraft/N115NN.md): American Airlines Inc · Fort Worth, TX · Built 2014 · S/N 6063 - [N116AN](https://openairdocs.org/aircraft/N116AN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2014 · S/N 6070 - [N117AN](https://openairdocs.org/aircraft/N117AN.md): American Airlines Inc · Fort Worth, TX · Built 2014 · S/N 6094 - [N117UW](https://openairdocs.org/aircraft/N117UW.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 1224 - [N118NN](https://openairdocs.org/aircraft/N118NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2014 · S/N 6162 - [N118US](https://openairdocs.org/aircraft/N118US.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 1264 - [N119NN](https://openairdocs.org/aircraft/N119NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2014 · S/N 6222 - [N119US](https://openairdocs.org/aircraft/N119US.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 1268 - [N12028](https://openairdocs.org/aircraft/N12028.md): American Airlines Inc · Fort Worth, TX · Built 2015 · S/N 6456 - [N120EE](https://openairdocs.org/aircraft/N120EE.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2014 · S/N 6227 - [N121AN](https://openairdocs.org/aircraft/N121AN.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2014 · S/N 6238 - [N121UW](https://openairdocs.org/aircraft/N121UW.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 1294 - [N122NN](https://openairdocs.org/aircraft/N122NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2014 · S/N 6252 - [N122US](https://openairdocs.org/aircraft/N122US.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 1298 - [N123NN](https://openairdocs.org/aircraft/N123NN.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2014 · S/N 6256 - [N123UW](https://openairdocs.org/aircraft/N123UW.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 1310 - [N124AA](https://openairdocs.org/aircraft/N124AA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2014 · S/N 6271 - [N124US](https://openairdocs.org/aircraft/N124US.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 1314 - [N125AA](https://openairdocs.org/aircraft/N125AA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2014 · S/N 6272 - [N125UW](https://openairdocs.org/aircraft/N125UW.md): American Airlines Inc · Forth Worth, TX · Built 2009 · S/N 4086 - [N126AN](https://openairdocs.org/aircraft/N126AN.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2014 · S/N 6313 - [N126UW](https://openairdocs.org/aircraft/N126UW.md): American Airlines Inc · Forth Worth, TX · Built 2009 · S/N 4149 - [N127AA](https://openairdocs.org/aircraft/N127AA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2014 · S/N 6334 - [N127UW](https://openairdocs.org/aircraft/N127UW.md): American Airlines Inc · Fort Worth, TX · Built 2010 · S/N 4202 - [N128AN](https://openairdocs.org/aircraft/N128AN.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2014 · S/N 6346 - [N128UW](https://openairdocs.org/aircraft/N128UW.md): American Airlines Inc · Fort Worth, TX · Built 2010 · S/N 4242 Next page: https://openairdocs.org/ad/2017-24-03/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-24-03') 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-24-03') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2017-24-03/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.