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.

N14YCSlack Jonathan D · Bonfield, ILBuilt 1982 · S/N 4-3N1515BChilhowee Soaring Association Inc · Benton, TNBuilt 1976 · S/N 15450N151SSSt Louis Soaring Association Inc · Saint Louis, MOBuilt 1977 · S/N 1501N1524TYoung Dennis N · Glen Mills, PABuilt 1970 · S/N 41N152SSSwayze Henry S · Tunbridge, VTBuilt 1977 · S/N 1502N153MWCzaban John D · Moriarty, NMBuilt 1978 · S/N 3227N153VFlynn Thomas J · Madison, VABuilt 1978 · S/N 20605N154ASFlint River Soaring LLC · Bainbridge, GABuilt 1967 · S/N 13007N155SSTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 1722N155WSSky Sailing Inc · Warner Springs, CAS/N 3786-K-64N158SSCounter Aviation Services LLC · Omaha, NEBuilt 1978 · S/N 3142N15BTZobell Edward A · California, MDBuilt 1972 · S/N 15236N15KSCichy Roger D · North Scituate, RIBuilt 1972 · S/N 15232N15LJNatke Gregory I · Manlius, NYBuilt 1969 · S/N 15031N15RCSnadecki Eric A · Fort Bragg, NCBuilt 1970 · S/N 15096N15XSSpencer Scott A · Brownsburg, INBuilt 1971 · S/N 15152N160SSFault Line Flyers · Leander, TXBuilt 1978 · S/N 3143N1618Knauff & Grove Inc · Julian, PABuilt 1967 · S/N 13033N1679Orion Flugworks LLC · Waterbury Center, VTBuilt 1968 · S/N 13073N168NLee Russell J · Newcastle, WABuilt 1976 · S/N 20116N1691Wampler William R · Albuquerque, NMBuilt 1984 · S/N 101AP128N170FFShryack Mark E · Glen Rose, TXBuilt 1975 · S/N 17044N170PMLawrence Vincent J · Littleton, COBuilt 1983 · S/N 101A0098N1715Burt Compton Enterprises Inc · Marfa, TXBuilt 1967 · S/N 13026N1749Adrian Soaring Club Inc · Ypsilanti, MIBuilt 1967 · S/N 13046N174SSFlying L Aircraft Inc · Fort Denaud, FLBuilt 1980 · S/N 3543N1765Taylor William E · Escanaba, MIBuilt 1967 · S/N 13030N177RFJones Gary R · Albany, NYBuilt 1972 · S/N 272N178KLohre Charles R · Cincinnati, OHBuilt 1970 · S/N 15062N179KSHollister Soaring Center LLC · Hollister, CAS/N 21236N184NHarper Robert J · Broken Arrow, OKBuilt 1969 · S/N 9N184SSChilcott Bret A · Derby, KSBuilt 1981 · S/N 5532SN186SSWarren Mark P · Memphis, TNBuilt 1987 · S/N 101-004N18AGJersey Ridge Soaring LLC · Blairstown, NJBuilt 1982 · S/N 3714N18CFLevy Niv · Torrance, CABuilt 1972 · S/N 15187N18MGThomas Nicholas J · Incline Village, NVBuilt 1985 · S/N 4N196HSale Reported · AlbertaSale reportedBuilt 1977 · S/N 19139N1975SSines Keith L · Keyser, WVBuilt 1975 · S/N 20033N19DTAgnew Alfred P · West Palm Beach, FLBuilt 1978 · S/N 19193N19FZTagliani James M · Dewey, AZBuilt 1976 · S/N 19020N19HGSoaring Science Inc · Wilmington, DES/N 19255N19JEKozlik Wiktor · Ramsey, NJBuilt 1978 · S/N 19214N19JNBrannan Patrick S · Saint Louis, MOBuilt 1979 · S/N 19294N19KLRuskauff David J · Geneseo, NYS/N 19058N19LKCanty Jeremiah D · Burke, VABuilt 1981 · S/N 19353N19MLEyler Stuart L · Oceanside, CABuilt 1982 · S/N 19373N19MROpitz Martin H · Seymour, CTBuilt 1978 · S/N 19191N19PLGarbacz Christina B · Chicago, ILBuilt 1977 · S/N 19138N1LGEnglish Aero G · Amory, MSS/N 4-139N1UDSpontak James S · Etters, PABuilt 1970 · S/N 34
Back to AD 97-08-06 R1