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.

N792TWUtah Soaring Association Inc · Mapleton, UTBuilt 1978 · S/N 3184N793GMid-Georgia Soaring Association Inc · Monroe, GAS/N 5636CBN793MZLakeland Aeroclub Inc · Lakeland, FLS/N 3877-K-115N794GSandhill Soaring Club Inc · Brighton, MIS/N 34007-K-240N794KSAlbatross Aviation Hawaii LLC · Waialua, HIBuilt 1984 · S/N 21220N795GArizona Soaring Inc · Maricopa, AZS/N 34006-K-239N8013KJonas James P · Anaconda, MTBuilt 1982 · S/N 3702N804KLHollister Soaring Center LLC · Hollister, CABuilt 1984 · S/N 21235N8082Worthen David · Las Vegas, NVBuilt 1971 · S/N 152N8085Oklahoma Soaring Association · Mustang, OKBuilt 1971 · S/N 161N8086Hunter Greg L · Enosburgh, VTBuilt 1971 · S/N 165N808XAntelope Valley Soaring Club · Llano, CAS/N 3815-K-76N8096Raetech Motorsports Inc · Ann Arbor, MIBuilt 1971 · S/N 166N80SFDi Stefano Fabrizio D · Goose Creek, SCBuilt 1978 · S/N 19194N80SKSmithson William J · Houston, TXBuilt 1979 · S/N 3376N811FRIngram Scott Christian · Spring, TXBuilt 1973 · S/N 302N8145Ceriotti Leonard L · Waukesha, WIBuilt 1969 · S/N 70N8169Timothy R Lutzko · Ocean View, DEBuilt 1969 · S/N 67N8178Carmel Paul A · Santa Clara, CABuilt 1970 · S/N 15039N8209BAdams Bob L · Eagle River, AKBuilt 1990 · S/N 4-264N8217WMerlin Soaring Association Inc · Amelia Court House, VABuilt 1992 · S/N 357N827Schirmer Dwight S · Milford, MABuilt 1973 · S/N 15282N83DGZoellner Thomas K · Salida, COBuilt 1983 · S/N 4-51N83MNMinnesota Soaring Club · Stanton, MNBuilt 1983 · S/N 21174N842CCHolmberg William · Dallas, TXBuilt 1976 · S/N 19069N843Black Industries LLC · Helena, MTS/N 44N8465Grieve Shane M · Fort Worth, TXS/N 15075N8485Mizer James D · Hailey, IDBuilt 1971 · S/N 93N8485WUtah Soaring Association · Mapleton, UTBuilt 1980 · S/N 3290N851BGShipman Benny A · Las Vegas, NVS/N 5639 CBN852BGField Drew · Dallas, TXBuilt 1985 · S/N 34014-K-247N853BGSouthern California Soaring Academy Inc · Valencia, CAS/N 5640 CBN8559Navarette Brian K · Toledo, OHS/N 70N856BGTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 34020-K-252N858Davenport John P · Redmond, WAS/N 15231N8595Bitikofer Dawid K · Kansas City, KSBuilt 1970 · S/N 33N867DHenderson Colin D · Norman, OKBuilt 1972 · S/N 13369N876FTucson Soaring Club Inc · Sahuarita, AZBuilt 1976 · S/N 19068N888ANRockfish Cirrus LLC · Faber, VABuilt 1968 · S/N 18N888MKLynch William Reymond · Dearborn, MIBuilt 1983 · S/N 19397N88DMGarcia Roberto P · Spring Hill, FLS/N 5E97M43N88SCNightingale Brian J · Clewiston, FLBuilt 1972 · S/N 186N88SGVogt Frederic B · Cedar Grove, WIS/N 261N8915Williams John Scott · Norman, OKBuilt 1975 · S/N 538N898ASNatke Gregory I · Manlius, NYBuilt 1980 · S/N 3606N899MAMid Atlantic Soaring Association · Frederick, MDBuilt 2017 · S/N 21945N899SAMid Atlantic Soaring Association (M-Asa) · Frederick, MDBuilt 2017 · S/N 21946N90180Silent Soarers Inc · Washington, DCBuilt 1976 · S/N 4N901BGTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1981 · S/N 3648N9023ENorth Carolina Soaring Association · Zebulon, NCBuilt 1978 · S/N 148
Back to AD 97-08-06 R1