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.

N202GGHollister Soaring Center LLC · Hollister, CABuilt 2008 · S/N 21832N2078DBloomfield John R · New York, NYBuilt 1977 · S/N 20593N20EDConrad Craig M · Hickory, NCBuilt 1977 · S/N 1503N20EKCoucke David A · Nashville, INBuilt 1976 · S/N 20122CN20GAMitchell Charles L · Tullahoma, TNS/N 486N20HSCoffield Alan B · Canyon Lake, CABuilt 1984 · S/N 3860-K-106N20MMLedbetter Jason H · Ypsilanti, MIBuilt 1975 · S/N 20016N20PKJohnson Steven M · Waukesha, WIBuilt 1975 · S/N 20031N20SJReuter Gary G · Littleton, COBuilt 1975 · S/N 20064N2102ZGudgel Daniel R · Minden, NVS/N 34121N212JRRegistered aircraftBuilt 1975 · S/N 1011N214BSBrandywine Soaring Association · Hockessin, DEBuilt 2018 · S/N 21950N215ESEagle Sport Aviation Club · De Leon Springs, FLS/N 21829N217BGFreedom Wings International · Glenside, PAS/N 33984-K-217N218CMJarvis Peter E · Austin, TXBuilt 1977 · S/N 20601N21AFAdrian Soaring Club · Ypsilanti, MIBuilt 1983 · S/N 21179N21BRPiedmont Soaring Society · Clemmons, NCBuilt 1978 · S/N 3121N21HNCalvert Scott R · Pequannock, NJS/N 21266N21QUUtah Soaring Association · Mapleton, UTS/N 21272N21RLMcgee Terence A · Laguna Niguel, CABuilt 1976 · S/N 20117CN21TWOuroboros Soaring LLC · Salt Lake City, UTS/N 19158N221CCSoaring Society Of Dayton Inc · Waynesville, OHBuilt 2001 · S/N 21733N221CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1998 · S/N 21669N221CWCentral Indiana Soaring Society · Yorktown, INBuilt 2015 · S/N 21931N221JHHood River Soaring Inc · Hood River, ORS/N 21794N221SBLow Country Soaring Association · Ridgeland, SCBuilt 1999 · S/N 21699N222PKRussell Matthew D · Chattaroy, WABuilt 1975 · S/N 20027N2237WEagleville Soaring Inc · Eagleville, TNBuilt 1982 · S/N 21131N223WPRamirez Fidel M · Moriarty, NMS/N 3846-K-92N224DWReid Michael · Denver, COS/N 62N227CDMagpie Aviation Inc · Hayward, CABuilt 1978 · S/N 20592N228BGUtah Soaring Association Inc · Mapleton, UTBuilt 1985 · S/N 33995-K-228N22FFWillat Garret I · Warner Springs, CABuilt 1973 · S/N 330N22UUChow Timothy · Norwich, VTBuilt 1977 · S/N 20511N22ZBCollegiate Soaring Association Inc · Greeley, COBuilt 1976 · S/N 1309N2303ADuke Kay · Darrouzett, TXBuilt 1978 · S/N 122N230XFWalker Neiman J · Denton, TXBuilt 1972 · S/N 209N237JFTzerefos Lambros P · Mathews, VAS/N 19156N2429Bittner Charles K · Maize, KSBuilt 1971 · S/N 118N246HFFranke Sean R · Eagle, IDBuilt 1978 · S/N 3305N248SDyer Evan H · Ann Arbor, MIS/N 13003N253DJLuitjens Jacob Jelte · Lagrange, GABuilt 1970 · S/N 15026N25DTBernhardt George A · Pleasant View, TNS/N 113N26DMMori Glenn E · West Ossipee, NHBuilt 1975 · S/N 437N26LSGadomski David M · Albuquerque, NMBuilt 1980 · S/N 3447N26TEStandish Jason L · Brook, INBuilt 1971 · S/N 101N271BLVinarub Marc R · Webster, FLBuilt 1972 · S/N 271N27826Bowen Stephen T · Englewood, TNBuilt 1970 · S/N 84N279PN279p LLC · Homestead, FLBuilt 1971 · S/N 144N27SGMcmaster Justin Thomas Jr · Horseheads, NYBuilt 1992 · S/N 419
Back to AD 97-08-06 R1