# Registered aircraft: AD 2016-17-13 A list on [AD 2016-17-13](https://openairdocs.org/ad/2016-17-13.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 4 · 179 aircraft - [N228LH](https://openairdocs.org/aircraft/N228LH.md): Aerovision Aircraft Services LLC · Norton Shores, MI · S/N 10028 - [N239LH](https://openairdocs.org/aircraft/N239LH.md): Aerovision Aircraft Services LLC · Muskegon, MI · S/N 10039 - [N317CA](https://openairdocs.org/aircraft/N317CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 10055 - [N331CA](https://openairdocs.org/aircraft/N331CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 10061 - [N340CA](https://openairdocs.org/aircraft/N340CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 10062 - [N354CA](https://openairdocs.org/aircraft/N354CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 10064 - [N355CA](https://openairdocs.org/aircraft/N355CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 10067 - [N367CA](https://openairdocs.org/aircraft/N367CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 10069 - [N368CA](https://openairdocs.org/aircraft/N368CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 10075 - [N371CA](https://openairdocs.org/aircraft/N371CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 10082 - [N376CA](https://openairdocs.org/aircraft/N376CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 10092 - [N379CA](https://openairdocs.org/aircraft/N379CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 10102 - [N390CA](https://openairdocs.org/aircraft/N390CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 10106 - [N391CA](https://openairdocs.org/aircraft/N391CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 10108 - [N398CA](https://openairdocs.org/aircraft/N398CA.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 10112 - [N500AE](https://openairdocs.org/aircraft/N500AE.md): American Airlines Inc · Fort Worth, TX · Built 2001 · S/N 10025 - [N501BG](https://openairdocs.org/aircraft/N501BG.md): American Airlines Inc · Fort Worth, TX · Built 2001 · S/N 10017 - [N502AE](https://openairdocs.org/aircraft/N502AE.md): American Airlines Inc · Fort Worth, TX · Built 2001 · S/N 10018 - [N503AE](https://openairdocs.org/aircraft/N503AE.md): American Airlines Inc · Fort Worth, TX · Built 2002 · S/N 10021 - [N504AE](https://openairdocs.org/aircraft/N504AE.md): American Airlines Inc · Fort Worth, TX · S/N 10044 - [N505AE](https://openairdocs.org/aircraft/N505AE.md): American Airlines Inc · Fort Worth, TX · Built 2002 · S/N 10053 - [N506AE](https://openairdocs.org/aircraft/N506AE.md): American Airlines Inc · Fort Worth, TX · Built 2002 · S/N 10056 - [N507AE](https://openairdocs.org/aircraft/N507AE.md): American Airlines Inc · Fort Worth, TX · Built 2002 · S/N 10059 - [N507GJ](https://openairdocs.org/aircraft/N507GJ.md): United Airlines Inc · Chicago, IL · Built 2001 · S/N 10014 - [N508AE](https://openairdocs.org/aircraft/N508AE.md): American Airlines Inc · Fort Worth, TX · Built 2002 · S/N 10072 - [N509AE](https://openairdocs.org/aircraft/N509AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10078 - [N510AE](https://openairdocs.org/aircraft/N510AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10105 - [N511AE](https://openairdocs.org/aircraft/N511AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10107 - [N512AE](https://openairdocs.org/aircraft/N512AE.md): American Airlines Inc · Fort Worth, TX · S/N 10110 - [N513AE](https://openairdocs.org/aircraft/N513AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10114 - [N513GJ](https://openairdocs.org/aircraft/N513GJ.md): United Airlines Inc · Chicago, IL · Built 2001 · S/N 10015 - [N514AE](https://openairdocs.org/aircraft/N514AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10119 - [N515AE](https://openairdocs.org/aircraft/N515AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10121 - [N515GJ](https://openairdocs.org/aircraft/N515GJ.md): Skywest Leasing Inc · St George, UT · S/N 10089 - [N516AE](https://openairdocs.org/aircraft/N516AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10123 - [N517AE](https://openairdocs.org/aircraft/N517AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10124 - [N518AE](https://openairdocs.org/aircraft/N518AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10126 - [N519AE](https://openairdocs.org/aircraft/N519AE.md): American Airlines Inc · Fort Worth, TX · Built 2003 · S/N 10131 - [N519JG](https://openairdocs.org/aircraft/N519JG.md): Joe Gibbs Racing LLC · Huntersville, NC · Built 2005 · S/N 10217 - [N520DC](https://openairdocs.org/aircraft/N520DC.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 10140 - [N520JG](https://openairdocs.org/aircraft/N520JG.md): Joe Gibbs Racing LLC · Huntersville, NC · Built 2002 · S/N 10052 - [N521AE](https://openairdocs.org/aircraft/N521AE.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 10142 - [N522AE](https://openairdocs.org/aircraft/N522AE.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 10147 - [N523AE](https://openairdocs.org/aircraft/N523AE.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 10152 - [N524AE](https://openairdocs.org/aircraft/N524AE.md): American Airlines Inc · Fort Worth, TX · Built 2004 · S/N 10154 - [N525AE](https://openairdocs.org/aircraft/N525AE.md): American Airlines Inc · Fort Worth, TX · Built 2010 · S/N 10302 - [N526EA](https://openairdocs.org/aircraft/N526EA.md): American Airlines Inc · Fort Worth, TX · Built 2010 · S/N 10304 - [N527EA](https://openairdocs.org/aircraft/N527EA.md): American Airlines Inc · Fort Worth, TX · Built 2010 · S/N 10305 - [N527GJ](https://openairdocs.org/aircraft/N527GJ.md): United Airlines Inc · Chicago, IL · S/N 10004 - [N528EG](https://openairdocs.org/aircraft/N528EG.md): American Airlines Inc · Fort Worth, TX · S/N 10306 Next page: https://openairdocs.org/ad/2016-17-13/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:2016-17-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-17-13') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2016-17-13/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.