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.

N172RWD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272209N172SAHalbauer Peter · Hartford, WIBuilt 1969 · S/N 17258302N172SBBirmingham Flight Center LLC · Birmingham, ALBuilt 1976 · S/N 17267683N172SFTichy Joseph R · Napa, CABuilt 1984 · S/N 172RG1149N172SGLehner Raymond A Jr · North Fort Myers, FLBuilt 1973 · S/N 17261734N172SKCruz Orlando R · Houston, TXBuilt 1978 · S/N 17271308N172SNBukowski Robert · Hot Springs, ARBuilt 1969 · S/N 17258428N172SPLuke Airlines LLC · Southgate, MIBuilt 1977 · S/N R172-2842N172SRDiaz Robert Dorantes · Coalinga, CAS/N 17267952N172SSWingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17260696N172SXPersonal Aviation Inc · Poway, CABuilt 1979 · S/N 17273641N172SZPowell Terry · Sheridan, WYBuilt 1975 · S/N 17265508N172TBBelli Paul · Philadelphia, TNBuilt 1970 · S/N 17259584N172TCMeweber Consulting Inc · Atlanta, MIBuilt 1976 · S/N 17266662N172TDSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 17258939N172THDairy Air Inc · Wyoming, PABuilt 1972 · S/N 17261033N172TKRhinelander Flying Service Inc · Rhinelander, WIBuilt 1978 · S/N 17270406N172TLRegistration Pending · Katy, TXRegistration pendingBuilt 1977 · S/N 17269706N172TMTactical Integrated Training Solutions LLC · Colorado Springs, COS/N 17270278N172TNRegistration Pending · San Antonio, TXRegistration pendingBuilt 1966 · S/N 17255519N172TPContrail Aviation Inc · Cheboygan, MIBuilt 1956 · S/N 28401N172TRSkoglund David L · Jamul, CAS/N 17269899N172TSVero Technical Support Inc · Pensacola, FLBuilt 1974 · S/N 17264582N172TTErvin Max W · Bend, ORBuilt 1961 · S/N 17248370N172TWGriffiths Larry F · Upland, CABuilt 1956 · S/N 29537N172TXD & L Innovations LLC · Hendersonville, TNS/N 17271027N172UCEndeavour Flight Training Inc · Opa Locka, FLBuilt 1978 · S/N 17271911N172UFR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273703N172UZMp Aviation LLC · Ogden, UTBuilt 1980 · S/N 17274011N172VFish Air Aviation LLC · San Diego, CABuilt 1985 · S/N 17276469N172VFVictor Foxtrot LLC · Scott City, KSBuilt 1975 · S/N 17265334N172VKKatula Gerard · Pawleys Island, SCBuilt 1968 · S/N 17257009N172VLEnce Daniel G · Saint George, UTBuilt 1964 · S/N 17251968N172VTFly Vermont LLC · Swanton, VTS/N 17263231N172VWVanwagnen Brian J · Jackson, MIBuilt 1961 · S/N 17249058N172VYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1963 · S/N 17250568N172WLaraux Arthur · Bethel, AKBuilt 1971 · S/N 17260099N172WAHandrop Ronald S · Bonita, CABuilt 1979 · S/N 17273507N172WBTumbleweed Leasing Company Inc · Salt Lake City, UTBuilt 1978 · S/N 17270907N172WEEl Aero Services LLC · Elko, NVBuilt 1975 · S/N 17265192N172WHSholund Stuart H · Elgin, ORBuilt 1961 · S/N 17249101N172WJBlue Skies Flight Training LLC · Gainesville, FLBuilt 1972 · S/N 17260906N172WLLeveille Wade P · Douglas, MABuilt 1975 · S/N 17265300N172WMChaves Roosevelt Jr · Fontana, CAS/N 17275539N172WNLegends Air Center LLC · Bentonville, ARBuilt 1978 · S/N 17270565N172WPAviair LLC · Wilmington, NCBuilt 1973 · S/N 17262635N172WRWind River Aviation LLC · Lawton, OKBuilt 1981 · S/N 17275113N172WSWoodstock Air LLC · Cincinnati, OHBuilt 1973 · S/N 17261328N172WTTison William A Jr · Boynton Beach, FLS/N 17266400N172WVMessner Mark R · Chesapeake, OHBuilt 1957 · S/N 36274
Back to AD 97-01-13