AD 97-01-13

Registered aircraft · 54,837

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-01-13')
    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-01-13')
  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.

N2991KHayton James B · Sedro Woolley, WAS/N 18053154N2991SVanbrocklin Valerie A · Anchorage, AKBuilt 1967 · S/N 15066891N2991UNeary Joseph P · Lindenhurst, ILBuilt 1963 · S/N 17250591N2991XDewald David J · Fort Wayne, INBuilt 1967 · S/N 17700391N2991YRabska William G · Suisun City, CABuilt 1962 · S/N 18253991N2992SN2992s LLC · Bristol, VTBuilt 1967 · S/N 15066892N2993CFrei Jayci N · Grangeville, IDS/N 30893N2993FDaniels Aviation Inc · Inverness, MSS/N 18257093N2993SCintron Jaime · Lake City, FLS/N 15066893N2993U63 Aviation LLC · Petoskey, MIBuilt 1963 · S/N 17250593N2993XKreutzer Charles · Springfield, ILBuilt 1967 · S/N 17700393N2993YBranch Robert W · Fort Mohave, AZS/N 18253993N2994ADicicco Matthew Trustee · Los Gatos, CABuilt 1953 · S/N 30194N2994ESkyventure Aviation LLC · Battle Creek, MIBuilt 1979 · S/N 17271398N2994XBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 17700394N2995FCj3 Aviation LLC · Idaho Falls, IDBuilt 1966 · S/N 18257095N2995SWillard Kevin C · Bartlett, NEBuilt 1967 · S/N 15066895N2996CSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 30896N2996FSmooth Air LLC · Mequon, WIBuilt 1966 · S/N 18257096N2996JDziadaszek Daniel J · Yemassee, SCBuilt 1966 · S/N 15065796N2996SKingdom Air Corp · Sutton, AKS/N 15066896N2996XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700396N2996YCrowe Timothy P · Gilbert, AZBuilt 1962 · S/N 18253996N29970Andrecheck Cynthia R · Bethel, AKBuilt 1981 · S/N 185-04292N29972Windblown Ranch Inc · Echo, ORBuilt 1981 · S/N 185-04162N2997CSmith Philip W · Copeland, KSBuilt 1955 · S/N 30897N2997UWilliams Michael L · Skaneateles, NYBuilt 1963 · S/N 17250597N2997YSkyriders LLC · Flagstaff, AZBuilt 1962 · S/N 18253997N2998FChristian Halls International · Arlington, TXBuilt 1966 · S/N 18257098N2998KWallingsford Don C · Yorba Linda, CABuilt 1980 · S/N 18053155N2998YReynolds Peter · Athol, MABuilt 1962 · S/N 18253998N2999AFindly Raymond Lee · Ravenna, KYBuilt 1953 · S/N 30199N2999CCarnine Daniel L · Seeley Lake, MTBuilt 1954 · S/N 30899N2999SZheng Zheng · Walnut, CABuilt 1967 · S/N 15066899N2999URichmor Aviation Inc · Hudson, NYBuilt 1963 · S/N 17250599N2999XPoore Zack W · Mcdonald, KSBuilt 1967 · S/N 17700399N299GBHoodoo LLC · Missoula, MTBuilt 1980 · S/N 421C1031N299MPayne Michael Allen · Montgomery, TXBuilt 1974 · S/N 17702216N299MWAbramovich Michael Pavel · Scottsdale, AZBuilt 1960 · S/N 15059071N299PTWright W Gregory III · Kinsale, VABuilt 1969 · S/N 18259631N299RQRds Aviation LLC · Powder Springs, GABuilt 1977 · S/N 177RG1167N29ANSouth Aero Inc · Albuquerque, NMBuilt 1999 · S/N 208B0753N29BCD' Jm Holdings LLC · Sugar Land, TXBuilt 1974 · S/N P3370172N29BEAltaii Ali · Gibraltar, MIBuilt 1971 · S/N 340-0005N29CMChenango 11 LLC · Wilmington, DEBuilt 1976 · S/N 18264793N29ERCosta Air Service LLC · Painted Post, NYBuilt 1977 · S/N 17269532N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191N29FLTorres Chris · Princeton, CABuilt 1968 · S/N 18258813N29HLSchreiber Christopher · Foley, ALBuilt 1975 · S/N 17266262N29JFJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 18259450
Back to AD 97-01-13