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.

N3176YThomas Steven Dale · Monticello, ILS/N 18254176N3177Duvall John M III · Cincinnati, OHBuilt 1967 · S/N 17700660N3177CRsb Properties LLC · Lewes, DEBuilt 1978 · S/N R18200248N3177JDouble Rr Holdings LLC · Dallas, TXS/N 15065877N3177SFreeman William R · Lenexa, KSBuilt 1964 · S/N 18255677N3177TCain James W · Big Rapids, MIBuilt 1967 · S/N 17700477N3177VSmith Daniel P · St George, UTBuilt 1974 · S/N 15076409N3177XBandy Suzanne M · Newport, ORBuilt 1966 · S/N 15064577N3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeBuilt 1962 · S/N 18254177N3178DSager Kenneth A · Hummelstown, PABuilt 1955 · S/N 31976N3178JBirmingham Pilot Academy LLC · Birmingham, ALS/N 15065878N3178TAdvantage Aviation Services LLC · South Saint Paul, MNS/N 17700478N3178YNiles Air LLC · Concord, NCBuilt 1962 · S/N 18254178N3179CWoods Kevin M · Spokane, WABuilt 1954 · S/N 30978N3179DPreiss James M Trustee · Poplar Grove, ILBuilt 1955 · S/N 31977N3179FMoran Peter J · Como, MSBuilt 1966 · S/N 18257279N3179JTri-County Flyers LLC · Morgantown, PABuilt 1966 · S/N 15065879N3179YWolstein Joe M · Bigfork, MTBuilt 1962 · S/N 18254179N317ACChickenhawk Inc · Wilmington, MABuilt 1975 · S/N 17265537N317GTKatz Gary G · Louisville, KYBuilt 1962 · S/N 17249734N317KAWycka Michelle Sarah · Stayton, ORS/N 18254317N317MZValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 414A-0633N318Liberty University School Of Aeronautics · Lynchburg, VAFirst renewal noticeBuilt 1966 · S/N R172-0006N31803Mekker Mark S · Getzville, NYS/N 18052420N3180DKleimer Steve · Bozeman, MTBuilt 1955 · S/N 31978N3180QA & L Aircraft Holding LLC · Miami Springs, FLBuilt 1967 · S/N 18258180N3180RThomas Lance E Trustee · Mesa, AZBuilt 1967 · S/N 18258580N3180UBasan Oasis LLC · Santa Teresa, NMBuilt 1963 · S/N 18254580N3180YWalker Jim · Lovell, WYBuilt 1962 · S/N 18254180N3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeBuilt 1954 · S/N 30980N3181SWood David M · Purcellville, VABuilt 1964 · S/N 18255681N3181TDuck Donald S · Edwardsburg, MIBuilt 1967 · S/N 17700481N3181XHart George · Roseville, CABuilt 1966 · S/N 15064581N3182DHanft Thomas A · Oakhurst, CABuilt 1955 · S/N 31980N3182QMagnusson Ralph L · Wyoming, MNBuilt 1967 · S/N 18258182N3182RSeven Hills Sky Divers Inc · Madison, WIBuilt 1967 · S/N 18258582N3182SRyan Aviation Management LLC · Palm Coast, FLBuilt 1964 · S/N 18255646N3182UGarcia-Martinez Jose Victor · Birmingham, ALBuilt 1963 · S/N 18254582N3182XHerrera Lizann · Sumner, WABuilt 1966 · S/N 15064582N3182YHeckethorn Philipp · Baker, NVBuilt 1962 · S/N 18254182N3183CWide Open Aviation LLC · Kennewick, WABuilt 1978 · S/N R18200251N3183DT2k Aircraft · Austin, TXBuilt 1955 · S/N 31981N3183JRank Brian Andrew · Oxford, MIBuilt 1966 · S/N 15065883N3183QMj Syndicate LLC · Vancouver, WAS/N 18258183N3183RRusso Anthony G · Melbourne Beach, FLS/N 18258583N3183SJohnson Richard · Winnebago, MNBuilt 1964 · S/N 18255683N3183XTrimble John Sr · Stone Mountain, GABuilt 1966 · S/N 15064583N3183YAlc Aviation LLC · Milwaukee, WIBuilt 1962 · S/N 18254183N3184DRitchie Rex W · Lopez Island, WABuilt 1955 · S/N 31982N3184QBeaugh Anthony H · Platteville, COBuilt 1967 · S/N 18258184
Back to AD 97-01-13