# Registered aircraft: AD 97-15-01

A list on [AD 97-15-01](https://openairdocs.org/ad/97-15-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 399 · 19,950 aircraft

- [N10006](https://openairdocs.org/aircraft/N10006.md): Coutches Robert Hercules DBA · Livermore, CA · Built 1955 · S/N BG-72
- [N1000L](https://openairdocs.org/aircraft/N1000L.md): Wise Joe · Kilgore, TX · Built 1966 · S/N TC-1000
- [N1000N](https://openairdocs.org/aircraft/N1000N.md): Anderson Aerial Spraying Service Inc · Canby, MN · Built 1963 · S/N 310H0104
- [N1000Q](https://openairdocs.org/aircraft/N1000Q.md): Ernest Obregon · Oakley, CA · S/N 310P0195
- [N1000T](https://openairdocs.org/aircraft/N1000T.md): Haughton Douglas L · Gig Harbor, WA · Built 1957 · S/N D-4980
- [N1000Y](https://openairdocs.org/aircraft/N1000Y.md): Barkhimer James C · Iraan, TX · Built 1954 · S/N 30999
- [N1001Q](https://openairdocs.org/aircraft/N1001Q.md): Registered aircraft · Built 1962 · S/N 310H0001
- [N1002Q](https://openairdocs.org/aircraft/N1002Q.md): Swanson Dale A · Nashua, NH · Built 1962 · S/N 310H0002
- [N1005Q](https://openairdocs.org/aircraft/N1005Q.md): Registration Pending · Fairmont, WV · Registration pending · S/N 310H0005
- [N1007F](https://openairdocs.org/aircraft/N1007F.md): 007 Aviation LLC · Wilmington, DE · Built 1968 · S/N TC-1163
- [N1007T](https://openairdocs.org/aircraft/N1007T.md): Hollar Larry · Winston Salem, NC · Built 1973 · S/N 18262411
- [N1009P](https://openairdocs.org/aircraft/N1009P.md): Ferrier William T · Woodland, CA · Built 1958 · S/N 34994
- [N1009Q](https://openairdocs.org/aircraft/N1009Q.md): Watson James E Jr · Victor, CO · Built 1962 · S/N 310H0009
- [N100B](https://openairdocs.org/aircraft/N100B.md): Marshall Xavier T · Carson, CA · S/N 57114
- [N100CA](https://openairdocs.org/aircraft/N100CA.md): Fass Flyers LLC · Garden Ridge, TX · Built 1978 · S/N 18266536
- [N100FB](https://openairdocs.org/aircraft/N100FB.md): Hoffman Swen · Sedalia, CO · Built 1963 · S/N D-7158
- [N100FP](https://openairdocs.org/aircraft/N100FP.md): Flying Particles Inc · Livermore, CA · Built 1974 · S/N 18262957
- [N100GM](https://openairdocs.org/aircraft/N100GM.md): Huguenard Jefferson J · Alpharetta, GA · Built 1968 · S/N TC-1183
- [N100JH](https://openairdocs.org/aircraft/N100JH.md): Sonic Aviation LLC · Carrollton, MS · Built 1971 · S/N 310Q0421
- [N100KF](https://openairdocs.org/aircraft/N100KF.md): Albrecht Douglas D · Hobart, IN · Built 1966 · S/N 18257496
- [N100MM](https://openairdocs.org/aircraft/N100MM.md): Farmer Aviation LLC · Milan, MI · S/N 33611
- [N100SD](https://openairdocs.org/aircraft/N100SD.md): Divan Jeremy E · Castle Rock, CO · Built 1960 · S/N 52853
- [N100SF](https://openairdocs.org/aircraft/N100SF.md): Safe Flight Instrument LLC · White Plains, NY · Built 1979 · S/N TC-2211
- [N100SL](https://openairdocs.org/aircraft/N100SL.md): Olson Gordon N · Racine, WI · Built 1971 · S/N 18260900
- [N100TB](https://openairdocs.org/aircraft/N100TB.md): Alexander Aviation LLC · Brighton, CO · Built 1963 · S/N CD-637
- [N100TG](https://openairdocs.org/aircraft/N100TG.md): Bengtson Todd · Tyler, TX · Built 1974 · S/N 310Q1150
- [N100ZP](https://openairdocs.org/aircraft/N100ZP.md): Zipjack Inc · Fernandina Beach, FL · Built 1955 · S/N BG-4
- [N100ZZ](https://openairdocs.org/aircraft/N100ZZ.md): Arbuckle George A · Poolville, TX · Built 1975 · S/N TC-1922
- [N1011S](https://openairdocs.org/aircraft/N1011S.md): African American Airlines Inc · Brandon, FL · Built 1964 · S/N 310I0092
- [N10133](https://openairdocs.org/aircraft/N10133.md): Fisher Charles R Jr · San Antonio, TX · Built 1948 · S/N NAV-4-1766
- [N10145](https://openairdocs.org/aircraft/N10145.md): Hensarling Matthew L · Elizabeth, CO · Built 1948 · S/N 48-999
- [N1015Q](https://openairdocs.org/aircraft/N1015Q.md): Mayo William J Jr · Reed Point, MT · Built 1962 · S/N 310H0015
- [N10176](https://openairdocs.org/aircraft/N10176.md): Abm Flights LLC · Pawleys Island, SC · Built 1969 · S/N 18260141
- [N101A](https://openairdocs.org/aircraft/N101A.md): Patterson Mark T · Kodiak, AK · Built 1959 · S/N 50486
- [N101BB](https://openairdocs.org/aircraft/N101BB.md): Polson Taylor M · Killeen, TX · Built 1959 · S/N D-6076
- [N101GH](https://openairdocs.org/aircraft/N101GH.md): San Diego Community College District · San Diego, CA · S/N 18260875
- [N101HT](https://openairdocs.org/aircraft/N101HT.md): Wilder Bart M · Maryville, TN · Built 1958 · S/N D-5722
- [N101KT](https://openairdocs.org/aircraft/N101KT.md): Bryan Jerry E · Kathleen, GA · Built 1978 · S/N 18266264
- [N101PQ](https://openairdocs.org/aircraft/N101PQ.md): Valiair Limited Company Trustee · Casper, WY · Built 1962 · S/N 21057932
- [N101RG](https://openairdocs.org/aircraft/N101RG.md): Tree Air LLC · Vero Beach, FL · Built 1967 · S/N 18258526
- [N101SP](https://openairdocs.org/aircraft/N101SP.md): Hawkes Clark · Gillsville, GA · Built 1986 · S/N 18268562
- [N101TC](https://openairdocs.org/aircraft/N101TC.md): Tcm Flying Club Inc · Mobile, AL · Built 1968 · S/N 18259330
- [N101WP](https://openairdocs.org/aircraft/N101WP.md): Scc Associates Ltd · Wilmington, DE · Built 1975 · S/N 18264220
- [N1020M](https://openairdocs.org/aircraft/N1020M.md): Winner Philip · Houston, TX · Built 1975 · S/N 18264208
- [N1021C](https://openairdocs.org/aircraft/N1021C.md): Riener Clinton G · Cottonwood, ID · Built 1966 · S/N 18257409
- [N1022M](https://openairdocs.org/aircraft/N1022M.md): Hilton David L · Shreveport, LA · Built 1975 · S/N 18264209
- [N1022T](https://openairdocs.org/aircraft/N1022T.md): Hansen Jed D · Clark, SD · S/N D-3144
- [N1024](https://openairdocs.org/aircraft/N1024.md): Calgonaire LLC · Seminole, TX · S/N 57425
- [N1024M](https://openairdocs.org/aircraft/N1024M.md): Edwards Chris R · Meadow Vista, CA · Built 1975 · S/N 18264210
- [N1025M](https://openairdocs.org/aircraft/N1025M.md): Supina Robert P · Richmond, TX · Built 1975 · S/N 18264211

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

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