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.

N25932California In Nice Inc · San Jose, CABuilt 1977 · S/N 15280864N2593GIntelinair Geospatial LLC · Indianapolis, INBuilt 1958 · S/N 51893N2593LDaly Moses M · Underhill, VTBuilt 1967 · S/N 17255793N2593QRigoni Teresa Ann · Orting, WABuilt 1966 · S/N 18257793N2593UCamara Cesar David · Plumas Lake, CABuilt 1963 · S/N 17250193N25948Indiana State University · Terre Haute, INBuilt 1977 · S/N 15280875N2594LSheldon Paul T · Saint James, MNBuilt 1967 · S/N 17255794N2594QBarer Scott I · Westlake Village, CABuilt 1966 · S/N 18257794N2594YBruns John R Jr Trustee · Floyds Knobs, INBuilt 1963 · S/N 17249894N25950Gist Phillip C · Fort Worth, TXBuilt 1977 · S/N 15280877N2595LPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1967 · S/N 17255795N2595RDierenfeld Michael E · Northwood, IABuilt 1967 · S/N 18258295N2595UHare Sidney Wiggins · Roanoke, ALBuilt 1963 · S/N 17250195N2595YRenco Angelo · Oceanside, CAFirst renewal noticeBuilt 1962 · S/N 17249895N2596GThomas Carlton L · Center, COBuilt 1959 · S/N 51896N2596KPopov Chris · Hope, IDS/N 18504257N2596LBurris Cale · Hardin, ILBuilt 1967 · S/N 17255796N2596QEvening Star Aviation LLC · Corvallis, ORFirst renewal noticeS/N 18257796N2596RJones Jacob R · Rockford, TNBuilt 1967 · S/N 18258296N25976Skylogix Aircraft LLC · La Verne, CAS/N 15280890N25979Andrews University · Berrien Springs, MIS/N 15280892N2597KCrossno James · Fulshear, TXBuilt 1978 · S/N 18053010N2597QCattles Kenneth M Jr · Georgetown, TXBuilt 1966 · S/N 18257797N2597RWing Frederick K · Milton, MABuilt 1967 · S/N 18258297N2598YHarding William R Jr · Quinlan, TXBuilt 1963 · S/N 17249898N25995Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280903N25998Carlin Delbert J · Blanchard, OKS/N 15280905N2599YTalmadge Robert E · Vero Beach, FLBuilt 1962 · S/N 17249899N25AFKlik Daniel J · Washington Twp, MIBuilt 1963 · S/N 205-0418N25AWMukherjee Kaustuv · Simsbury, CTBuilt 1961 · S/N 18253616N25EBLeisurecorp Inc · Anchorage, AKBuilt 1976 · S/N 340A0043N25EFXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15280552N25ESGeneral Aviation Support Corp · Rosamond, CABuilt 1977 · S/N 17269082N25FCBlumhagen Ryan M · Drake, NDBuilt 1955 · S/N 31520N25FERound Trip Lc · Elkhart, KSS/N 421-0055N25FGState Of California Department Of Fish And Game · Sacramento, CAS/N 18504113N25GPAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N U20602889N25HTTobler Hans P · Anchorage, AKS/N 15281787N25JAPa1 208b-1212 LLC · Fort Lauderdale, FLBuilt 2006 · S/N 208B1212N25JCAvg LLC · Chico, CABuilt 1959 · S/N 57008N25JGCenturion Aircraft Limited · Centennial, COS/N P21000329N25LGJolymug LLC · Saratoga, CABuilt 1975 · S/N 177RG0624N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748N25MMFairweather Aviation Leasing LLC · Haines, AKFirst renewal noticeBuilt 1975 · S/N 18502827N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307N25RTOverton Clayton J III · Sioux Falls, SDBuilt 1977 · S/N 177RG1132N25SCBlain Robert John · Billings, MTBuilt 1966 · S/N 185 1055N25SKH & H Aviation Enteprises LLC · Fairfield, OHBuilt 1979 · S/N 17273152N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538N25WDSale Reported · Greeley, COSale reported, canceledBuilt 1978 · S/N P21000094
Back to AD 97-01-13