# Registered aircraft: AD 97-26-12

A list on [AD 97-26-12](https://openairdocs.org/ad/97-26-12.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 5 · 234 aircraft

- [N105MA](https://openairdocs.org/aircraft/N105MA.md): Morrison Andrew · Haverford, PA · Built 1980 · S/N 31T-8104015
- [N108UC](https://openairdocs.org/aircraft/N108UC.md): Hot Springs Flyers Inc · Covington, LA · Built 1979 · S/N 31T-8020018
- [N111JF](https://openairdocs.org/aircraft/N111JF.md): Joyce Aviation Inc · Winston Salem, NC · Built 1981 · S/N 31T8120012
- [N114BA](https://openairdocs.org/aircraft/N114BA.md): Austin Bill DBA · Sparta, TN · S/N 42-8001027
- [N115BM](https://openairdocs.org/aircraft/N115BM.md): Ashland Water Group · Ashland, OH · Built 1982 · S/N 31T-8120053
- [N115PC](https://openairdocs.org/aircraft/N115PC.md): Dodson International Parts Inc · Pelkie, MI · Built 1977 · S/N 31T-7820001
- [N1183G](https://openairdocs.org/aircraft/N1183G.md): C A R Lease Corp · Brentwood, TN · Built 1979 · S/N 31T-7920086
- [N118HB](https://openairdocs.org/aircraft/N118HB.md): Td Air LLC · Cromwell, CT · Built 1980 · S/N 31T-8004052
- [N118WC](https://openairdocs.org/aircraft/N118WC.md): Halair Inc · Diablo, CA · Built 1979 · S/N 31T-8020020
- [N121LH](https://openairdocs.org/aircraft/N121LH.md): Tvpx Ars Inc Trustee · North Salt Lake, UT · Built 1990 · S/N 425501049
- [N129LC](https://openairdocs.org/aircraft/N129LC.md): L R & F LLC · Dover, DE · Built 1979 · S/N 31T7904042
- [N131HP](https://openairdocs.org/aircraft/N131HP.md): Pacific Integrated Handling Inc · Tacoma, WA · Built 1981 · S/N 31T-8166018
- [N131PC](https://openairdocs.org/aircraft/N131PC.md): Southern Aircraft Consultancy Inc Trustee · Casper, WY · Built 1977 · S/N 31T-7820009
- [N139CS](https://openairdocs.org/aircraft/N139CS.md): Cheyenne Flight Group LLC · Wallingford, CT · S/N 31T-8120004
- [N141TC](https://openairdocs.org/aircraft/N141TC.md): Ehs Aircraft LLC · Wilmington, DE · Built 1984 · S/N 42-5501021
- [N144PL](https://openairdocs.org/aircraft/N144PL.md): Catskill Transportation LLC · Kingston, NY · Built 1984 · S/N 42-5527014
- [N14886](https://openairdocs.org/aircraft/N14886.md): Fat Aire Inc · Wilmington, DE · S/N 31T-7904036
- [N14NE](https://openairdocs.org/aircraft/N14NE.md): Schroeder David C · Norfolk, NE · Built 1984 · S/N 31T-1104012
- [N14TN](https://openairdocs.org/aircraft/N14TN.md): Gonzalez-Ruiz Antonio R · Mountain Brk, AL · Built 1981 · S/N 31T-8120060
- [N154CA](https://openairdocs.org/aircraft/N154CA.md): Fedair Inc · Indianapolis, IN · Built 1980 · S/N 31T-8020085
- [N155MC](https://openairdocs.org/aircraft/N155MC.md): White Bay Aviation LLC · Corpus Christi, TX · Built 1978 · S/N 31T-7820069
- [N158MH](https://openairdocs.org/aircraft/N158MH.md): Mansfield Heliflight Inc · Milton, VT · S/N 42-5527006
- [N15KW](https://openairdocs.org/aircraft/N15KW.md): Ribitsch Robert L · Redondo Beach, CA · Built 1981 · S/N 31T-8166014
- [N165SW](https://openairdocs.org/aircraft/N165SW.md): N165sw LLC · Lagrange, GA · S/N 31T-7904051
- [N171JP](https://openairdocs.org/aircraft/N171JP.md): Central Virginia Aviation Inc · North Dinwiddie, VA · S/N 31T-7720028
- [N178SG](https://openairdocs.org/aircraft/N178SG.md): Tango Tango LLC · Naples, FL · S/N 31T-8020044
- [N181DC](https://openairdocs.org/aircraft/N181DC.md): Alliance Air Parts Acquisitions Corp · Oklahoma City, OK · Non-citizen corporation, flight hours not reported · S/N 31T-7520026
- [N186GA](https://openairdocs.org/aircraft/N186GA.md): Davis Aviation Inc DBA · Brandon, MS · S/N 31T-7820086
- [N190CA](https://openairdocs.org/aircraft/N190CA.md): Jag Air LLC · New Castle, DE · S/N 42-8001028
- [N195AA](https://openairdocs.org/aircraft/N195AA.md): Air Travel Management LLC · Lemont Furnace, PA · Built 1978 · S/N 31T7904001
- [N1976J](https://openairdocs.org/aircraft/N1976J.md): Lock Haven Aircraft Sales · Lock Haven, PA · Built 1974 · S/N 31T-7520005
- [N200PG](https://openairdocs.org/aircraft/N200PG.md): Panther Enterprises LLC · Fort Myers, FL · Built 1979 · S/N 31T-7920015
- [N200TS](https://openairdocs.org/aircraft/N200TS.md): Smith Ironworks Of Alabama LLC · Fort Payne, AL · Built 1978 · S/N 31T-7804002
- [N200XL](https://openairdocs.org/aircraft/N200XL.md): Condor Aviation LLC · Bethlehem, PA · Built 1981 · S/N 31T-8166010
- [N20WL](https://openairdocs.org/aircraft/N20WL.md): Sch Aviation Inc Trustee · Sporle Kings Lynn · Built 1976 · S/N 31T-7720011
- [N212KS](https://openairdocs.org/aircraft/N212KS.md): Kilo Sierra LLC · Dodge City, KS · Built 1979 · S/N 31T-7904010
- [N222GW](https://openairdocs.org/aircraft/N222GW.md): Dodson International Parts Inc · Rantoul, KS · S/N 31T-7904050
- [N225CA](https://openairdocs.org/aircraft/N225CA.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 1981 · S/N 31T-8104024
- [N225MB](https://openairdocs.org/aircraft/N225MB.md): Cheyenne III Flyers LLC · New York, NY · Built 1983 · S/N 42-8001102
- [N225PT](https://openairdocs.org/aircraft/N225PT.md): Curry Construction Inc · Mattoon, IL · Built 1981 · S/N 31T-8166032
- [N227TM](https://openairdocs.org/aircraft/N227TM.md): Med Care Inc · Grand Island, NE · S/N 31T-7400008
- [N22AW](https://openairdocs.org/aircraft/N22AW.md): Air What What LLC · Clackamas, OR · Built 1979 · S/N 31T-7920059
- [N22WF](https://openairdocs.org/aircraft/N22WF.md): Bemidji Aviation Services Inc · Bemidji, MN · Built 1978 · S/N 31T-7920007
- [N233PS](https://openairdocs.org/aircraft/N233PS.md): Dodson International Parts Inc · Rantoul, KS · Built 1978 · S/N 31T-7820039
- [N237PC](https://openairdocs.org/aircraft/N237PC.md): Blue Water Solutions Inc · Peachtree City, GA · Built 1981 · S/N 31T-8166045
- [N242RA](https://openairdocs.org/aircraft/N242RA.md): Johnston Properties LLC · Garden City, KS · S/N 42-8001003
- [N244AB](https://openairdocs.org/aircraft/N244AB.md): Parton Aviation Co LLC · Rutherfordton, NC · Built 1979 · S/N 31T-8004015
- [N2458W](https://openairdocs.org/aircraft/N2458W.md): Big Bend Outdoor Center LLC · Pittsburg, TX · Built 1979 · S/N 31T-8004017
- [N245JR](https://openairdocs.org/aircraft/N245JR.md): Aviation Trust Company LLC Trustee · Oklahoma City, OK · Built 1984 · S/N 425501019
- [N2556R](https://openairdocs.org/aircraft/N2556R.md): Red Willow Rescue Inc · Cooperstown, ND · Built 1979 · S/N 31T-8004003

Next page: https://openairdocs.org/ad/97-26-12/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-26-12')
  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-26-12')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/97-26-12/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.