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.

N20843St Louis Flying Club Inc · Ellisville, MOBuilt 1974 · S/N 17263853N20845Clark Bradley D · Kirkwood, ILFirst renewal noticeS/N 18261252N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148N2084GFlying Farmers LLC · Hills, MNBuilt 1958 · S/N 51384N2084RTej Builds Air LLC · Winchester, VABuilt 1964 · S/N 18255284N2084XPrier Duncan M · Bonita Springs, FLBuilt 1965 · S/N 18256184N2084YRegistration Pending · Monroe, MIRegistration pendingBuilt 1962 · S/N 17249584N20852Spaulding Kenneth L · Sahuarita, AZBuilt 1972 · S/N 18261258N20854Branson Bonanza Club · Branson, MOBuilt 1972 · S/N 18261260N20855Mission Aviation LLC · Billings, MTBuilt 1972 · S/N 18261261N20856Pointon Martin J · Snohomish, WABuilt 1972 · S/N 18261262N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857N20859Anderas Per R · Green Bay, WIS/N 18261264N2085GBackcountry Guys LLC · Prescott, AZS/N 51385N2085XBrian Murray J · Pekin, ILBuilt 1965 · S/N 18256185N2085YLima Romeo Kilo Golf Lp · Worthington, INBuilt 1973 · S/N 18502151N20862Barrington Aviation LLC · Kalamazoo, MIBuilt 1972 · S/N 18261267N20865Agasair LLC · East Hampton, NYBuilt 1974 · S/N 17263859N2086GHigh Country Aces LLC · Cove, ARBuilt 1958 · S/N 51386N2086QMillner Paul · Berkeley, CABuilt 1974 · S/N 177RG0486N2086XPerron Joseph R · Jasper, GABuilt 1965 · S/N 18256186N2086YLewis Mark N · West Plains, MOBuilt 1956 · S/N 28318N20870Willis David A · Thief River Falls, MNBuilt 1972 · S/N 18261274N20871High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17263862N20876Ogalalla Land & Cattle Ltd · Douglas, WYS/N 17263863N20877Teton Leasing LLC · Pocatello, IDBuilt 1972 · S/N 18261279N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150N2087FH & M Ltd · Warren, IDS/N 18264886N2087GTate Frederic H S DBA · Marfa, TXBuilt 1958 · S/N 51387N2087RMangus Ricky Alan · Kent, WABuilt 1964 · S/N 18255287N2087YEllsworth Matthew R · Fairbanks, AKBuilt 1963 · S/N 17249587N2087ZFischer Gary H · Savannah, GABuilt 1963 · S/N 15059887N20882Stuart Roger G Jr · Mount Pleasant, TXBuilt 1972 · S/N 18261283N20888Baker Michael A · Watsonville, CABuilt 1972 · S/N 18261287N2088RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1964 · S/N 18255288N2088USimpson Equipment Leasing LLC · Hays, KSBuilt 1982 · S/N U20606610N2088YHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249588N20890Thomas Brett · Gettysburg, PABuilt 1972 · S/N 18261289N20891Morristown Flying Service Inc · Talbott, TNBuilt 1974 · S/N 17263867N2089ESkyhawk N2089e Ltd · Deerfield, ILBuilt 1978 · S/N 17271151N2089QKelly Daniel W · Conway, SCBuilt 1974 · S/N 177RG0489N2089STxt Aviation LLC · Deland, FLS/N R18201299N2089XMoravitz Kim J · Turtle Lake, WIBuilt 1965 · S/N 18256189N2089YSooter Craig A · Sedgwick, KSBuilt 1962 · S/N 17249589N208ABSkydive Guam Inc · Barrigada, GUBuilt 2008 · S/N 208B2047N208AJCessna 2080711 Inc Trustee · Wilmington, DEBuilt 1998 · S/N 208B0711N208ATLeciejewski Darrell K · Mc Alpin, FLBuilt 1976 · S/N 17268379N208AXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 208B0710N208BMerlin Labs Inc · Boston, MABuilt 2003 · S/N 208B1023N208BABoeing Co · Renton, WABuilt 2008 · S/N 208B2027
Back to AD 97-01-13