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.

N1664RState Of Montana · Helena, MTBuilt 1978 · S/N R18200503N1664VBismarck Aero Center Corp · Bismarck, NDBuilt 1974 · S/N 17263706N1664YOleary Joseph · Richmond, VTBuilt 1962 · S/N 17249364N1666QRegistration Pending · Plymouth, MNRegistration pendingBuilt 1971 · S/N 15072966N1666VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263707N1667FVarner Properties LLC · Bristow, OKBuilt 1966 · S/N 17255062N1667MTen Mile Ranch Inc · Vale, ORBuilt 1971 · S/N 18501859N1668MRocky Mountain High Aviation LLC · Louisville, COBuilt 1975 · S/N 18264409N1668QBrunk Hubert J · Lincoln, NEBuilt 1971 · S/N 15072968N1668REdwards Air Force Base Aero Club · Edwards Afb, CAFirst renewal noticeBuilt 1978 · S/N R18200505N1668TKevu Aviators LLC · Maryville, MOBuilt 1973 · S/N 414-0461N1668UUngalik Syndicate LLC · Unalakleet, AKBuilt 1975 · S/N 20700268N1669Berardinelli Michael A · Meridian, IDBuilt 1955 · S/N 31946N1669MC Y Transport LLC · Columbus, MNBuilt 1971 · S/N 18501861N1669QIvy James E · Alba, TXBuilt 1971 · S/N 15072969N166DGDg Air LLC · Oakland, TNS/N 18267796N166JBEp Aviation LLC · Wynne, ARS/N 18262300N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923N1670CAlaska Freight Services LLC · Fairbanks, AKBuilt 1953 · S/N 30370N1670FTillamook Pilots Association · Tillamook, ORBuilt 1966 · S/N 17255065N1670MFirebird Aviation LLC · Tempe, AZBuilt 1975 · S/N 18264410N1670THyde Family Aviation LLC · Wilmington, DEBuilt 1973 · S/N 414-0463N1670YMarshall Gregory A · Sauk Rapids, MNBuilt 1962 · S/N 17249370N1671QRegistered aircraftBuilt 1971 · S/N 15072971N1671RDavis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18502394N1671YDavid Dahl · Shevlin, MNBuilt 1962 · S/N 17249371N1672EWichita Area Technical College · Wichita, KSBuilt 1978 · S/N 17271089N1672QHall Donna L · Pulaski, TNS/N 15072972N1672RBriggs Donald L · Santa Barbara, CABuilt 1978 · S/N R18200507N1672YSmith David W · Texarkana, TXBuilt 1962 · S/N 17249372N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090N1673FHopkins Ronald J · Salt Lake City, UTFirst renewal noticeBuilt 1966 · S/N 17255068N1673MBower Ashley R · Anchorage, AKBuilt 1971 · S/N 18501865N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508N1673YLentz Gregory · Green Forest, ARBuilt 1962 · S/N 17249373N1674CFarwest Aviation LLC · Billings, MTBuilt 1953 · S/N 30374N1674FPlane Nuts Aviation LLC · Livingston, LABuilt 1966 · S/N 17255069N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709N1675MWenk Peter J · Ocala, FLBuilt 1971 · S/N 18501867N1676FBrunson Tim R · Gilmer, TXS/N 17255071N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510N1676YGray Bryan · Colorado City, TXBuilt 1962 · S/N 17249376N16771Tintman Inc · Spokane, WAS/N 15066452N1677CDavis Aero LLC · Incline Village, NVBuilt 1953 · S/N 30377N1677RYarger Denim B · Laurel, MTBuilt 1974 · S/N 185-02400N1678FHorne William D II · Oxford, MSBuilt 1966 · S/N 17255073N1678RPureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 18502401N1678TGabaldon Martin · El Paso, TXS/N 414-0471N1678ZLongmire Dale · Senoia, GABuilt 1962 · S/N 1850470N1679FCrawford Anthony B · Hampton Cove, ALBuilt 1966 · S/N 17255074
Back to AD 97-01-13