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.

N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659N246LSJohnson Mark · Macon, MSS/N 32185N246PAHugie Lucas R · Logan, UTS/N 18257487N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023N246TRegistered aircraftBuilt 1981 · S/N 18268091N246TFMorgan Daniel D · Topeka, KSS/N R18201677N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332N2470CMcclymond Tyler L · Grand Junction, COS/N 30770N2470GBaillargeon Richard W · Springville, IABuilt 1959 · S/N 51770N2470LSmith Joseph · Sycamore, ILBuilt 1966 · S/N 17255670N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670N2470UT C I Aviators LLC · Lewes, DEBuilt 1963 · S/N 17250070N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771N2471EWilliams Stephen H · Phoenix, AZBuilt 1982 · S/N 18268206N2471JKrisch Garry A · Kenedy, TXBuilt 1966 · S/N 15065571N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571N2471YRegistered aircraftBuilt 1962 · S/N 17249771N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674N2472JDolev Eyal · Portland, ORBuilt 1977 · S/N 15279969N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573N2474EBas Part Sales LLC · Greeley, COS/N 17271297N2474JSingleton Addison L · New Bedford, MABuilt 1966 · S/N 15065574N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774N2474UPistor Elise D · Colleyville, TXBuilt 1963 · S/N 17250074N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374N24752Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280355N2475CHansen Curtis · Merrimack, NHBuilt 1954 · S/N 30775N2475QStumpf Walter · Tulsa, OKBuilt 1966 · S/N 18257675N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375N24763Big South Fork Aerospace LLC · Pine Knot, KYBuilt 1977 · S/N 15280361N24764Riya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280362N24765Alpha Aircraft International LLC · Lake Worth, FLS/N 15280363N24766Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280364N24767Tennessee Technology Center At Morristown · Morristown, TNBuilt 1977 · S/N 15280365N2476CBrown Jack P · Anchorage, AKBuilt 1954 · S/N 30776
Back to AD 97-01-13