# Registered aircraft: AD 2012-19-08 A list on [AD 2012-19-08](https://openairdocs.org/ad/2012-19-08.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 2 · 100 aircraft - [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 - [N23983](https://openairdocs.org/aircraft/N23983.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66140 - [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 - [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 - [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 - [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 - [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 - [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 - [N29978](https://openairdocs.org/aircraft/N29978.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66137 - [N29981](https://openairdocs.org/aircraft/N29981.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66142 - [N29984](https://openairdocs.org/aircraft/N29984.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66143 - [N29985](https://openairdocs.org/aircraft/N29985.md): United Airlines Inc · Chicago, IL · Built 2020 · S/N 66144 - [N36962](https://openairdocs.org/aircraft/N36962.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 35880 - [N38950](https://openairdocs.org/aircraft/N38950.md): United Airlines Inc · Chicago, IL · Built 2014 · S/N 36401 - [N38955](https://openairdocs.org/aircraft/N38955.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 37814 - [N438AM](https://openairdocs.org/aircraft/N438AM.md): Bc2 43862 LLC · Camden, DE · Built 2017 · S/N 43862 - [N45905](https://openairdocs.org/aircraft/N45905.md): United Airlines Inc · Chicago, IL · Built 2012 · S/N 34825 - [N45956](https://openairdocs.org/aircraft/N45956.md): United Airlines Inc · Chicago, IL · Built 2015 · S/N 40918 - [N605UP](https://openairdocs.org/aircraft/N605UP.md): C C & E I LLC · Louisville, KY · Built 2017 · S/N 64252 - [N606UP](https://openairdocs.org/aircraft/N606UP.md): Cc & E I LLC · Louisville, KY · Built 2017 · S/N 64253 - [N634UP](https://openairdocs.org/aircraft/N634UP.md): United Parcel Service Co · Louisville, KY · Built 2013 · S/N 37564 - [N7478E](https://openairdocs.org/aircraft/N7478E.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2012 · S/N 37829 - [N781HA](https://openairdocs.org/aircraft/N781HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2023 · S/N 66429 - [N782HA](https://openairdocs.org/aircraft/N782HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2025 · S/N 66430 - [N783HA](https://openairdocs.org/aircraft/N783HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2025 · S/N 66431 Next page: https://openairdocs.org/ad/2012-19-08/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:2012-19-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-19-08') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2012-19-08/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.