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.

N6LPNuss David A · Cortland, OHBuilt 1975 · S/N 436N6MSStafford Linda J DBA · Ann Arbor, MIBuilt 1973 · S/N 337N6UAMileski William J · Ledyard, CTS/N 20149CN6VSFenix Space Inc · San Bernardino, CABuilt 1978 · S/N 20609N6XDButler Julie L · Los Osos, CABuilt 1987 · S/N 202N700SASouthern California Soaring Academy Inc · Valencia, CABuilt 2011 · S/N 21890N70592Russell Larry B · Union City, TNBuilt 1977 · S/N 73N705MSAdrian Soaring Club Inc · Belleville, MIBuilt 1981 · S/N 3609N70796Sale Reported · Lakewood, COSale reportedBuilt 1977 · S/N 78N70BSGranzow Jared Douglas Trustee · Powell, OHBuilt 1985 · S/N 4-146N70FPFinger Lakes Soaring Club Inc · Dansville, NYBuilt 1985 · S/N 101A0202N713NBWebb Randol B Jr · Sherman, CTS/N 20599N7174WReynolds Stuart N II · Church Road, VABuilt 1979 · S/N 104N717ZZToro Christopher · Tampa, FLBuilt 1976 · S/N 20112N71LSLundin Michael A · Ellensburg, WABuilt 1971 · S/N 119N71TTRobert Christian Daniel · Ogden, UTBuilt 1977 · S/N 136N720PKSpencer Scott A · Brownsburg, INBuilt 1977 · S/N 20558N721RCGreater Boston Soaring Club Inc · Sterling, MABuilt 2015 · S/N 21930N721WCWindy City Soaring Association · Hinckley, ILBuilt 1997 · S/N 21650N723PJBerry Wallace · Lafayette, ALS/N 101A0199N7240PHouseknecht Thomas J · State College, PABuilt 1969 · S/N 15022N726MCOkeson Trent J · Spring, TXBuilt 1973 · S/N 289GN727GMMolidor Gerald C Jr · Mchenry, ILS/N 3152N72EJLakeland Aero Club Inc · Lakeland, FLBuilt 1979 · S/N 3253-T-30N72ZZRavanfar Kia N · Redondo Beach, CABuilt 1972 · S/N 221N747SVShenandoah Valley Soaring Inc · Nellysford, VAS/N 21879N74BHKansas Soaring Association · Wichita, KSS/N 3093N74RJEbenhack Thomas C · Tucson, AZBuilt 1979 · S/N 3357N757NLeonard Steven E · Wichita, KSBuilt 1968 · S/N 36N75SWMitchell Jamie D · La Puente, CABuilt 1976 · S/N 1171N767CSX-C Soaring Association Inc · Pensacola, FLBuilt 1985 · S/N 33994-K-227N76WMIglesias Carolina · Waller, TXBuilt 1976 · S/N 20139CN7745Wabash Valley Soaring Assn Inc · Lawrenceville, ILBuilt 1968 · S/N 13084N777BDFranke Adam M · Eagle, IDBuilt 1972 · S/N 266N777FVMid America Flight Museum · Mount Pleasant, TXBuilt 1977 · S/N 102N77CNSandhill Soaring Club Inc · Brighton, MIBuilt 1971 · S/N 105N77HZWisniewski Wit Tadeusz · Tucson, AZBuilt 1976 · S/N 20121CN77LKOlsen Randle B · Riverton, UTBuilt 1979 · S/N 3355N77VLGehrlein Products · Waterford, PABuilt 1976 · S/N 449N77WPParzyk Roy E · Lake Stevens, WABuilt 1975 · S/N 20056N77XTCarpenter Bruce E · Monroe, NYBuilt 1976 · S/N 20100CN7820DSafronoff Drew · Seattle, WAS/N 20602N785GClosson Luke E Jr · Valdosta, GABuilt 1985 · S/N 33985-K-218N786GCypress Soaring Inc · Hemet, CABuilt 1985 · S/N 33986-K-219N787SFSoar Hawaii Foundation · Waialua, HIS/N 34118N7898Everson John · Providence, RIBuilt 1970 · S/N 45N78CMKilo 7 LLC · Colorado Springs, COBuilt 1976 · S/N 19070N78MAForsyth Bryan O · Truckee, CABuilt 1978 · S/N 20595N791SCSoaring Club Of Houston Inc · Waller, TXBuilt 1982 · S/N 21126N792SCSoaring Club Of Houston Inc · Waller, TXS/N 21 044
Back to AD 97-08-06 R1