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.

N101CXMoses Charles A III · West Friendship, MDBuilt 1983 · S/N 101 089N101LVRosenthal Bruce D · Wickenburg, AZS/N 10100264N102GBCibotti Ricardo Roque · Bethesda, MDS/N 1424N102TLCentral Ms Soaring Society LLC · Brandon, MSS/N 1234N103BPWiederkehr Anthony C · Stanwood, WABuilt 1992 · S/N 34172N103FBNorthern California Soaring Association · Byron, CABuilt 1984 · S/N 33930N103GHTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1989 · S/N 34110N103LMJohnson Matthew W · Langley, WABuilt 1989 · S/N 34107N103MGWhite Sands Soaring Association Inc · Alamogordo, NMBuilt 1985 · S/N 33983-K-216N103NSNutmeg Soaring Assoc · Freehold, NYBuilt 1978 · S/N 3096N103PRSeva Corp · Malibu, CABuilt 1984 · S/N 3852-K-98N103RFTucson Soaring Club Inc · Sahuarita, AZBuilt 1985 · S/N 33921K156N103SHSouthern California Soaring Academy Inc · Valencia, CABuilt 1986 · S/N 34051-K-281N103TGRunaway 5 LLC · Wurtsboro, NYBuilt 1983 · S/N 3829N103XSPrairie Thermals LLC · Brookings, SDBuilt 1982 · S/N 3745N1052WSprandel James L · Kendallville, INBuilt 1978 · S/N 105N1052YNorth Shore Aircraft Leasing Co LLC · Waialua, HIBuilt 1979 · S/N 213N106TCollins Michael R · Parker, AZBuilt 1979 · S/N 19288N107JWPlayer Jennifer L · Stevenson, WAS/N 428N107SEEvo 84 LLC · Bend, ORBuilt 1977 · S/N 3021N108AClayton Harry L · Wichita, KSBuilt 1971 · S/N 140N10GKLong Taylor · Hamilton, TXBuilt 1976 · S/N 19021N10LACondon Anthony B · Wichita, KSBuilt 1972 · S/N 280N10TYMountain Peter W · Williams, AZBuilt 1971 · S/N 15127N10WHOdonnell Michael F · Newtown, PABuilt 1980 · S/N 19322N110BLBlue Ridge Soaring Society · New Castle, VABuilt 1985 · S/N 21268N1113AThermal Inc · Rhinebeck, NYBuilt 1980 · S/N 3546N1117Lipe James E · Rossville, TNBuilt 1969 · S/N 14N111BGGrant Richard M · Eugene, ORBuilt 1972 · S/N 17008N111RPDoxey Bryan Doughlas · Irondale, ALBuilt 1979 · S/N 3377N111VHCascade Soaring Society Inc · East Wenatchee, WABuilt 1978 · S/N 3326N113SABarry Russell L · Fort Mohave, AZS/N 4-113N114MSLynch James D · Scottsdale, AZBuilt 1976 · S/N 20131CN116DMArea Code Adventures LLC · Virginia Beach, VAS/N 101A0343N117RTDoyle Connor G · North Adams, MABuilt 1972 · S/N 17009N117SZCarolina Soaring Association · Spartanburg, SCS/N 34074-K-304N117TBSaunders Christopher D · Lehighton, PAS/N 17N1194Leonard Steven E · Wichita, KSS/N 4N119JGGrecco Joseph J · Saddle Brook, NJBuilt 1977 · S/N 19137N119LTCilley Sherburn C · South Royalton, VTBuilt 1980 · S/N 19312N11CNSoar Wisc Inc · Little Canada, MNBuilt 1976 · S/N 20099N11EKEastern Soaring Center Inc · Petersburg, WVBuilt 1972 · S/N 13401N11KBLeonard Steven E · Wichita, KSS/N 6-79 M26N11NCPierce John C · Cedar City, UTBuilt 1968 · S/N 64N11QSNevada Soaring Association Inc · Reno, NVBuilt 1978 · S/N 19210N11SWMetkowski Leonard P · York, PABuilt 1972 · S/N 243GN11TACurry Robert B · Delphos, OHBuilt 1978 · S/N 3193N11UUnicorn Soaring Associates · Maple Valley, WABuilt 1976 · S/N 1369N11VEKlein Flying Service Inc · Lawrenceville, ILBuilt 1976 · S/N 20150CN1202ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1982 · S/N 3615
Back to AD 97-08-06 R1