# Registered aircraft: AD 2008-23-06

A list on [AD 2008-23-06](https://openairdocs.org/ad/2008-23-06.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.

- [N12SK](https://openairdocs.org/aircraft/N12SK.md): Aviation Training Consulting & Se Sailplanes Corp · Wilmington, DE · Built 2007 · S/N 10-119T39
- [N1RN](https://openairdocs.org/aircraft/N1RN.md): Eastern Soaring Center Inc · Petersburg, WV · Built 2002 · S/N 10-10S10
- [N204DG](https://openairdocs.org/aircraft/N204DG.md): US Air Force · U S A F Academy, CO · S/N 10-173S103
- [N205DG](https://openairdocs.org/aircraft/N205DG.md): US Air Force · U S A F Academy, CO · S/N 10-174S104
- [N306DG](https://openairdocs.org/aircraft/N306DG.md): US Air Force · U S A F Academy, CO · Built 2011 · S/N 10-175S105
- [N307DG](https://openairdocs.org/aircraft/N307DG.md): US Air Force · U S A F Academy, CO · S/N 10-176S106
- [N308DG](https://openairdocs.org/aircraft/N308DG.md): United States Air Force · U S A F Academy, CO · S/N 10-177S107
- [N309DG](https://openairdocs.org/aircraft/N309DG.md): US Air Force · U S A F Academy, CO · S/N 10-178S108
- [N310DG](https://openairdocs.org/aircraft/N310DG.md): U S Air Force · U S A F Academy, CO · Built 2012 · S/N 10-179S109
- [N311DG](https://openairdocs.org/aircraft/N311DG.md): US Air Force · U S A F Academy, CO · Built 2012 · S/N 10-180S110
- [N363DG](https://openairdocs.org/aircraft/N363DG.md): Great Basin Soaring LLC · North Salt Lake, UT · Built 2009 · S/N 10-143S93
- [N381K](https://openairdocs.org/aircraft/N381K.md): Dg Soaring LLC · Clermont, FL · Built 2006 · S/N 10-77T16
- [N429FH](https://openairdocs.org/aircraft/N429FH.md): Aviation Dynamics LLC · Hastings, MN · Built 2002 · S/N 10-12S12
- [N451CH](https://openairdocs.org/aircraft/N451CH.md): Bay Area Soaring Associates Inc · San Jose, CA · Built 2003 · S/N 10-23S23
- [N501DG](https://openairdocs.org/aircraft/N501DG.md): US Air Force · U S A F Academy, CO · S/N 10-170S100
- [N502DG](https://openairdocs.org/aircraft/N502DG.md): US Air Force · U S A F Academy, CO · S/N 10-171S101
- [N503DG](https://openairdocs.org/aircraft/N503DG.md): US Air Force · U S A F Academy, CO · S/N 10-172S102
- [N512DG](https://openairdocs.org/aircraft/N512DG.md): US Air Force · U S A F Academy, CO · Built 2012 · S/N 10-181S-111
- [N513DG](https://openairdocs.org/aircraft/N513DG.md): US Air Force · U S A F Academy, CO · Built 2012 · S/N 10-182S112
- [N56KK](https://openairdocs.org/aircraft/N56KK.md): Evergreen Soaring Inc · Lynnwood, WA · S/N 10-11S11
- [N614DG](https://openairdocs.org/aircraft/N614DG.md): U S Air Force · Usaf Academy, CO · Built 2012 · S/N 10-183S113
- [N615DG](https://openairdocs.org/aircraft/N615DG.md): US Air Force · Usaf Academy, CO · Built 2012 · S/N 10-184S114
- [N616DG](https://openairdocs.org/aircraft/N616DG.md): U S Air Force · Usaf Academy, CO · Built 2012 · S/N 10-185S115
- [N624RM](https://openairdocs.org/aircraft/N624RM.md): Davis Gary L · Lascassas, TN · S/N 10-129S82
- [N676CW](https://openairdocs.org/aircraft/N676CW.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 10-53S52
- [N717DG](https://openairdocs.org/aircraft/N717DG.md): U S Air Force · Usaf Academy, CO · Built 2012 · S/N 10-186S116
- [N718DG](https://openairdocs.org/aircraft/N718DG.md): U S Air Force · Usaf Academy, CO · Built 2012 · S/N 10-187S117
- [N719DG](https://openairdocs.org/aircraft/N719DG.md): U S Air Force · Usaf Academy, CO · Built 2012 · S/N 10-188S118
- [N801DG](https://openairdocs.org/aircraft/N801DG.md): Chapman John P · Long Beach, CA · Built 2008 · S/N 10123S80
- [N848DG](https://openairdocs.org/aircraft/N848DG.md): Steklov Properties LLC · Albuquerque, NM · S/N 10-139S91

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

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