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.

N2261CGandy John W III · Mt Vernon, TXBuilt 1953 · S/N 30561N2261YKemper Dennis R · Carmichael, CABuilt 1967 · S/N 17700061N22628Lemko Dennis A · Fresno, CABuilt 1968 · S/N 15068412N2262TMarsh John E · Washington, DCBuilt 1968 · S/N 185-1420N2262XStampfler Richard D · Groveland, MABuilt 1965 · S/N 337-0162N2262YRegistered aircraftBuilt 1967 · S/N 17700062N22638Lindorfer John H · Long Beach, MSBuilt 1976 · S/N 15078567N2263CWalker William S · Shallotte, NCBuilt 1953 · S/N 30563N2263JJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15065463N2263TUnited States Air Force · Dover Afb, DEBuilt 1977 · S/N R18200014N2263YMejia Mauricio · South Gate, CABuilt 1967 · S/N 17700063N22645Martinez Emilio · Fairburn, GABuilt 1968 · S/N 15068424N22648Eagles Wings Flight Training · Clintonville, WVBuilt 1968 · S/N 15068425N2264GMessner Mark R · Chesapeake, OHBuilt 1958 · S/N 51564N2264JRegistered aircraftAssigned, pending cancellationS/N 15065464N22656Berry Frank C · Watkinsville, GAS/N 15068431N2265GWilder James S · Eagle, IDBuilt 1958 · S/N 51565N2265YHemann Dale F · Osage, IABuilt 1967 · S/N 17700065N22662Rogers Gary A · Novi, MIBuilt 1968 · S/N 15068433N22663Auger Allan Dean · Conifer, COBuilt 1968 · S/N 15068434N22667Firkus Lloyd Jason · Plover, WIBuilt 1968 · S/N 15068437N2266JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15065466N2266XBarney Julius C · Lutz, FLBuilt 1965 · S/N 337-0166N22673Merry Robert J · Lynnwood, WAFirst renewal noticeBuilt 1968 · S/N 15068440N22676Burgess Barton C · Leesburg, OHBuilt 1968 · S/N 15068442N22677Barlow Rod · Kaysville, UTBuilt 1968 · S/N 15068443N2267TAeropod Inc · Aurora, COS/N 185-1427N2267XRound Engine Aero · Nashville, MIBuilt 1965 · S/N 337-0167N2267YCole Gary L · Richmond, TXBuilt 1967 · S/N 17700067N22680Turpen Andrew B · San Andreas, CAS/N 15068444N22682Bianchi Brandon J · Castroville, CABuilt 1968 · S/N 15068446N22689Ridge View Aviation LLC · Napanoch, NYBuilt 1974 · S/N 17264073N2268CCozach LLC · Wilmington, DEBuilt 1982 · S/N T30300081N2268JKing Larry W · Port St John, FLBuilt 1966 · S/N 15065468N2268SPlatinum Air Services LLC · Morgantown, WVS/N R18201317N22692Hoang Ethan Tai Huu · Metairie, LAS/N 15068452N226ACTitle 46 LLC · Hamilton, MTBuilt 1979 · S/N 18267019N226BBurton Robert B · New York, NYBuilt 1977 · S/N 21061701N226CAChoice Aviation LLC · Hamilton, MTBuilt 1976 · S/N 17266762N226DMFewel Lance E · Lake Oswego, ORBuilt 1976 · S/N 177RG0929N226HPRegistration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N 414A0084N226JAXin Han Aviation LLC · Atwater, CABuilt 1976 · S/N 17266688N226JTTerrell Jeffrey L · Clear Lake Shores, TXBuilt 1969 · S/N 18259919N226WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 0476N226WTFegert Jeffery · Las Vegas, NVS/N R18201735N22702Ryan Good Aviation LLC · Sioux Falls, SDBuilt 1968 · S/N 15068459N22706Sego James G · Sequim, WABuilt 1968 · S/N 15068461N22708Arispe Aviation LLC · Mckinney, TXBuilt 1968 · S/N 15068462N22709Riggin Flight Service Inc · Madison, SDS/N 15068463N2270JFeland Wade · Antler, NDBuilt 1966 · S/N 15065470
Back to AD 97-01-13