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.

N2197YWeber Raymond E · Palmer, AKBuilt 1962 · S/N 17249697N21980Harris Kenneth L · Greeley, COBuilt 1973 · S/N 15074586N21981Mahoney Thomas H · Dorrance, KSS/N 15074587N21986Corr Harvey R · Nipomo, CABuilt 1973 · S/N 15074591N2198GAirstar Aviation Inc · Chester, SCBuilt 1958 · S/N 51498N2198ROlson Darryld A · Buckley, WAS/N 18255398N2198SPeavey Brian H · Houston, TXBuilt 1979 · S/N R18201314N2198YCustard Ray · Houston, TXBuilt 1962 · S/N 17249698N21990Mcmahan William K · Sandy Valley, NVS/N 15074594N21997Myers Donald W II · Saint Francisville, LAS/N 15074599N2199GEmery Craig A · Wasilla, AKBuilt 1958 · S/N 51499N2199UWood James DBA · Memphis, MOS/N 18800799N219JKMiller Charles Jr · Kill Devil Hills, NCS/N 15075463N219RADorshorst Dustin J · Deforest, WIBuilt 1971 · S/N 15072929N21ADBogart Donald W Jr · Long Beach, CABuilt 1961 · S/N 18253313N21ATMeadville Aero Club LLC · Erie, PABuilt 1977 · S/N 17268907N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456N21BMGandee James T · Bullhead City, AZS/N 21061941N21CFSmith Robert R · Benton, LABuilt 1974 · S/N 17702163N21CPT Howard And Associates Architects Inc · Dallas, TXBuilt 1961 · S/N 18253721N21CSHendrix Peter A · Plantation, FLBuilt 1973 · S/N 310Q0963N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021N21DFDose Gary W · Pinehurst, IDBuilt 1977 · S/N 18265789N21EBSunview Flying Service LLC · Jordan, NYBuilt 1974 · S/N 177RG0589N21EWRountree Christopher B · Burbank, CAS/N 18255335N21FC310 Pals LLC · Lake City, FLBuilt 1974 · S/N 310Q1080N21FFHor Aviation LLC · Harrisburg, PABuilt 1969 · S/N 18260179N21GBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 310R-1580N21GFBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B-0209N21HAEngle Scott · Plymouth, MNS/N 310R1850N21KBLow Carl S III · Aurora, TXBuilt 1973 · S/N 310Q0777N21KDMrd Aviation LLC · Windsor, COBuilt 1979 · S/N 414A0439N21KRNorcon Enterprises Inc · Amarillo, TXFirst renewal noticeBuilt 1979 · S/N P21000285N21LDCaswell Bruce · Charleston, WVBuilt 1963 · S/N 18255173N21LS7ac Aviation LLC · Fort Worth, TXBuilt 1964 · S/N 17251817N21LTMission Flight · El Monte, CABuilt 1979 · S/N P21000216N21LWRegistered aircraftBuilt 1973 · S/N 18261932N21MBAarons David J · Birmingham, ALBuilt 1975 · S/N 15077002N21PLYankee Flying Club Inc · Maple Grove, MNBuilt 1984 · S/N R18201983N21PVPeterson Kirk A · Nixa, MOBuilt 1966 · S/N 18256921N21RGMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700066N21RHWogan Joseph M · Mesa, AZBuilt 1972 · S/N 18261224N21RPJ-Dawgs Aviation LLC · Greenville, NCS/N 17252591N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039N21SJPointcloud Aviation LLC · Plymouth, MNBuilt 1981 · S/N 18267869N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473N21TBAughinbaugh Christopher · Rancho Cordova, CABuilt 1966 · S/N 18257128N21TGSale Reported · Cape Coral, FLSale reportedBuilt 1972 · S/N 18261547N21TNNavar Thomas R Jr · El Paso, TXS/N 31685N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650
Back to AD 97-01-13