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.

N2862UWallace Jon W · Ozark, ARBuilt 1963 · S/N 17250462N2862XMathews Nancy M · Englewood, TNS/N 17700262N2862YDickson Troy S · Placerville, CABuilt 1962 · S/N 18253862N2863ASkipper Jonathan H · Fayetteville, GABuilt 1953 · S/N 30063N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352N2863FWright William J · Raeford, NCBuilt 1966 · S/N 18256963N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863N2863YPiontek Claudia A · Henderson, NVBuilt 1962 · S/N 18253863N2864FPreszler Sharon J · Mesa, AZBuilt 1966 · S/N 18256964N2864LTakle Management LLC · Bethany, OKS/N 17256064N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864N2864STop Aircraft Leasing LLC · Wilmington, DEBuilt 1967 · S/N 15066764N2864XCardinal Airways LLC · St Johns, FLBuilt 1967 · S/N 17700264N2865FMctaggart Briar · Oroville, CAS/N 18256965N2865LIfr LLC · Springfield, MOBuilt 1967 · S/N 17256065N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865N2865YSinclair Maurice A · Melrose, IAFirst renewal noticeBuilt 1962 · S/N 18253865N2866ATruman Sparks Aviation LLC · Snyder, TXBuilt 1953 · S/N 30066N2866FHowell Thomas F · Red Bluff, CAS/N 18256966N2866KDobransky Robert J · Peoria, AZBuilt 1979 · S/N 18053104N2866LRegistration Pending · Spring Branch, TXRegistration pendingBuilt 1967 · S/N 17256066N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866N2866VLyles Ed · Newnan, GABuilt 1974 · S/N 15076304N2866XFeller Gerald A · Long Beach, CAS/N 17700266N2867SJarrell Loyd F · Whitesburg, TNBuilt 1967 · S/N 15066767N2867XThrush Air Lc · Mason City, IABuilt 1967 · S/N 17700267N2867YCook Kevin M · Hallettsville, TXBuilt 1962 · S/N 18253867N2868ATaylor Eric C · Port Townsend, WABuilt 1953 · S/N 30068N2868FKilduff Transportation LLC · New River, AZBuilt 1966 · S/N 18256968N2868KMyers Mark D · Anchorage, AKBuilt 1979 · S/N 18053105N2868QRutherford Services Inc · Plains, PABuilt 1971 · S/N 17259868N2869LHelmstetler John D · Mt Vernon, TXBuilt 1967 · S/N 17256069N2869QDurnall Daniel J · Sonora, CABuilt 1971 · S/N 17259869N2869RDiehl Steven L · Martinsburg, PABuilt 1967 · S/N 18258469N2869UDavis Isabelle L · Mason, NHBuilt 1971 · S/N 18052216N2869YDurand Russell Gene · Luthersville, GABuilt 1962 · S/N 18253869N286ATN286at LLC · California, MDBuilt 2015 · S/N 208B5227N286PMPlanemasters Ltd · West Chicago, ILBuilt 1997 · S/N 208B0631N2870UKline Kevin J · Clyde, OHBuilt 1963 · S/N 17250470N2870YDabevv LLC · Salina, UTBuilt 1962 · S/N 18253870N2871KPace Robert A Jr · Pensacola, FLBuilt 1979 · S/N 18053107N2871RBlue Ridge Flyers Inc · Leesburg, VABuilt 1967 · S/N 18258471N2871USt Clair Dustin W · Cloverdale, CAS/N 17250471N2871YJohnson Cynthia Trustee · Sagle, IDS/N 18253871N2872AArdmore Aviation LLC · Russell Twp, OHBuilt 1953 · S/N 30072N2872KR N Geraci LLC · Lutz, FLBuilt 1979 · S/N 18053108N2872QTriad Aviation Academy LLC · Greensboro, NCBuilt 1971 · S/N 17259872N2872VRamirez Jose · Altadena, CABuilt 1974 · S/N 15076306N2873AAndelin Sheila P · Newport Beach, CABuilt 1953 · S/N 30073N2873QCloud Dancer Aviation Inc · Deland, FLBuilt 1971 · S/N 17259873
Back to AD 97-01-13