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.

N50NCBlue Ridge Soaring Society · New Castle, VAS/N 21901N5104CMori Glenn E · West Ossipee, NHS/N 70N511XMackenzie Franklin F Trustee · Cary, NCBuilt 1970 · S/N 36N521CCSoaring Society Of Dayton · Waynesville, OHBuilt 2005 · S/N 21802N521CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 21694N521HHHarris Hill Soaring Corp · Horseheads, NYBuilt 1999 · S/N 21704N521PRGuttzeit Albert J · Ethel, LAS/N 120N521SLNfm Enterprises LLC · Wurtsboro, NYBuilt 2006 · S/N 21809N52EDDrori Eldad Trustee · Loveland, COS/N 121N52FPurves Keith C · Renton, WABuilt 1973 · S/N 17020N53608Seminole Flying & Soaring Inc · Clermont, FLBuilt 1984 · S/N 3861-K-107N5361VPhiladelphia Glider Council · Hilltown, PABuilt 1984 · S/N 3863N5364GWhite Sands Soaring Foundation Inc · Alamogordo, NMBuilt 1984 · S/N 3865N53JCBlack Forest Soaring Association · Monument, COBuilt 1985 · S/N 19415N53LSFoster Jonathan · South Jordan, UTBuilt 1979 · S/N 3332N5448WTucson Soaring Club Inc · Sahuarita, AZS/N 3869-K-110N5448XCentral Ohio Soaring Assoc Inc · Marion, OHS/N 3870-K-111N54553Ackley Richard F · Clearville, PAS/N 3872-K-113N545TTDyer Evan H · Ann Arbor, MIBuilt 1968 · S/N 13083N54619Butler Kenneth L · Mc Leansville, NCBuilt 1977 · S/N 19159N5462NCsa Foundation Inc · Wellington, COS/N 3875N547CMArnold Sarah D · Benton, TNBuilt 2002 · S/N 125N55KGAustria Alfred N · San Jose, CAS/N 101A0200N55YRArmstrong Gregory A · Bonita, CABuilt 1970 · S/N 79N563SHTaylor Katrina A · Alamogordo, NMS/N 34021-K-253N5668Beltz Thomas G Jr · Lehighton, PABuilt 1972 · S/N 207N56DTBraner Alan R · Punta Gorda, FLS/N 101A0201N56LSSouthern Eagles Soaring Inc · Butler, GABuilt 1973 · S/N 399N574KSFinger Lakes Soaring Club Inc · Dansville, NYBuilt 1984 · S/N 21210N575SRRathbun Steven G · Cottonwood Heights, UTBuilt 1978 · S/N 3325N577SFMuseum Of Flight Foundation · Seattle, WABuilt 1995 · S/N 5E143M57N578JVMaag Andrew J · Austin, TXBuilt 1988 · S/N 233N579JCDaisey Joshua · Rochester, NHS/N 4-169N57LKSky Sailing Inc · Warner Springs, CABuilt 2002 · S/N 137N57RHWood David A · San Diego, CAS/N 101A0218N57TBluestein Ryan · Garland, TXBuilt 1975 · S/N 406N57YAllemann Rudolph T · Richland, WAS/N 4-142N581AGMiner Daniel E · Columbus, OHS/N 51N585Gehrlein Jay L · Waterford, PABuilt 1976 · S/N 477N58HRNorris James M · Santa Barbara, CABuilt 1998 · S/N 71N58KGMcguire James Jared · Athens, PAS/N 101A0203N594KSHenderson John M · Moses Lake, WAS/N 21218N599JHMirzayan Varoojan Y · Fresno, CAS/N 101 084N59RCWood Roger D · Reno, NVS/N 4-148N5BVSilverman Arthur E · Northbrook, ILBuilt 1977 · S/N 20581N5QDPhiladelphia Glider Council Inc · Hilltown, PABuilt 1983 · S/N 3792N603MLVan De Water Hendrik · Mount Pleasant, MIBuilt 1983 · S/N 5611CN6108JN6108j LLC · Arlington, VAS/N 272N612MGMid-Georgia Soaring Association Inc · Monroe, GABuilt 1992 · S/N 21544N615PLipscomb James W · Salt Lake City, UTBuilt 1971 · S/N 15133
Back to AD 97-08-06 R1