# Registered aircraft: AD 2018-20-01 A list on [AD 2018-20-01](https://openairdocs.org/ad/2018-20-01.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 18 · 879 aircraft - [N105JS](https://openairdocs.org/aircraft/N105JS.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2021 · S/N 43709 - [N109JS](https://openairdocs.org/aircraft/N109JS.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2021 · S/N 43712 - [N110JS](https://openairdocs.org/aircraft/N110JS.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2021 · S/N 43755 - [N115AM](https://openairdocs.org/aircraft/N115AM.md): Alc B379 122019 LLC · Camden, DE · Built 2021 · S/N 43371 - [N17254](https://openairdocs.org/aircraft/N17254.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2021 · S/N 43436 - [N17262](https://openairdocs.org/aircraft/N17262.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2021 · S/N 66594 - [N17264](https://openairdocs.org/aircraft/N17264.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2021 · S/N 66596 - [N17265](https://openairdocs.org/aircraft/N17265.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2021 · S/N 64454 - [N17272](https://openairdocs.org/aircraft/N17272.md): United Airlines Inc · Chicago, IL · Built 2022 · S/N 67527 - [N17279](https://openairdocs.org/aircraft/N17279.md): United Airlines Inc · Chicago, IL · Built 2022 · S/N 64613 - [N17285](https://openairdocs.org/aircraft/N17285.md): United Airlines Inc · Chicago, IL · Built 2022 · S/N 61853 - [N17289](https://openairdocs.org/aircraft/N17289.md): United Airlines Inc · Chicago, IL · Built 2023 · S/N 60712 - [N17294](https://openairdocs.org/aircraft/N17294.md): United Airlines Inc · Chicago, IL · Built 2023 · S/N 67551 - [N17296](https://openairdocs.org/aircraft/N17296.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67556 - [N17300](https://openairdocs.org/aircraft/N17300.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 43466 - [N17301](https://openairdocs.org/aircraft/N17301.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67554 - [N17302](https://openairdocs.org/aircraft/N17302.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67559 - [N17303](https://openairdocs.org/aircraft/N17303.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67561 - [N17306](https://openairdocs.org/aircraft/N17306.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67565 - [N17309](https://openairdocs.org/aircraft/N17309.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67563 - [N17310](https://openairdocs.org/aircraft/N17310.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2023 · S/N 67566 - [N17311](https://openairdocs.org/aircraft/N17311.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67567 - [N17312](https://openairdocs.org/aircraft/N17312.md): United Airlines Inc · Chicago, IL · Built 2019 · S/N 64609 - [N17314](https://openairdocs.org/aircraft/N17314.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2023 · S/N 67569 - [N17315](https://openairdocs.org/aircraft/N17315.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67597 - [N17316](https://openairdocs.org/aircraft/N17316.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67596 - [N17317](https://openairdocs.org/aircraft/N17317.md): United Airlines Inc · Chicago, IL · Built 2023 · S/N 67570 - [N17320](https://openairdocs.org/aircraft/N17320.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67576 - [N17321](https://openairdocs.org/aircraft/N17321.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2023 · S/N 67577 - [N17322](https://openairdocs.org/aircraft/N17322.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67575 - [N17326](https://openairdocs.org/aircraft/N17326.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67580 - [N17328](https://openairdocs.org/aircraft/N17328.md): United Airlines Inc · Chicago, IL · Built 2023 · S/N 67583 - [N17329](https://openairdocs.org/aircraft/N17329.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2023 · S/N 67581 - [N17331](https://openairdocs.org/aircraft/N17331.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2024 · S/N 67589 - [N17335](https://openairdocs.org/aircraft/N17335.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2024 · S/N 67595 - [N17336](https://openairdocs.org/aircraft/N17336.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2024 · S/N 67592 - [N17337](https://openairdocs.org/aircraft/N17337.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2024 · S/N 67593 - [N17338](https://openairdocs.org/aircraft/N17338.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2024 · S/N 67599 - [N17339](https://openairdocs.org/aircraft/N17339.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2024 · S/N 67601 - [N17341](https://openairdocs.org/aircraft/N17341.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67605 - [N17344](https://openairdocs.org/aircraft/N17344.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67622 - [N17346](https://openairdocs.org/aircraft/N17346.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67626 - [N17347](https://openairdocs.org/aircraft/N17347.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67618 - [N17349](https://openairdocs.org/aircraft/N17349.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67620 - [N17355](https://openairdocs.org/aircraft/N17355.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67617 - [N17356](https://openairdocs.org/aircraft/N17356.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67625 - [N17358](https://openairdocs.org/aircraft/N17358.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67628 - [N17359](https://openairdocs.org/aircraft/N17359.md): United Airlines Inc · Chicago, IL · Built 2025 · S/N 67634 - [N17361](https://openairdocs.org/aircraft/N17361.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 67632 - [N17362](https://openairdocs.org/aircraft/N17362.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 68808 Next page: https://openairdocs.org/ad/2018-20-01/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:2018-20-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-20-01') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2018-20-01/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.