# Registered aircraft: AD 2005-08-07

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

- [N10874](https://openairdocs.org/aircraft/N10874.md): Lake Elsinore Soaring Club · Wildomar, CA · Built 1972 · S/N 016
- [N208AS](https://openairdocs.org/aircraft/N208AS.md): Hardy Sandra N · Monson, ME · Built 1977 · S/N 272
- [N21TU](https://openairdocs.org/aircraft/N21TU.md): Aero Club Albatross · Blairstown, NJ · Built 1974 · S/N 133
- [N278AS](https://openairdocs.org/aircraft/N278AS.md): Bock Bryce K · Longwood, FL · S/N 251
- [N280DT](https://openairdocs.org/aircraft/N280DT.md): Registration Pending · Waimanalo, HI · Registration pending · Built 1977 · S/N 280
- [N303TM](https://openairdocs.org/aircraft/N303TM.md): North Florida Soaring Society Inc · Jacksonville, FL · Built 1977 · S/N 273
- [N38JE](https://openairdocs.org/aircraft/N38JE.md): Pham Loc G · Westminster, CA · S/N 176
- [N413PJ](https://openairdocs.org/aircraft/N413PJ.md): Linda K Howe · Parma, OH · Built 1974 · S/N 148
- [N484B](https://openairdocs.org/aircraft/N484B.md): Odonnell Daniel V · Dover, DE · Built 1974 · S/N 208
- [N4BB](https://openairdocs.org/aircraft/N4BB.md): Bock Bryce K · Longwood, FL · S/N 020
- [N581DB](https://openairdocs.org/aircraft/N581DB.md): Baldassarri Giuseppe · Carrollton, GA · Built 1977 · S/N 262
- [N62516](https://openairdocs.org/aircraft/N62516.md): N304mg LLC · Homestead, FL · Built 1973 · S/N 063
- [N64775](https://openairdocs.org/aircraft/N64775.md): Adams Bob L · Eagle River, AK · Built 1977 · S/N 254
- [N65317](https://openairdocs.org/aircraft/N65317.md): Mahony John · Ballston Spa, NY · Built 1976 · S/N 190
- [N65332](https://openairdocs.org/aircraft/N65332.md): Utah Soaring Association Inc · Mapleton, UT · Built 1974 · S/N 164
- [N65394](https://openairdocs.org/aircraft/N65394.md): All Attitude Aviation Inc · Edgewater, FL · Built 1976 · S/N 216
- [N69AZ](https://openairdocs.org/aircraft/N69AZ.md): Welch Troy O · Graford, TX · Built 1974 · S/N 205
- [N75AS](https://openairdocs.org/aircraft/N75AS.md): Coffield Alan · Canyon Lake, CA · Built 1977 · S/N 274
- [N76PS](https://openairdocs.org/aircraft/N76PS.md): Franconia Soaring Association Inc · Franconia, NH · Built 1974 · S/N 146
- [N774PS](https://openairdocs.org/aircraft/N774PS.md): Dewitt Joseph W III · Yorktown, VA · Built 1976 · S/N 203
- [N7CK](https://openairdocs.org/aircraft/N7CK.md): Conner Walter Larry · Los Lunas, NM · Built 1976 · S/N 187
- [N81YV](https://openairdocs.org/aircraft/N81YV.md): Mahony John · Ballston Spa, NY · S/N 156
- [N855GH](https://openairdocs.org/aircraft/N855GH.md): Thiemar Martin · Mineral Ridge, OH · Built 1974 · S/N 139
- [N89AS](https://openairdocs.org/aircraft/N89AS.md): Swanson Thomas G · Seaford, VA · Built 1976 · S/N 248
- [N8DK](https://openairdocs.org/aircraft/N8DK.md): Flying L Aircraft Inc · Fort Denaud, FL · Built 1976 · S/N 236
- [N9136Y](https://openairdocs.org/aircraft/N9136Y.md): Hoyt Robert M · Rogers, AR · S/N 060
- [N9222Z](https://openairdocs.org/aircraft/N9222Z.md): Mitchell John J · Chevy Chase, MD · Built 1974 · S/N 163
- [N93458](https://openairdocs.org/aircraft/N93458.md): Smith Stephen A · Erwinna, PA · Built 1973 · S/N 061
- [N99990](https://openairdocs.org/aircraft/N99990.md): Pickens Edward C · Raleigh, NC · Built 1974 · S/N 158

## 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:2005-08-07')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-08-07')
ORDER BY n_number
```

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