# Registered aircraft: AD 97-04-15 A list on [AD 97-04-15](https://openairdocs.org/ad/97-04-15.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 · 96 aircraft - [N11LX](https://openairdocs.org/aircraft/N11LX.md): N492a LLC · Goodyear, AZ · Built 1974 · S/N 306-75 - [N131FL](https://openairdocs.org/aircraft/N131FL.md): Ifl Group Inc · Waterford, MI · Built 1955 · S/N 155 - [N136CA](https://openairdocs.org/aircraft/N136CA.md): Aviation Business Corp · Saint Louis, MO · S/N 400 - [N141FL](https://openairdocs.org/aircraft/N141FL.md): Ifl Group Inc · Waterford, MI · Built 1953 · S/N 111 - [N141SL](https://openairdocs.org/aircraft/N141SL.md): International Air Services Inc Trustee · Carson City, NV · Built 1978 · S/N 306-141 - [N151FL](https://openairdocs.org/aircraft/N151FL.md): Ifl Group Inc · Waterford, MI · Built 1953 · S/N 51 - [N158CL](https://openairdocs.org/aircraft/N158CL.md): United States Government · Fort Belvoir, VA · Built 1981 · S/N 58 - [N171FL](https://openairdocs.org/aircraft/N171FL.md): Ifl Group Inc · Waterford, MI · Built 1956 · S/N 318 - [N173A](https://openairdocs.org/aircraft/N173A.md): Bae Systems Technology Solutions & Services Inc · Mojave, CA · Built 1980 · S/N 465-20 - [N177RA](https://openairdocs.org/aircraft/N177RA.md): United States Government · Fort Belvoir, VA · Built 1982 · S/N 85 - [N181FL](https://openairdocs.org/aircraft/N181FL.md): Ifl Group Inc · Waterford, MI · Built 1956 · S/N 387 - [N193SJ](https://openairdocs.org/aircraft/N193SJ.md): Frontera Flight Holdings Inc · Dover, DE · S/N 193 - [N234HG](https://openairdocs.org/aircraft/N234HG.md): Aviation & Defense Inc · Calabasas, CA · S/N 382-4211 - [N247CS](https://openairdocs.org/aircraft/N247CS.md): Team Aero LLC · Shawnee, KS · Built 1994 · S/N 465-27 - [N265FT](https://openairdocs.org/aircraft/N265FT.md): Sunshine Aero Industries Inc · Crestview, FL · Built 1980 · S/N 465-46 - [N265WS](https://openairdocs.org/aircraft/N265WS.md): Portside Aero LLC · Edgewater, NJ · Built 1981 · S/N 465-62 - [N330EN](https://openairdocs.org/aircraft/N330EN.md): Universal Hydrogen Co · Hawthorne, CA · Built 1991 · S/N 274 - [N33JW](https://openairdocs.org/aircraft/N33JW.md): Bj Aviation LLC · Beaver Meadows, PA · Built 1974 · S/N 306-92 - [N33TR](https://openairdocs.org/aircraft/N33TR.md): Airborne Holdings Inc · Midlothian, TX · Built 1980 · S/N 465-47 - [N34HG](https://openairdocs.org/aircraft/N34HG.md): United States Government · Fort Belvoir, VA · S/N 34 - [N351FL](https://openairdocs.org/aircraft/N351FL.md): Gulf & Caribbean Cargo Inc · Waterford, MI · Built 1955 · S/N 279 - [N361FL](https://openairdocs.org/aircraft/N361FL.md): Gulf & Caribbean Cargo Inc · Waterford, MI · Built 1956 · S/N 343 - [N371FL](https://openairdocs.org/aircraft/N371FL.md): Ifl Group Inc · Waterford, MI · Built 1956 · S/N 309 - [N376D](https://openairdocs.org/aircraft/N376D.md): Bae Systems Tss Inc · Mojave, CA · Built 1981 · S/N 465-76 - [N378D](https://openairdocs.org/aircraft/N378D.md): National Test Pilot School · Mojave, CA · Built 1975 · S/N 306-101 - [N381FL](https://openairdocs.org/aircraft/N381FL.md): Ifl Group Inc · Waterford, MI · Built 1953 · S/N 276 - [N382HT](https://openairdocs.org/aircraft/N382HT.md): Cardinal Services Corp · Kalispell, MT · S/N 5032 - [N388HG](https://openairdocs.org/aircraft/N388HG.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2022 · S/N 5956 - [N391FL](https://openairdocs.org/aircraft/N391FL.md): Ifl Group Inc · Waterford, MI · Built 1955 · S/N 278 - [N39CB](https://openairdocs.org/aircraft/N39CB.md): Redstar Air Shows Inc · Discovery Bay, CA · Built 1976 · S/N 306-116 - [N404LC](https://openairdocs.org/aircraft/N404LC.md): Airplane Sales International Corp · Sherman Oaks, CA · Built 1977 · S/N 4763 - [N405LC](https://openairdocs.org/aircraft/N405LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1985 · S/N 5025 - [N407LC](https://openairdocs.org/aircraft/N407LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1991 · S/N 5225 - [N408LC](https://openairdocs.org/aircraft/N408LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1975 · S/N 4600 - [N47SE](https://openairdocs.org/aircraft/N47SE.md): Highlands Group LLC · Lahaina, HI · S/N 465-34 - [N48DD](https://openairdocs.org/aircraft/N48DD.md): Redstar Air Shows Inc · Discovery Bay, CA · Built 1979 · S/N 306146 - [N499NH](https://openairdocs.org/aircraft/N499NH.md): Haws Aviation LLC · Huntsville, AL · Built 1981 · S/N 465-56 - [N53993](https://openairdocs.org/aircraft/N53993.md): United States Government · Fort Belvoir, VA · Built 1985 · S/N 104 - [N539AR](https://openairdocs.org/aircraft/N539AR.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 539 - [N560WK](https://openairdocs.org/aircraft/N560WK.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 560 - [N563AW](https://openairdocs.org/aircraft/N563AW.md): US Department Of State · Melbourne, FL · S/N 563 - [N567WK](https://openairdocs.org/aircraft/N567WK.md): US Dept Of State · Melbourne, FL · S/N 567 - [N568AW](https://openairdocs.org/aircraft/N568AW.md): US Department Of State · Melbourne, FL · S/N 568 - [N569AW](https://openairdocs.org/aircraft/N569AW.md): US Department Of State · Melbourne, FL · S/N 569 - [N570AW](https://openairdocs.org/aircraft/N570AW.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 570 - [N580AR](https://openairdocs.org/aircraft/N580AR.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 580 - [N589AW](https://openairdocs.org/aircraft/N589AW.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 589 - [N58HT](https://openairdocs.org/aircraft/N58HT.md): American Air Charter Inc · Chesterfield, MO · Built 1981 · S/N 465-70 - [N599AR](https://openairdocs.org/aircraft/N599AR.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 599 - [N59AG](https://openairdocs.org/aircraft/N59AG.md): United States Government · Fort Belvoir, VA · Built 1981 · S/N 59 Next page: https://openairdocs.org/ad/97-04-15/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:97-04-15') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-04-15') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/97-04-15/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.