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.

N2885YMiner Bradford Aviation LLC · Spanish Fork, UTS/N 18253885N2886FWeldon Larry W · Titusville, PABuilt 1966 · S/N 18256986N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886N2886UVon Linsowe David J · Vero Beach, FLBuilt 1963 · S/N 17250486N2887EMeeker Stanton · Squaw Valley, CABuilt 1978 · S/N 17271360N2887LMello Stephen F · Ludlow, MABuilt 1967 · S/N 17256087N2887RNaylor Michael Scott · Modesto, CABuilt 1967 · S/N 18258487N2887SRobinson Andrew K · Pahrump, NVBuilt 1967 · S/N 15066787N2887XTolmachev Nikolay A · Anchorage, AKS/N 17700287N2888ESterett Terry Alan Jr · New Port Richey, FLBuilt 1982 · S/N 18268218N2888FLynch Neil E · Ceresco, MIBuilt 1966 · S/N 18256988N2888KBooth William R Jr · Sterling, AKBuilt 1979 · S/N 18053119N2888QChilds William C · Bridgeport, ALS/N 17259888N2888UBodo Martin Trustee · Los Altos Hills, CABuilt 1963 · S/N 17250488N2889EWesellhigh LLC · West End, NCBuilt 1982 · S/N 18268219N2889FLander Kirt E · Kingman, AZBuilt 1966 · S/N 18256989N2889LSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N 17256089N2889RAircraft Structural Repair Inc · Hamilton, MTBuilt 1967 · S/N 18258489N2889SKinter Christopher A · Kodiak, AKS/N 15066789N2889XKogele Donald J · Broadus, MTBuilt 1967 · S/N 17700289N2889YJust Jump Skydiving LLC · Laurens, NYBuilt 1962 · S/N 18253889N288AMAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 208B5641N288LSVacendak William A · Wasilla, AKS/N 32953N288LTGlatczak Jerome · Schofield, WIBuilt 1963 · S/N 18255038N288PCWright Air Service Inc · Fairbanks, AKBuilt 2007 · S/N 208B1270N288RWNortheastern Assets Holdings LLC · Dover, NHS/N 18267369N288TMSlaba Mark E · Arcadia, FLBuilt 1967 · S/N 18258263N2890FAeolus Aviation LLC · Franklin, TNBuilt 1966 · S/N 18256990N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890N2890SKeyte Clinton W · Colfax, CABuilt 1967 · S/N 15066790N2890URedley Andrew Scott · Maryville, TNBuilt 1963 · S/N 17250490N2890VTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 15076313N2890YWomble Warren G · Chapel Hill, NCBuilt 1962 · S/N 18253890N28913Bellas Business LLC · Kalispell, MTBuilt 1973 · S/N 340-0153N2891ARegistered aircraftBuilt 1953 · S/N 30091N2891FBayshore Properties LLC · Hagerstown, MDBuilt 1966 · S/N 18256991N2891VSchaller Lee · New Athens, ILFirst renewal noticeBuilt 1974 · S/N 15076314N2892EJaars Inc · Waxhaw, NCBuilt 1978 · S/N 17271363N2892FSpeedtape Airways LLC · Williamson, GABuilt 1966 · S/N 18256992N2892LSellers Michael E · Clam Gulch, AKBuilt 1967 · S/N 17256092N2892RBuenafe Constance Ann · Santa Fe, NMBuilt 1967 · S/N 18258492N2893EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271364N2893UMerrell Jon P · Wolcott, NYBuilt 1963 · S/N 17250493N2893XOlson Philip D · Garden Plain, KSBuilt 1967 · S/N 17700293N2894LJohnson Nancy B · Vestavia Hills, ALBuilt 1967 · S/N 17256094N2894QFerkin Mark A · Caldwell, IDBuilt 1971 · S/N 17259894N2894VCuthbertson Steven M · Van Alstyne, TXBuilt 1974 · S/N 15076316N2895AAirspace Aerial Media LLC · Saint Louis, MOBuilt 1953 · S/N 30095N2895FWilson Paul D · Peachtree Corners, GABuilt 1966 · S/N 18256995N2895QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259895
Back to AD 97-01-13