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.

N2863Tuohino Lawrence A · Atascadero, CABuilt 1977 · S/N 20588N2866Arnold David A · Jeffersonville, INBuilt 1970 · S/N 60N2886AEvergreen Soaring · Lynnwood, WABuilt 1978 · S/N 3098N28BZGallatin Glider Club Inc · Gallatin Gateway, MTBuilt 1991 · S/N 350N28CLSprague Jeffrey D · Lake Elsinore, CAS/N 27N28DGConner Walter L · Los Lunas, NMBuilt 1978 · S/N 112N28LKWiesmeier Edward III · Poway, CABuilt 1977 · S/N 90N28TRHouseknecht Thomas J · State College, PAS/N 19419N291WHaynes Michael J · Lenexa, KSS/N 15021N292WMWashburn Gordon L · Lakeland, FLBuilt 1970 · S/N 15076N294GHAslaksen Jay P · Richmond, TXS/N 208N299GFevrier Ian · San Diego, CABuilt 1978 · S/N 3328N29JHTampa Bay Soaring Soceity Inc · Zephyrhills, FLBuilt 1975 · S/N 20061N2KVSides Matt E · Lonoke, ARBuilt 1975 · S/N 20036N2LEHaggett William Thomas · Durham, NCBuilt 1976 · S/N 1312N2XWAlexander Kenton C · Wichita, KSBuilt 1977 · S/N 20566N305BGStreamline Aviation LLC · Battlefield, MOS/N 5642CBN305WDorion David R · Asotin, WABuilt 1985 · S/N 4-134N3070CJohnson Steven D · Oklahoma City, OKS/N 206N307BGRunway 5 LLC · Wurtsboro, NYS/N 34032-K-264N30BRBlue Ridge Soaring Society Inc · New Castle, VABuilt 2005 · S/N 21804N30MGBrown Elijah E · Chino Valley, AZBuilt 1975 · S/N 20072N30VVUlma Eric · Long Beach, CABuilt 1978 · S/N 20628N3110Stoia James W · Wagener, SCBuilt 1967 · S/N 13037N314KSBlack Forest Soaring Society · Monument, COS/N 21279N315KSSilvercreek Glider Club · New Douglas, ILBuilt 1986 · S/N 21281N318DVVillinski Paul S · Long Island City, NYS/N 4-150N319HHCampbell Gary A · Boulder, COS/N 19408N31GFTarnoczy Robert I · Corning, NYBuilt 1983 · S/N 19386N31SKBryan Danny J · Hobbs, NMBuilt 1975 · S/N 275N3211WTidewater Soaring Society · Windsor, VABuilt 2018 · S/N 21951N321KSkyline Soaring Club Inc · Front Royal, VAS/N 21875N3247Bartels Lance R · Freetown, INBuilt 1970 · S/N 17N328JWilkes Brett A · Newnan, GABuilt 1976 · S/N 480N331RWahl John F · Edgewood, NMBuilt 1977 · S/N 20153CN333UMason Steven K · Rolla, MOBuilt 1974 · S/N 528N333USHutnick Michael C Jr · Bloomsburg, PABuilt 1977 · S/N 19160N338KPThompson Richard I · Evans City, PAS/N 20092N339PRegistration Pending · Saint Augustine, FLRegistration pendingBuilt 1979 · S/N 3399N33DXBostik Josef J · Green Cove Springs, FLBuilt 1985 · S/N 33N33RDVarvarosky Chris G · Columbus, OHS/N 15129N33UUGallego Javier · Diamond Bar, CABuilt 1980 · S/N 3444N341KSSkyline Soaring Club Inc · Front Royal, VABuilt 2002 · S/N 21752N3441Field Drew H · Dallas, TXBuilt 1968 · S/N 24N3450GSalmons James B · Oklahoma City, OKS/N 345GN3488Russell Tipton J · Muncie, INBuilt 1970 · S/N 32N348RCRegistration Pending · Hartville, OHRegistration pendingBuilt 1981 · S/N 310N34HRRossi Michael A · Pittsboro, NCBuilt 1981 · S/N 19349N351WKelly Kevin P · Milford, OHS/N 3281N354DCThompson Gary J · Saugus, CAS/N 20541
Back to AD 97-08-06 R1