# Registered aircraft: AD 2019-06-13 A list on [AD 2019-06-13](https://openairdocs.org/ad/2019-06-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 · 193 aircraft - [N128AM](https://openairdocs.org/aircraft/N128AM.md): Bc2 42019 LLC · Camden, DE · Built 2019 · S/N 65313 - [N13954](https://openairdocs.org/aircraft/N13954.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 36405 - [N15969](https://openairdocs.org/aircraft/N15969.md): United Airlines Inc · Chicago, IL · Built 2017 · S/N 60142 - [N17963](https://openairdocs.org/aircraft/N17963.md): United Airlines Inc · Chicago, IL · Built 2016 · S/N 37812 - [N183AM](https://openairdocs.org/aircraft/N183AM.md): Alc B879 60285 LLC · Camden, DE · Built 2016 · S/N 60285 - [N19951](https://openairdocs.org/aircraft/N19951.md): United Airlines Inc · Chicago, IL · Built 2014 · S/N 36402 - [N19986](https://openairdocs.org/aircraft/N19986.md): United Airlines Inc · Chicago, IL · Built 2021 · S/N 66145 - [N20904](https://openairdocs.org/aircraft/N20904.md): United Airlines Inc · Chicago, IL · Built 2012 · S/N 34824 - [N21102](https://openairdocs.org/aircraft/N21102.md): United Airlines Inc · Chicago, IL · Built 2026 · S/N 68648 - [N22992](https://openairdocs.org/aircraft/N22992.md): United Airlines Inc · Chicago, IL · Built 2025 · S/N 63634 - [N22995](https://openairdocs.org/aircraft/N22995.md): United Airlines Inc · Chicago, IL · Built 2025 · S/N 68623 - [N23983](https://openairdocs.org/aircraft/N23983.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66140 - [N23994](https://openairdocs.org/aircraft/N23994.md): United Airlines Inc · Chicago, IL · Built 2025 · S/N 68622 - [N24972](https://openairdocs.org/aircraft/N24972.md): United Airlines Inc · Chicago, IL · Built 2018 · S/N 40939 - [N24973](https://openairdocs.org/aircraft/N24973.md): United Airlines Inc · Chicago, IL · Built 2018 · S/N 40941 - [N24974](https://openairdocs.org/aircraft/N24974.md): United Airlines Inc · Chicago, IL · Built 2018 · S/N 40942 - [N24976](https://openairdocs.org/aircraft/N24976.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66135 - [N24979](https://openairdocs.org/aircraft/N24979.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66141 - [N24980](https://openairdocs.org/aircraft/N24980.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66138 - [N24988](https://openairdocs.org/aircraft/N24988.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 37449 - [N24990](https://openairdocs.org/aircraft/N24990.md): United Airlines Inc · Chicago, IL · Built 2024 · S/N 38276 - [N24993](https://openairdocs.org/aircraft/N24993.md): United Airlines Inc · Chicago, IL · Built 2025 · S/N 38269 - [N25982](https://openairdocs.org/aircraft/N25982.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66139 - [N26902](https://openairdocs.org/aircraft/N26902.md): United Airlines Inc · Chicago, IL · Built 2012 · S/N 34822 - [N26906](https://openairdocs.org/aircraft/N26906.md): United Airlines Inc · Chicago, IL · Built 2012 · S/N 34829 - [N26909](https://openairdocs.org/aircraft/N26909.md): United Airlines Inc · Chicago, IL · Built 2014 · S/N 34827 - [N26910](https://openairdocs.org/aircraft/N26910.md): United Airlines Inc · Chicago, IL · Built 2014 · S/N 34826 - [N26952](https://openairdocs.org/aircraft/N26952.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 36403 - [N26960](https://openairdocs.org/aircraft/N26960.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 36408 - [N26966](https://openairdocs.org/aircraft/N26966.md): United Airlines Inc · Chicago, IL · Built 2016 · S/N 60143 - [N26967](https://openairdocs.org/aircraft/N26967.md): United Airlines Inc · Chicago, IL · Built 2016 · S/N 60144 - [N26970](https://openairdocs.org/aircraft/N26970.md): United Airlines Inc · Chicago, IL · Built 2017 · S/N 60146 - [N26996](https://openairdocs.org/aircraft/N26996.md): United Airlines Inc · Chicago, IL · Built 2025 · S/N 68624 - [N27901](https://openairdocs.org/aircraft/N27901.md): United Airlines Inc · Chicago, IL · Built 2012 · S/N 34821 - [N27903](https://openairdocs.org/aircraft/N27903.md): United Airlines Inc · Chicago, IL · Built 2012 · S/N 34823 - [N27908](https://openairdocs.org/aircraft/N27908.md): United Airlines Inc · Chicago, IL · Built 2013 · S/N 36400 - [N27957](https://openairdocs.org/aircraft/N27957.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 36409 - [N27958](https://openairdocs.org/aircraft/N27958.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 36406 - [N27959](https://openairdocs.org/aircraft/N27959.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 36407 - [N27964](https://openairdocs.org/aircraft/N27964.md): United Airlines Inc · Chicago, IL · Built 2016 · S/N 37813 - [N27965](https://openairdocs.org/aircraft/N27965.md): United Airlines Inc · Chicago, IL · Built 2016 · S/N 37815 - [N27997](https://openairdocs.org/aircraft/N27997.md): United Airlines Inc · Chicago, IL · Built 2025 · S/N 68625 - [N28912](https://openairdocs.org/aircraft/N28912.md): United Airlines Inc · Chicago, IL · Built 2014 · S/N 34828 - [N28987](https://openairdocs.org/aircraft/N28987.md): United Airlines Inc · Chicago, IL · Built 2021 · S/N 66146 - [N29907](https://openairdocs.org/aircraft/N29907.md): United Airlines Inc · Chicago, IL · Built 2013 · S/N 34830 - [N29961](https://openairdocs.org/aircraft/N29961.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 37811 - [N29968](https://openairdocs.org/aircraft/N29968.md): United Airlines Inc · Chicago, IL · Built 2016 · S/N 60141 - [N29971](https://openairdocs.org/aircraft/N29971.md): United Airlines Inc · Chicago, IL · Built 2017 · S/N 60147 - [N29975](https://openairdocs.org/aircraft/N29975.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66134 - [N29977](https://openairdocs.org/aircraft/N29977.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66136 Next page: https://openairdocs.org/ad/2019-06-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:2019-06-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:2019-06-13') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2019-06-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.