# Registered aircraft: AD 2002-08-21 A list on [AD 2002-08-21](https://openairdocs.org/ad/2002-08-21.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 · 77 aircraft - [N1023C](https://openairdocs.org/aircraft/N1023C.md): Aero Aircraft Holdings II LLC · Van Nuys, CA · Built 2001 · S/N 145550 - [N11526](https://openairdocs.org/aircraft/N11526.md): Corporate Flight Managment Inc · Smyrna, TN · Built 2001 · S/N 145410 - [N135SX](https://openairdocs.org/aircraft/N135SX.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2003 · S/N 145728 - [N15509](https://openairdocs.org/aircraft/N15509.md): Corporate Flight Management Inc · Smyrna, TN · Built 2000 · S/N 145238 - [N15527](https://openairdocs.org/aircraft/N15527.md): Corporate Flight Management Inc · Smyrna, TN · Built 2001 · S/N 145413 - [N16501](https://openairdocs.org/aircraft/N16501.md): Corporate Flight Management Inc · Smyrna, TN · Built 1999 · S/N 145145 - [N16502](https://openairdocs.org/aircraft/N16502.md): Corporate Flight Management Inc · Smyrna, TN · Built 1999 · S/N 145166 - [N16510](https://openairdocs.org/aircraft/N16510.md): Corporate Flight Management Inc · Smyrna, TN · Built 2000 · S/N 145251 - [N16511](https://openairdocs.org/aircraft/N16511.md): Corporate Flight Management Inc · Smyrna, TN · Built 2000 · S/N 145267 - [N16525](https://openairdocs.org/aircraft/N16525.md): Corporate Flight Management DBA · Smyrna, TN · Built 2001 · S/N 145403 - [N17513](https://openairdocs.org/aircraft/N17513.md): Corporate Flight Management Inc · Smyrna, TN · Built 2000 · S/N 145292 - [N234BZ](https://openairdocs.org/aircraft/N234BZ.md): Rvr Air Charter LLC · Fort Worth, TX · Built 2001 · S/N 145388 - [N251JX](https://openairdocs.org/aircraft/N251JX.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 145235 - [N252JX](https://openairdocs.org/aircraft/N252JX.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 145276 - [N253JX](https://openairdocs.org/aircraft/N253JX.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 145328 - [N254JX](https://openairdocs.org/aircraft/N254JX.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 145275 - [N256JX](https://openairdocs.org/aircraft/N256JX.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 145211 - [N257JX](https://openairdocs.org/aircraft/N257JX.md): Delux Public Charter LLC · Dallas, TX · Built 2000 · S/N 145314 - [N258JX](https://openairdocs.org/aircraft/N258JX.md): Delux Public Charter LLC · Dallas, TX · Built 2001 · S/N 145386 - [N259JX](https://openairdocs.org/aircraft/N259JX.md): Delux Public Charter LLC · Dallas, TX · Built 2001 · S/N 145402 - [N260JX](https://openairdocs.org/aircraft/N260JX.md): Delux Public Charter LLC · Dallas, TX · S/N 145504 - [N261JX](https://openairdocs.org/aircraft/N261JX.md): Delux Public Charter LLC · Dallas, TX · Built 2001 · S/N 145512 - [N262JX](https://openairdocs.org/aircraft/N262JX.md): Delux Public Charter LLC · Dallas, TX · Built 2001 · S/N 145533 - [N263JX](https://openairdocs.org/aircraft/N263JX.md): Delux Public Charter LLC · Dallas, TX · Built 2001 · S/N 145399 - [N264JX](https://openairdocs.org/aircraft/N264JX.md): Delux Public Charter LLC · Dallas, TX · Built 2000 · S/N 145264 - [N266JX](https://openairdocs.org/aircraft/N266JX.md): Delux Public Charter LLC · Dallas, TX · Built 2003 · S/N 145726 - [N268JX](https://openairdocs.org/aircraft/N268JX.md): Delux Public Charter LLC · Dallas, TX · Built 2001 · S/N 145499 - [N27512](https://openairdocs.org/aircraft/N27512.md): Corporate Flight Management Inc · Smyrna, TN · Built 2000 · S/N 145274 - [N304CE](https://openairdocs.org/aircraft/N304CE.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 145326 - [N402AT](https://openairdocs.org/aircraft/N402AT.md): Aero Technologies Inc · Van Nuys, CA · Built 2003 · S/N 145702 - [N403RW](https://openairdocs.org/aircraft/N403RW.md): Rvr Air Charter LLC · Ft Worth, TX · Built 2000 · S/N 145262 - [N404AT](https://openairdocs.org/aircraft/N404AT.md): Aero Aircraft Holdings LLC · Van Nuys, CA · Built 2003 · S/N 145715 - [N47VA](https://openairdocs.org/aircraft/N47VA.md): Advanced Air LLC · Statesville, NC · Built 1999 · S/N 145110 - [N509GU](https://openairdocs.org/aircraft/N509GU.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2001 · S/N 145535 - [N530CN](https://openairdocs.org/aircraft/N530CN.md): Corporate Flight Management Inc DBA · Smyrna, TN · Built 2001 · S/N 145425 - [N531CN](https://openairdocs.org/aircraft/N531CN.md): Corporate Flight Management Inc DBA · Smyrna, TN · Built 2001 · S/N 145469 - [N532CN](https://openairdocs.org/aircraft/N532CN.md): Corporate Flight Management Inc DBA · Smyrna, TN · Built 2001 · S/N 145519 - [N534CN](https://openairdocs.org/aircraft/N534CN.md): Corporate Flight Management Inc DBA · Smyrna, TN · Built 2001 · S/N 145531 - [N535CN](https://openairdocs.org/aircraft/N535CN.md): Corporate Flight Management Inc DBA · Smyrna, TN · Built 2001 · S/N 145489 - [N538M](https://openairdocs.org/aircraft/N538M.md): Menards Inc · Eau Claire, WI · Built 2001 · S/N 145467 - [N540M](https://openairdocs.org/aircraft/N540M.md): Menard Inc · Eau Claire, WI · Built 2006 · S/N 14500977 - [N548M](https://openairdocs.org/aircraft/N548M.md): Ga-Erj135 LLC · Seiling, OK · Built 2000 · S/N 145364 - [N607AE](https://openairdocs.org/aircraft/N607AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145064 - [N610AE](https://openairdocs.org/aircraft/N610AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145073 - [N611AE](https://openairdocs.org/aircraft/N611AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145074 - [N612AE](https://openairdocs.org/aircraft/N612AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145079 - [N613AE](https://openairdocs.org/aircraft/N613AE.md): American Airlines Inc · Fort Worth, TX · Built 1998 · S/N 145081 - [N697EE](https://openairdocs.org/aircraft/N697EE.md): Embraer Executive Aircraft Inc · Melbourne, FL · S/N 145-1197 - [N704PG](https://openairdocs.org/aircraft/N704PG.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1999 · S/N 145174 - [N712AE](https://openairdocs.org/aircraft/N712AE.md): Aero Aircraft Holdings LLC · Van Nuys, CA · S/N 145247 Next page: https://openairdocs.org/ad/2002-08-21/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:2002-08-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-08-21') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2002-08-21/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.