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.

N2735KCook Kyle R · Green Valley, AZBuilt 1979 · S/N 18053049N2735QRegistration Pending · Hearne, TXRegistration pendingBuilt 1967 · S/N 18257935N2735UKnepper Gary E · Canby, ORBuilt 1963 · S/N 17250335N2736GFor Skies Flying Club Ltd · Martinsville, ILBuilt 1959 · S/N 52036N2736KP M Logistics LLC · Haskell, OKBuilt 1979 · S/N 18053050N2736LWilson Steven W · N Richlnd Hls, TXFirst renewal noticeBuilt 1967 · S/N 17255936N2736QBachich George A · Napa, CABuilt 1967 · S/N 18257936N2736XMehling Michael R · Fairview, MTBuilt 1965 · S/N 18051536N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643N2737KFanazick Joseph P · Juneau, AKBuilt 1979 · S/N 18053051N2737LAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 17255937N2737SBlock Oliver L · Nashville, TNBuilt 1967 · S/N 15066637N2737XFly-By Aviation Services LLC · Colorado Springs, COBuilt 1965 · S/N 18051537N2738BSonrise Aviation LLC · Portland, INBuilt 1979 · S/N 310R1828N2738LDemkiewicz Daniel · Houston, TXBuilt 1967 · S/N 17255938N2738UVan Der Waal Allan L · Port Angeles, WABuilt 1963 · S/N 17250338N2739CLge Flying Club Inc · Marietta, GABuilt 1978 · S/N R18200223N2739GSwanson Gordon · Prescott, AZS/N 52039N2739JCiulla Santo · Odessa, FLBuilt 1974 · S/N A1500578N2739LHall Barbara S · Burgettstown, PABuilt 1967 · S/N 17255939N2739UN2739u Holding LLC · New Orleans, LABuilt 1963 · S/N 17250339N2739XSvoboda Realty Inc · Bucyrus, KSFirst renewal noticeBuilt 1965 · S/N 18051539N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018N273HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800721N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732N273TYRaven Aviation LLC · Lexington, KYBuilt 1965 · S/N 15061468N2740LLightsey Aviation LLC · Jacksonville, FLS/N 17255940N2740TKraybill Paul D · Portola Valley, CABuilt 1979 · S/N 310R1843N2740UHarowicz Richard J · Mountain Top, PABuilt 1963 · S/N 17250340N2740VTheo Enterprises LLC · New Castle, DEBuilt 1975 · S/N 177RG0677N2741UNickel Aviation LLC · Williamstown, NJBuilt 1963 · S/N 17250341N2742HWilbert John W III · Plaquemine, LABuilt 1979 · S/N 340A0929N2742LFisher Corey · Ardmore, OKBuilt 1967 · S/N 17255942N2742QKibler James · Indialantic, FLBuilt 1967 · S/N 18257942N2742UPembroke Farm LLC · Conowingo, MDBuilt 1963 · S/N 17250342N2742XCallaway Scott T · Soldotna, AKBuilt 1965 · S/N 18051542N2743FRiddle Danny M Trustee · Ruby Valley, NVBuilt 1965 · S/N 18256843N2743GFleetwood Jack · Hutto, TXBuilt 1959 · S/N 52043N2743LBarnes Earl E · Live Oak, FLBuilt 1967 · S/N 17255943N2743QSzigeti David J · Gaylordsville, CTBuilt 1967 · S/N 18257943N2743UArmstrong John Kyle · Lovington, NMBuilt 1963 · S/N 17250343N2743XErb Weston Scott Trustee · Wasilla, AKBuilt 1965 · S/N 18051543N2744CBrewer Farms · Thompson, MOBuilt 1978 · S/N R18200224N2744FTyson Jacob N · Molena, GABuilt 1965 · S/N 18256844N2744GShelton Jeffrey A · Denali Park, AKS/N 52044N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644N2744KLucas Greg C · Elmore City, OKS/N 18053057N2744PTouchdown LLC · Pls Vrds Est, CABuilt 1979 · S/N 340A0941N2744UFladager Daryl W · Peerless, MTS/N 17250344N2744XAccelerated Slipstream LLC · Livermore, CABuilt 1981 · S/N 414A0812
Back to AD 97-01-13