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.

N2958XCooper Ronald C · Fowlerville, MIBuilt 1968 · S/N 17700358N29592Reyner Matthew J · Georgetown, TXBuilt 1968 · S/N 17700978N29593Else John J · Toledo, IABuilt 1968 · S/N 17700979N29595Delta Fox Corp · Schaumburg, ILBuilt 1968 · S/N 17700980N29596Murray Charles W · Reno, NVBuilt 1968 · S/N 17700981N2959JJones Eugene B Jr · Pflugerville, TXBuilt 1966 · S/N 15065759N2959SCobb Patricia J Trustee · North Las Vegas, NVS/N 15066859N2959XCiochetti David · Kimberly, ORBuilt 1967 · S/N 17700359N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482N295GTMedina-Solla Edwin O · Carolina, PRBuilt 1966 · S/N 18257799N295THHowser Anthony J · Batavia, OHS/N 15072736N2960AGallman Alexander C · Livingston, TXBuilt 1953 · S/N 30160N2960JGlinsky Edward Jr · Rhome, TXBuilt 1966 · S/N 15065760N2960SDewitt Daniel · Camarillo, CABuilt 1967 · S/N 15066860N2960UMedford Mark A · Mantua, OHBuilt 1963 · S/N 17250560N29617Abbott Barry · Tempe, AZS/N 17700994N29619Loudenslager Donald F · Collinsville, OKBuilt 1968 · S/N 17700996N2961AMerrill Richard C · Chuckey, TNBuilt 1953 · S/N 30161N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061N2961JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803581TN2961SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15066861N2961XLaurina Peter · Knoxville, TNBuilt 1967 · S/N 17700361N2961YGarcia Kale B · Covington, WABuilt 1962 · S/N 18253961N29625Sale Reported · Fort Myers, FLSale reportedBuilt 1968 · S/N 17700998N2962AKapsner Mark W · Willow, AKBuilt 1953 · S/N 30162N2962EPaulisue Aviation LLC · East Saint Louis, ILBuilt 1978 · S/N 17271388N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062N2962XRomine John M · Broken Arrow, OKBuilt 1967 · S/N 17700362N2963CMcmillian Tommy D · Wasilla, AKBuilt 1954 · S/N 30863N2963FConnell Gary A · Anchorage, AKS/N 18257063N2963SDougherty Paul · Bethel, PABuilt 1967 · S/N 15066863N2963XWayner Ronald P · Sutton, AKBuilt 1967 · S/N 17700363N2963YMoretti Larry · Monroe, MIBuilt 1962 · S/N 18253963N29643Campbell Robert A · Dayton, TXS/N 17701005N29645Borgman Dale A · Rescue, CABuilt 1968 · S/N 17701006N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064N2964SRichardson David M · Dwight, ILBuilt 1967 · S/N 15066864N2964VPlane Awesome LLC · Plymouth, MAS/N 15076335N2964YVanderwel Paul · Woodinville, WABuilt 1962 · S/N 18253964N29651Geurs John Z · Ossian, INBuilt 1968 · S/N 17701009N2965CBauer Joachim · Rhome, TXFirst renewal noticeBuilt 1954 · S/N 30865N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065N2965UPatterson John R · Leeds, ALBuilt 1963 · S/N 17250565N2965XLynch Thomas L · Fort Collins, COBuilt 1967 · S/N 17700365N29664Tyree William B · Arlington, TXBuilt 1974 · S/N 17264119N29667Viles Timothy · Bartlett, TNBuilt 1968 · S/N 17701016N2966ACroffut David P · Anchorage, AKBuilt 1953 · S/N 30166N2966FNansen Peter D · Bellingham, WABuilt 1966 · S/N 18257066N2966KMichels LLC · Wasilla, AKBuilt 1980 · S/N 18053140N2966VBode Aviation Inc · Albuquerque, NMBuilt 1974 · S/N 15076336
Back to AD 97-01-13