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.

N2554LAirheads Inc · Charles Town, WVBuilt 1967 · S/N 17255754N2554RBartlett Richard H · Sussex, NJBuilt 1967 · S/N 18258254N2554SHanan Roy T · Edgewater, FLS/N 337-0854N2554UMustang Ops LLC · Orem, UTBuilt 1963 · S/N 17250154N2554ZClement L Ross · Anchorage, AKBuilt 1963 · S/N 185-0554N25557All Aviation Xp LLC · Parkland, FLBuilt 1977 · S/N 15280729N2555JRabenaldt Gilbert P · Telferner, TXRegistration revokedBuilt 1965 · S/N 15061055N2555LGates Kimberly B · Kintnersville, PABuilt 1967 · S/N 17255755N2555UBurull Donald E · Wichita, KSBuilt 1963 · S/N 17250155N25564Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280732N25567Ellingwood Kevin J · Williamstown, MABuilt 1977 · S/N 15280735N2556KCarlson Steven J · Fairbanks, AKS/N 18052986N2556YZeafla Randall R · Elizabethtown, KYBuilt 1962 · S/N 17249856N25572Gruetzmacher Marcus Darren · Goliad, TXBuilt 1977 · S/N 15280738N25573Adjoodani Farhad F · Glen Burnie, MDBuilt 1977 · S/N 15280739N25575Pierce John S · Delevan, NYBuilt 1977 · S/N 15280741N2557JSale Reported · Lake Havasu City, AZSale reported, canceledBuilt 1964 · S/N 15061057N2557LSparks Ryan J · Peculiar, MOBuilt 1967 · S/N 17255757N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257N2557SAgri-Flight LLC · Waterford, MIS/N R18201349N2557UWings Of Hope · Chesterfield, MOBuilt 1963 · S/N 17250157N2557YSaddle Mountain LLC · Cave Creek, AZBuilt 1962 · S/N 17249857N25582Heavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15280746N2558GScolari Shawn Fenton · Meeteetse, WYS/N 51858N2558JHay Douglas E · Anza, CABuilt 1965 · S/N 15061058N2558LHoecher Robert · Anchorage, AKS/N 17255758N2558RKahn Steven P · Boise, IDBuilt 1967 · S/N 18258258N2558UDelany Patrick J · Marion, TXBuilt 1963 · S/N 17250158N2559JStuder Alfred C · Shelby, MIBuilt 1979 · S/N T18803482TN2559LFlying Circus LLC · Bridgeport, WVBuilt 1967 · S/N 17255759N2559QJordan Valley Aviation LLC · Jordan Valley, ORBuilt 1966 · S/N 18257759N2559USnake River Flying Club LLC · Horseshoe Bend, IDBuilt 1963 · S/N 17250159N2559YA & D Precision Machining Inc · Fremont, CAS/N 17249859N255EWollak John M · Mount Vernon, WABuilt 1976 · S/N 15078149N255KRAvra Valley Flyers LLC · Gilbert, AZS/N 172-69860N255WFKlapmeier Alan L · Iron River, WIBuilt 1981 · S/N R18201655N25604Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 15280762N25608Smith Boyd · Goshen, INBuilt 1977 · S/N 15280764N2560GJackson Air LLC · Temecula, CABuilt 1959 · S/N 51860N2560JSmith Douglas J · Sidney, OHBuilt 1964 · S/N 15061060N2560USpangenberg Daniel M · Greenville, MIBuilt 1963 · S/N 17250160N25610Painter Bryan · Renton, WABuilt 1977 · S/N 15280766N2561QMariposa Aviation Inc · East Wenatchee, WABuilt 1966 · S/N 18257761N2561RHeber Valley Flying Club · Park City, UTBuilt 1967 · S/N 18258261N2561UNeinast Jeffrey J · Olton, TXBuilt 1963 · S/N 17250161N2562LWilkey Paul W · Sullivan, INBuilt 1967 · S/N 17255762N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262N2563JKrebs Charles · Suwannee, FLFirst renewal noticeBuilt 1964 · S/N 15061063N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330
Back to AD 97-01-13