OpenAirDocs.org
AD 97-08-06 R1

Registered aircraft · 607

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.

Query with SQL
duckdb -csv -c "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-06-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-06-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N61KLWuerth Sebastian M · Columbia, NJBuilt 1980 · S/N 3451N621CGChicago Glider Club · Minooka, ILBuilt 2009 · S/N 21861N621CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 21708N621HHHarris Hill Soaring Corp · Horseheads, NYBuilt 2008 · S/N 21846N621MGMid-Georgia Soaring Association · Monroe, GABuilt 1985 · S/N 21254N623Noodergraaf Alexander A · Concord, NHBuilt 1970 · S/N 15073N62390Bedell Christopher L · Santa Fe, NMBuilt 1974 · S/N 20011N62434Romano James J · San Antonio, TXBuilt 1976 · S/N 11N624BGMadson James W · Las Vegas, NVBuilt 1979 · S/N 3354N626CAMellor Dennis L · Sacramento, CAS/N 101-087N628CAMocho Mark S · Moriarty, NMBuilt 1984 · S/N 101A0154N629CAHayes Steven R · Frankfort, KYBuilt 1983 · S/N 101A0088N62BGOklahoma Soaring Association · Mustang, OKBuilt 1981 · S/N 3649N633CAPrice Brian H · Westminster, COS/N 101 083N634CACowan Rena E · Pleasant Hill, ORS/N 101A0118N635CAWaldo Charles N · West Ossipee, NHS/N 101A0119N636CAMurray James E · Naperville, ILBuilt 1984 · S/N 101A0120N63761Nixon Henry M · Wayne, NJS/N 3286N637CATsidjs LLC · Lehighton, PAS/N 101A0121N638CARamus Sebastien A · Olathe, KSS/N 101A0122N639CABarton Ronald · Camp Verde, AZS/N 101A0124N640CAPearson Marilyn G · West Hartford, CTS/N 101AP186N643CAFadden Michael D · Margate City, NJS/N 101A0188N644CALeonard Steven E · Wichita, KSS/N 101 090N645CAZanon John T · Uhrichsville, OHBuilt 1984 · S/N 101A0156N6483Mrozinski Eric · Westford, MABuilt 1971 · S/N 124N6484Gray Thomas M · Magnetic Springs, OHBuilt 1971 · S/N 125N6485Atkinson Gary R · Pine Grove, PABuilt 1971 · S/N 127N6486Rippy Robert · Wichita, KSBuilt 1971 · S/N 129N64HRChew Lindsey J · Lafayette, NJBuilt 1978 · S/N 19189N64UHFerrell Harold C · Franklin, TNBuilt 1978 · S/N 3314N650SASouthern California Soaring Academy Inc · Valencia, CABuilt 2011 · S/N 21888N651ASStyker Andrew J · Xenia, OHBuilt 1979 · S/N 19289N654DBMcintire Louis V Jr · Pecos, TXBuilt 1999 · S/N 94N6660Malis Michael B · Stevenson Ranch, CABuilt 1969 · S/N 80N6662Perkins Chris D · Veradale, WABuilt 1969 · S/N 81N6663King Peter C · Signal Mountain, TNBuilt 1969 · S/N 83N6699NNelson Daniel J · Ladd, ILBuilt 1977 · S/N 62N66CHRedweik Eric P · Tucson, AZBuilt 1978 · S/N 3287N672HFun Country Soaring · Wellington, OHBuilt 1983 · S/N 3777N674KSWheeler Steven E · Northfield, MNBuilt 1984 · S/N 21211N67PJTuscon Soaring Club Inc · Sahuarita, AZBuilt 2000 · S/N 21707N67TTL/D Max Sales LLC · Missoula, MTBuilt 1998 · S/N 74N67WSHopke Kurt Ervin · Escondido, CAS/N 8N6800Naoshy David · Laurel, MDBuilt 1977 · S/N 20546N686CEWebb Randol B Jr · Sherman, CTBuilt 1978 · S/N 20644N6928Rehm Paul S · Hamilton, VAS/N 3324N694KSSouthern California Soaring Academy Inc · Valencia, CABuilt 1984 · S/N 21219N69BGKing Steven · San Jacinto, CABuilt 1981 · S/N 5560SN6HLRegistration Pending · Pace, FLRegistration pendingBuilt 1975 · S/N 20057
Back to AD 97-08-06 R1