# Registered aircraft: AD 97-08-02 R1

A list on [AD 97-08-02 R1](https://openairdocs.org/ad/97-08-02-R1.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.

- [N105GD](https://openairdocs.org/aircraft/N105GD.md): Hudson Mitchell C · Erie, CO · S/N 10
- [N107JW](https://openairdocs.org/aircraft/N107JW.md): Player Jennifer L · Stevenson, WA · S/N 428
- [N117TB](https://openairdocs.org/aircraft/N117TB.md): Saunders Christopher D · Lehighton, PA · S/N 17
- [N130JB](https://openairdocs.org/aircraft/N130JB.md): Benson Arthur V · Brunswick, GA · Built 1986 · S/N 74
- [N13SG](https://openairdocs.org/aircraft/N13SG.md): Bay Area Soaring Associates Inc · San Jose, CA · Built 1985 · S/N 69
- [N144T](https://openairdocs.org/aircraft/N144T.md): Cypress Soaring Inc · Hemet, CA · Built 1989 · S/N 266
- [N14MG](https://openairdocs.org/aircraft/N14MG.md): Buker Terrance · Burnsville, NC · S/N 62
- [N14SZ](https://openairdocs.org/aircraft/N14SZ.md): Woenker Timothy E · Columbia City, IN · S/N 96
- [N14ZZ](https://openairdocs.org/aircraft/N14ZZ.md): Klunk Lewis J · Cambridge, MA · Built 1987 · S/N 176
- [N16DE](https://openairdocs.org/aircraft/N16DE.md): Washington Robert D · Eureka, MO · Built 1984 · S/N 6
- [N16JJ](https://openairdocs.org/aircraft/N16JJ.md): Eggert Darrell R · San Luis Obispo, CA · Built 1986 · S/N 97
- [N18MG](https://openairdocs.org/aircraft/N18MG.md): Thomas Nicholas J · Incline Village, NV · Built 1985 · S/N 4
- [N19BE](https://openairdocs.org/aircraft/N19BE.md): Van De Velde Thomas E · Brookline, MA · S/N 27
- [N224B](https://openairdocs.org/aircraft/N224B.md): Duncan Terry Trustee · Cupertino, CA · Built 1987 · S/N 205
- [N224DW](https://openairdocs.org/aircraft/N224DW.md): Reid Michael · Denver, CO · S/N 62
- [N244CX](https://openairdocs.org/aircraft/N244CX.md): Ito Rysuke · Everett, WA · S/N 83
- [N26HL](https://openairdocs.org/aircraft/N26HL.md): Engel Carl J · Campbell, CA · S/N 31
- [N27SG](https://openairdocs.org/aircraft/N27SG.md): Mcmaster Justin Thomas Jr · Horseheads, NY · Built 1992 · S/N 419
- [N301YC](https://openairdocs.org/aircraft/N301YC.md): Henson Van E · Livermore, CA · Built 1978 · S/N 88
- [N32086](https://openairdocs.org/aircraft/N32086.md): Hinniger Werner M · Hamburg · Built 1985 · S/N 65
- [N33DX](https://openairdocs.org/aircraft/N33DX.md): Bostik Josef J · Green Cove Springs, FL · Built 1985 · S/N 33
- [N380S](https://openairdocs.org/aircraft/N380S.md): Mazure Morris Jay · Gardnerville, NV · Built 1978 · S/N 67
- [N3DD](https://openairdocs.org/aircraft/N3DD.md): Tirca Laviniu H · Philadelphia, PA · Built 1986 · S/N 145
- [N400HB](https://openairdocs.org/aircraft/N400HB.md): Kautter William J · Columbia, MD · Built 1995 · S/N 550
- [N43SG](https://openairdocs.org/aircraft/N43SG.md): Noordergraaf Alexander A · Concord, NH · Built 1986 · S/N 82
- [N44BX](https://openairdocs.org/aircraft/N44BX.md): Boedecker Paul L · Excelsior, MN · Built 1986 · S/N 58
- [N4989C](https://openairdocs.org/aircraft/N4989C.md): Bernatz Gerald F · Saint Louis, MO · Built 1978 · S/N 79
- [N505KA](https://openairdocs.org/aircraft/N505KA.md): Fairbairn Jacob Andrew · Fort Worth, TX · S/N 50
- [N526BC](https://openairdocs.org/aircraft/N526BC.md): Portman Lance N · Morgan Hill, CA · Built 1988 · S/N 244
- [N54HW](https://openairdocs.org/aircraft/N54HW.md): US Junior Soaring Association · Brighton, MI · Built 1986 · S/N 113
- [N560R](https://openairdocs.org/aircraft/N560R.md): Prokes William J · Tempe, AZ · Built 1987 · S/N 147
- [N578JV](https://openairdocs.org/aircraft/N578JV.md): Maag Andrew J · Austin, TX · Built 1988 · S/N 233
- [N57PP](https://openairdocs.org/aircraft/N57PP.md): Stewart Michael · Park City, UT · S/N 313
- [N65JJ](https://openairdocs.org/aircraft/N65JJ.md): Jackson James A · Houston, TX · Built 1993 · S/N 472
- [N67WS](https://openairdocs.org/aircraft/N67WS.md): Hopke Kurt Ervin · Escondido, CA · S/N 8
- [N6XD](https://openairdocs.org/aircraft/N6XD.md): Butler Julie L · Los Osos, CA · Built 1987 · S/N 202
- [N717MJ](https://openairdocs.org/aircraft/N717MJ.md): Philadelphia Glider Counsil Inc · Hilltown, PA · S/N 211
- [N71TT](https://openairdocs.org/aircraft/N71TT.md): Robert Christian Daniel · Ogden, UT · Built 1977 · S/N 136
- [N77AU](https://openairdocs.org/aircraft/N77AU.md): Coder Don Erdman · Arlington, TX · S/N 77
- [N7958C](https://openairdocs.org/aircraft/N7958C.md): Leonard Ronald A · Peculiar, MO · S/N 251
- [N84DF](https://openairdocs.org/aircraft/N84DF.md): Mollified LLC · Beaver, PA · Built 1986 · S/N 128
- [N87BD](https://openairdocs.org/aircraft/N87BD.md): Harrison Lee · Rensselaer, NY · S/N 78
- [N888TK](https://openairdocs.org/aircraft/N888TK.md): Cloclasure David L · Bringhurst, IN · Built 1986 · S/N 134
- [N941KS](https://openairdocs.org/aircraft/N941KS.md): Crippen Terrence M · Maple Valley, WA · Built 1985 · S/N 13
- [N97DG](https://openairdocs.org/aircraft/N97DG.md): Loeffler Herbert M Jr · Saratoga Springs, NY · Built 1986 · S/N 108

## 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-08-02-R1')
  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-08-02-R1')
ORDER BY n_number
```

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