# Registered aircraft: AD 2007-08-01 A list on [AD 2007-08-01](https://openairdocs.org/ad/2007-08-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 3 · 105 aircraft - [N10180](https://openairdocs.org/aircraft/N10180.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2004 · S/N C139 - [N104MD](https://openairdocs.org/aircraft/N104MD.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2002 · S/N C135 - [N118PA](https://openairdocs.org/aircraft/N118PA.md): Phoenix Air Group Inc · Cartersville, GA · Built 1989 · S/N 151 - [N185KJ](https://openairdocs.org/aircraft/N185KJ.md): Jah 2022a Saab340b Msn 185 LLC · Dallas, TX · Built 1990 · S/N 340B-185 - [N189EH](https://openairdocs.org/aircraft/N189EH.md): Bristow LLC · Lake Charles, LA · Built 2015 · S/N 49018 - [N189PA](https://openairdocs.org/aircraft/N189PA.md): Phoenix Air Group Inc · Cartersville, GA · Built 1985 · S/N 038 - [N214EB](https://openairdocs.org/aircraft/N214EB.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 28130 - [N219KA](https://openairdocs.org/aircraft/N219KA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1990 · S/N 340B192 - [N220MJ](https://openairdocs.org/aircraft/N220MJ.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-220 - [N252QA](https://openairdocs.org/aircraft/N252QA.md): Quality Aviation LLC · Boulder, CO · Built 2004 · S/N C-145 - [N253AE](https://openairdocs.org/aircraft/N253AE.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-253 - [N265JA](https://openairdocs.org/aircraft/N265JA.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-265 - [N266AE](https://openairdocs.org/aircraft/N266AE.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-266 - [N275ST](https://openairdocs.org/aircraft/N275ST.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 28106 - [N277ST](https://openairdocs.org/aircraft/N277ST.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 28140 - [N27XJ](https://openairdocs.org/aircraft/N27XJ.md): Phoenix Air Group Inc · Cartersville, GA · Built 1985 · S/N 340A-027 - [N286AE](https://openairdocs.org/aircraft/N286AE.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-286 - [N294TL](https://openairdocs.org/aircraft/N294TL.md): Aviation Inventory Resources Inc · Alvarado, TX · Built 1997 · S/N 340B-294 - [N298AE](https://openairdocs.org/aircraft/N298AE.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-298 - [N304AE](https://openairdocs.org/aircraft/N304AE.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1992 · S/N 340B-304 - [N304AG](https://openairdocs.org/aircraft/N304AG.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-418 - [N307AE](https://openairdocs.org/aircraft/N307AE.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-307 - [N313AE](https://openairdocs.org/aircraft/N313AE.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-313 - [N314SS](https://openairdocs.org/aircraft/N314SS.md): Bristow LLC · Lake Charles, LA · Built 2015 · S/N 49019 - [N3172](https://openairdocs.org/aircraft/N3172.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1989 · S/N 340B172 - [N317AE](https://openairdocs.org/aircraft/N317AE.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-317 - [N320AE](https://openairdocs.org/aircraft/N320AE.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-320 - [N323AE](https://openairdocs.org/aircraft/N323AE.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-323 - [N326LS](https://openairdocs.org/aircraft/N326LS.md): Bristow LLC · Lake Charles, LA · Built 2016 · S/N 49028 - [N327AG](https://openairdocs.org/aircraft/N327AG.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1997 · S/N 340B-427 - [N329AE](https://openairdocs.org/aircraft/N329AE.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-329 - [N331TB](https://openairdocs.org/aircraft/N331TB.md): Massachusetts Institute Of Technology · Lexington, MA · Built 1992 · S/N 340B-331 - [N332AE](https://openairdocs.org/aircraft/N332AE.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-332 - [N336SA](https://openairdocs.org/aircraft/N336SA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1993 · S/N 340B-336 - [N340RC](https://openairdocs.org/aircraft/N340RC.md): Consumer Aviation Inc · Springfield, MO · S/N 340B-340 - [N342JC](https://openairdocs.org/aircraft/N342JC.md): Aviation Investments Inc · Redondo Beach, CA · S/N 340A-030 - [N346AG](https://openairdocs.org/aircraft/N346AG.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1998 · S/N 340B446 - [N346CJ](https://openairdocs.org/aircraft/N346CJ.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 340B-346 - [N348AG](https://openairdocs.org/aircraft/N348AG.md): Aviation Inventory Resources Inc · Alvarado, TX · Built 1998 · S/N 340B-448 - [N351AG](https://openairdocs.org/aircraft/N351AG.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1998 · S/N 340B445 - [N352CJ](https://openairdocs.org/aircraft/N352CJ.md): Aviation Inventory Resources Inc · Alvarado, TX · Built 1993 · S/N 340B-352 - [N353SA](https://openairdocs.org/aircraft/N353SA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1993 · S/N 340B-351 - [N361CL](https://openairdocs.org/aircraft/N361CL.md): Legends Cargo Aircraft LLC · Lakeland, FL · Built 1994 · S/N 340B-361 - [N362AG](https://openairdocs.org/aircraft/N362AG.md): Jahn362ag LLC · Miami, FL · Built 1998 · S/N 340B-438 - [N364PX](https://openairdocs.org/aircraft/N364PX.md): Float Alaska Holdings LLC · Pomona, CA · S/N 340B-262 - [N369PX](https://openairdocs.org/aircraft/N369PX.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 340B-295 - [N383EC](https://openairdocs.org/aircraft/N383EC.md): Aeronave Corp · Kalispell, MT · Built 2007 · S/N C-177 - [N385RS](https://openairdocs.org/aircraft/N385RS.md): Aeronave Corp · Kalispell, MT · Built 1991 · S/N C-042 - [N390AL](https://openairdocs.org/aircraft/N390AL.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1990 · S/N 28198 - [N391AL](https://openairdocs.org/aircraft/N391AL.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 28103 Next page: https://openairdocs.org/ad/2007-08-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:2007-08-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:2007-08-01') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2007-08-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.