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.

N2658FClayton Alfred T · Anchorage, AKBuilt 1965 · S/N 18256758N2658GSauer Roger A · Glenburn, NDBuilt 1959 · S/N 51958N2658JLife Finds A Way LLC · Sarasota, FLBuilt 1966 · S/N 15065658N2658RNorthern Science Services LLC · Anchorage, AKBuilt 1967 · S/N 18258358N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959N2659KWickline Wayne · Flower Mound, TXBuilt 1985 · S/N 18268502N2659QMorrison Mark C · Marfa, TXBuilt 1966 · S/N 18257859N2659RBerrios Antonio · Genoa, ILBuilt 1967 · S/N 18258359N2659SRovey Gerald A · Troy, IDBuilt 1973 · S/N 18502261N2659ZWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284521N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081N265HPN265hp LLC · Parachute, COBuilt 1985 · S/N 18268519N265KPKalinin Partners LLC · Juneau, AKS/N 20800375N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996N265RGHerron Aviation Group LLC · Dexter, MIS/N 421C0833N2660Applegate Land Holdings LLC · Jacksonville, ORBuilt 1981 · S/N 18268100N26601Trowbridge Rodney L · Haysville, KSBuilt 1968 · S/N 18259083N2660FWheels Up Aviation Inc · Lewes, DES/N 18256760N2660GFruge Cory · Egan, LABuilt 1959 · S/N 51960N2660RPa Bo Ma Inc · Alexandria, LABuilt 1967 · S/N 18258360N2660UUnited Front Holdings LLC · Laguna Hills, CABuilt 1981 · S/N 421C1210N2660YRam Aviation LLC · Palmer, AKBuilt 1962 · S/N 18051160N2661ABerry Scott F · Destin, FLBuilt 1968 · S/N 18259102N2661LHall David B Jr · Midland City, ALBuilt 1967 · S/N 17255861N2661QAlred Robert I · Barrow, AKBuilt 1966 · S/N 18257861N2661UMoret Ronald P · Los Osos, CABuilt 1963 · S/N 17250261N2661YAlaska Outdoor Consultants LLC · King Salmon, AKBuilt 1962 · S/N 18051161N2662GWhitman Monty · Pagosa Springs, COBuilt 1959 · S/N 51962N2662JHanel Bruce · Placerville, CABuilt 1966 · S/N 15065662N2662LWaller Leslie P · Cynthiana, KYBuilt 1967 · S/N 17255862N2662UDeal Sarah M · Saint Joseph, MIBuilt 1963 · S/N 17250262N2662VPeck Kim O · Bolton, MABuilt 1974 · S/N 177RG0647N2663QBerg Weston L · Stanton, NDBuilt 1966 · S/N 18257863N2663SMaclean Kenneth J · Northborough, MABuilt 1968 · S/N 337-0963N2663UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250263N2664FWisconsin Aviation Inc · Watertown, WIBuilt 1980 · S/N 414A0534N2664LAce Airways LLC · Quincy, WABuilt 1980 · S/N 414A0535N2664SMcclain Daniel S · Enon Valley, PABuilt 1968 · S/N 337-0964N2664VKeaveny Kelly J · Annandale, MNBuilt 1974 · S/N 177RG0648N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201N2665LKay Bennie L · Brigham City, UTBuilt 1967 · S/N 17255865N2666DDrda Enterprises LLC · Denver, COS/N 340A0717N2666GForward Logistics LLC · New Castle, VABuilt 1959 · S/N 51966N2666JA-Leasing · Dayton, OHS/N 340A0718N2666QCloos Randy J · Osburne, IDBuilt 1966 · S/N 18257866N2666SHageness Hartley · Rugby, NDBuilt 1968 · S/N 337-0966N2666URegistration Pending · Decatur, TXRegistration pendingBuilt 1963 · S/N 17250266
Back to AD 97-01-13