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.

N1651ENoffsinger Robert L · Winston Salem, NCS/N 17271081N1651FMurphey Julian R · Knoxville, TNS/N 17255046N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686N1652TBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 414-0432N1652YWallitner Matthew M · Oroville, WABuilt 1962 · S/N 17249352N1653CLoveness Ghyrn E · Cave Creek, AZBuilt 1953 · S/N 30353N1653FN1653f LLC · Miami, FLBuilt 1966 · S/N 17255048N1653QDust Devil Weekend Warriors LLC · Ridgecrest, CAS/N 15072953N1653YBarua Dennis · Midland, TXS/N 17249353N1655CMardis Nicky Lee · Goddard, KSBuilt 1953 · S/N 30355N1655FRoughcreek Aviation LLC · Thomas, OKBuilt 1966 · S/N 17255050N1656CAnderson Thomas R · Seattle, WABuilt 1953 · S/N 30356N1656FParagon Aviation LLC · Reading, PAS/N 17255051N1656RBollenbacher Jeffery · Terre Haute, INBuilt 1978 · S/N R18200498N1656XAnderson George E · Newnan, GABuilt 1975 · S/N 21060691N1657CBrauchler Ben H · Hernando, MSBuilt 1953 · S/N 30357N1657EMcghee David L · Oklahoma City, OKBuilt 1978 · S/N 17271085N1657FZaleski James A · Bonsall, CABuilt 1966 · S/N 17255052N1657MPrecision Design Inc · Wilimington, DEBuilt 1975 · S/N 18264403N1657REnroute Direct LLC · Woodstock, GABuilt 1978 · S/N R18200499N1657YPegasus Aviation LLC · Rogersville, MOBuilt 1962 · S/N 17249357N1658AApplied Trails Research LLC · Staunton, VABuilt 1978 · S/N 18266315N1658EBrockwell Jesse A · Disputanta, VABuilt 1978 · S/N 17271086N1658FMondo Beyondo Thrill Squadron · Pasadena, CABuilt 1966 · S/N 17255053N1658QHis Kingdom Aviation · Nevada, TXS/N 15072958N1658URenfro Michael W · Bethel, AKBuilt 1974 · S/N 20700258N1658YYankee LLC · Casa Grande, AZBuilt 1962 · S/N 17249358N1659QFlying Wings Of Lousiana · Denham Springs, LABuilt 1971 · S/N 15072959N1659YCrosswhite Noel A · Cabool, MOBuilt 1962 · S/N 17249359N165AMitchell Flying Club Inc · Lees Summit, MOBuilt 1979 · S/N 18267062N165DBCloud 916 LLC · Dover, DEBuilt 1978 · S/N 18503624N165DFMarks James E · Valatie, NYBuilt 1967 · S/N 185-1267N165FCPocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15064575N165LADicairano Gerard J · Salisbury, MDBuilt 1967 · S/N 15066156N165NHExpert Aircraft Thinking & Restoration LLC · Wilmington, DEBuilt 1984 · S/N 18268382N165SASouth Aero Inc · Albuquerque, NMBuilt 1980 · S/N 404-0622N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875N1660BKanode William E · Delaware, OHS/N 17268123N1660QDulitz David E · Webster, SDS/N 15072960N1660VOdegaard Wings Inc · Kindred, NDBuilt 1974 · S/N 17263705N1661FSharp Gary · Rigby, IDS/N 17255056N1661MTurbo Tech Investments LLC · Montrose, COBuilt 1975 · S/N 18264406N1661RStrong Mitchell · Batavia, NYS/N R18200502N1661YRegistration Pending · Cowpens, SCRegistration pendingBuilt 1962 · S/N 17249361N1662RGray Jerry B · Valdez, AKBuilt 1974 · S/N 18502385N1663FSixtree Foxy Blue LLC · Renton, WABuilt 1966 · S/N 17255058N1663QJohnson Steven · Cheyenne, WYBuilt 1971 · S/N 15072963N1663RSmith Dan V · Anchorage, AKBuilt 1974 · S/N 18502386N1664FGrace Christopher L · Mooresville, NCBuilt 1966 · S/N 17255059N1664QWithrow Steven D · Lubbock, TXBuilt 1971 · S/N 15072964
Back to AD 97-01-13