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.

N2574Y9th Moon Enterprises LLC · Alpine, TXS/N 17249874N25754Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280767N2575GAltes Matt · Mount Shasta, CABuilt 1959 · S/N 51875N2575JStein Gerald A · Tolar, TXBuilt 1965 · S/N 15061075N2575KSchlick David L · Poulsbo, WABuilt 1978 · S/N 18052997N2575SDulin Morgan L · Midland, TXBuilt 1968 · S/N 337-0875N2575VStone Tommy R · Jacksonville Beach, FLBuilt 1974 · S/N 177RG0622N2575YSky Unlimited · Portland, ORBuilt 1962 · S/N 17249875N2576LRiggin Flight Service Inc · Madison, SDS/N 17255776N2576QHamilton Steve · Carson City, NVBuilt 1966 · S/N 18257776N2576YRowe John W · Glen Haven, COBuilt 1962 · S/N 17249876N25772Arnold Jonathan L · Warrensburg, MOBuilt 1977 · S/N 15280774N25773Solberg Avn Co Inc · Whitehouse Station, NJBuilt 1977 · S/N 15280775N25775Van Es Mark E · Laredo, TXBuilt 1977 · S/N 15280777N25779Eads James · Saginaw, TXBuilt 1977 · S/N 15280780N2577JDelaney John T · Bangor, PABuilt 1964 · S/N 15061077N2577LKim L Jensen · Enoch, UTBuilt 1967 · S/N 17255777N2577QSlingsby J Geoffrey · Rapid City, SDBuilt 1977 · S/N 18503520N2577RSchomaker Michael J · Pleasanton, CABuilt 1967 · S/N 18258277N2577SHurt Randall L · Smithville, TNBuilt 1968 · S/N 337-0877N2577ZMaynard Christopher J · Anchorage, AKBuilt 1964 · S/N 185-0577N25785Iggy Enterprises LLC · Gig Harbor, WABuilt 1977 · S/N 15280783N2578JRenewed Inc · Tekamah, NEBuilt 1964 · S/N 15061078N2578YBush James W · Skaneateles, NYBuilt 1962 · S/N 17249878N2579GMcglachlin Brandon E · Moundridge, KSBuilt 1959 · S/N 51879N2579JMaatje Charles J · Egg Harbor City, NJBuilt 1964 · S/N 15061079N2579KSkywagon LLC · Sterling, AKBuilt 1978 · S/N 18053000N2579SMenagh Bret J · Fresno, CABuilt 1968 · S/N 337-0879N2579UHann Aviation LLC · Yuma, AZBuilt 1963 · S/N 17250179N257FK257fk LLC · Marathon, FLBuilt 1977 · S/N 17269126N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071N257JSDelaurentis Robert · San Diego, CABuilt 1978 · S/N 18266090N257LMSsb Aviation LLC · Wasilla, AKBuilt 1975 · S/N 18052548N257RRegistered aircraftBuilt 1957 · S/N 34411N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240N257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781N25807Peabody Jeffery L · Vinemont, ALBuilt 1977 · S/N 15280793N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880N2580JKingdom Air Corps · Sutton, AKBuilt 1964 · S/N 15061080N2581JStikeleather Fred A · Hiddenite, NCS/N 15061081N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002N2581VMink Stephen Earl · Walnut Creek, CABuilt 1974 · S/N 177RG0625N2581YOverman Aviation LLC · Saint Louis, MOS/N 17249881N25820Sale Reported · Xxx, OKSale reportedBuilt 1977 · S/N 15280799N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003N2582LRichardson Michael Todd · Wilkesboro, NCS/N 17255782N2582Q82q LLC · Glenwood, MDS/N 18257782N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282N25836Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280808N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883
Back to AD 97-01-13