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.

N2980YLeisz Jeffrey A · Bloomington, INBuilt 1962 · S/N 18253980N2981ECox William Warren · Collierville, TNBuilt 1978 · S/N 17271394N2981KNiles Air LLC · Concord, NCBuilt 1980 · S/N 18053145N2981YBeebe Michael · Rangeley, MEBuilt 1962 · S/N 18253981N29821Jks Enterprises Inc · Park Rapids, MNBuilt 1972 · S/N 18261233N2982ASkywagon Pilots Inc · Santa Clara, CABuilt 1953 · S/N 30182N2982JTijman Esteban M · Potomac, MDBuilt 1966 · S/N 15065782N2982KHalcomb Billy J · Pond Creek, OKBuilt 1980 · S/N 18053146N2982SHerzog Daniel L · Clinton, MIS/N 15066882N2982XSale Reported · Lakeland, FLSale reported, canceledS/N 17700382N2983FHalle Michael P · Livingston, TXBuilt 1966 · S/N 18257083N2983XEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701365N2984CRosser Brian K · Minden, NVBuilt 1954 · S/N 30884N2984JBell Edward A · Richfield, OHBuilt 1966 · S/N 15065784N2984UJuris Ronald D · Bickleton, WABuilt 1966 · S/N 17255040N2984YRondeb Aircraft LLC · Wilmington, DEBuilt 1962 · S/N 18253984N2985CBraham John P · Fairbanks, AKBuilt 1954 · S/N 30885N2985JScott Jason Eton · Seattle, WABuilt 1966 · S/N 15065785N2985UConnersville Flying Club Inc · Connersville, INBuilt 1963 · S/N 17250585N2985XFrazier James R · Adamsville, TNBuilt 1967 · S/N 17700385N2985YJones Aviation Inc · Biggs, CABuilt 1962 · S/N 18253985N2986AMorris Blain E · Delta Junction, AKBuilt 1953 · S/N 30186N2986EYbarguen Johnny C · Rosenberg, TXBuilt 1982 · S/N 18268225N2986JWylam Thomas S · Ocala, FLBuilt 1966 · S/N 15065786N2986KSmith John F III · Middletown, DEBuilt 1980 · S/N 18053149N2986SHouglan Norman L · Shepherdsville, KYBuilt 1967 · S/N 15066886N2986ULuebke Austin D · Corsica, SDS/N 17250586N2987CYount Lawrence F · Shelton, WABuilt 1954 · S/N 30887N2987FRegistered aircraftBuilt 1966 · S/N 18257087N2987KSpielvogel Heinz · Charlestown, RIBuilt 1980 · S/N 18053150N2987UMott Charles A Jr · Chesapeake, VABuilt 1963 · S/N 17250587N2988FTaf Aerial Services LLC · Beeville, TXBuilt 1966 · S/N 18257088N2988JRegistration Pending · Asotin, WARegistration pendingBuilt 1966 · S/N 15065788N2988KMelvin Perry D · Warner Robins, GABuilt 1980 · S/N 18053151N2988UFrost Eddy L · Bishop, TXS/N 17250588N2988XDoyle Thomas P · San Diego, CABuilt 1968 · S/N 17700388N2989JWright Brandon C · Cave City, KYS/N 15065789N2989UGodinez Mauricio U · San Diego, CABuilt 1963 · S/N 17250589N2989XLabadie Enrique L · Tucson, AZBuilt 1967 · S/N 17700389N298GBSandhu Harpreet · Livermore, CABuilt 1977 · S/N 17268841N298JCNiemeijer Meindert · Coralville, IABuilt 1978 · S/N R18200740N298SMSmb Flyer LLC · Queen Creek, AZBuilt 1973 · S/N 18262327N298VBEdholm Joseph · Lino Lakes, MNBuilt 1959 · S/N 50364N2990ATottle K M DBA · Limington, MEBuilt 1953 · S/N 30190N2990CLyng Stephen G · Kenosha, WIBuilt 1954 · S/N 30890N2990JHale Randall C · Bloomburg, TXS/N 15065790N2990KGundersen Timothy A · Henderson, NVBuilt 1980 · S/N 18053153N2990SAndresen Paul S · Chandler, AZS/N 15066890N2990UShiny Pigeon LLC · Fort Worth, TXBuilt 1963 · S/N 17250590N2991FBerryessa Alan E · Cedarville, CABuilt 1966 · S/N 18257091
Back to AD 97-01-13