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.

N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716N264DCAirdvm LLC · Rcho Sta Marg, CABuilt 1982 · S/N 421C1248N264KPKalinin Partners LLC · Juneau, AKBuilt 2004 · S/N 20800383N264MSanterre Phillip E Trustee · Chugiak, AKBuilt 1958 · S/N 50236N264SVBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 208B0462N265E&S Management LLC · Miami, FLBuilt 1975 · S/N P3370232N2650FFlight Time LLC · Highland, MIBuilt 1966 · S/N 18256750N2650GNewkirk Kevin J · Manhattan, KSS/N 51950N2650JNoll Cheryl A · Franklin, NCBuilt 1966 · S/N 15065650N2650LRholetter Eric W · Westminster, SCBuilt 1967 · S/N 17255850N26514Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0344N2651FMars Aviation LLC · Commerce City, COBuilt 1965 · S/N 18256751N2651LJohnson Turner C II · England, ARBuilt 1967 · S/N 17255851N2651SHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0342N2651VHagl Aviation LLC · Sunray, TXBuilt 1976 · S/N R1722226N2652FMartindale Lloyd M · Bellingham, WABuilt 1965 · S/N 18256752N2652LSullivan James M · East Wakefield, NHBuilt 1967 · S/N 17255852N2652RDevries Francis P · Justin, TXBuilt 1967 · S/N 18258352N2652VTrapp Terry Lee Trustee · The Dalles, ORBuilt 1974 · S/N 177RG0644N2653Barr Air Patrol LLC · Mesquite, TXBuilt 1982 · S/N 18268297N26533Txoperation LLC · Fort Scott, KSBuilt 1979 · S/N 421C0686N2653FBagstad Lance · Park Rapids, MNBuilt 1965 · S/N 18256753N2653GDevine Christopher C · Eagle River, AKBuilt 1959 · S/N 51953N2653QMoses And Associates Inc · Gainesville, FLBuilt 1966 · S/N 18257853N2653UClark Nikita C · Ontario, ORS/N 17250253N2654FGregory Daniel · Virginia Beach, VABuilt 1966 · S/N 18256754N2654LGriner Carrie L · Auburndale, FLBuilt 1967 · S/N 17255854N2654RFindarle John J · Midway, UTBuilt 1967 · S/N 18258354N2654VVankirwin Inc · Kinnelon, NJRegistration expired, pending cancellationBuilt 1974 · S/N 177RG0645N2654YHolty Joseph G · Fairbanks, AKBuilt 1962 · S/N 18051154N2655GBeachy Benjamin D · Whittington, ILBuilt 1959 · S/N 51955N2655NLetourneau David W · Valencia, CABuilt 1976 · S/N 15077878N2655QRedmond Angela L · Austin, TXBuilt 1966 · S/N 18257855N2655RBeck Bartholomew · Dry Ridge, KYBuilt 1967 · S/N 18258355N2655ZRegistered aircraftN-number assigned (import), not yet registeredS/N 185-0655N26560Rockslide Analytics Inc · Livermore, CAS/N 421C0802N2656CHgta Partners LLC · Grand Rapids, MIBuilt 1978 · S/N R18200196N2656JSperling Gabriel E · Silverdale, WABuilt 1966 · S/N 15065656N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029N2656LSzymanski Alexander G · Hernando, MSBuilt 1967 · S/N 17255856N2656QPankrate Kenneth W · Opheim, MTS/N 18257856N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757N2657GB & K Leasing Inc · Nantucket, MAS/N 421C0809N2657NLoreto Aviation LLC · Wahoo, NES/N 421C0811N2657S57 Sierra LLC · Houston, TXBuilt 1968 · S/N 337-0957N2657USzymanski Janet M · Alanson, MIBuilt 1963 · S/N 17250257N2657YNagy Leslie S · Walnut Creek, CABuilt 1962 · S/N 18051157N26588Golden Aero LLC · Tarpon Springs, FLBuilt 1980 · S/N 421C0835N2658CMay Jeffrey P · Seligman, AZBuilt 1978 · S/N R18200198
Back to AD 97-01-13