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.

N2442GRegistration Pending · King Salmon, AKRegistration pendingBuilt 1959 · S/N 51742N2442JOlson Lanny R · Huron, SDS/N 15065542N2442LPratt Mark R · La Grande, ORBuilt 1966 · S/N 17255642N2443LOdlozil Henry W · Ennis, TXBuilt 1966 · S/N 17255643N2443QHolcomb Aviation LLC · Middleton, IDS/N 18257643N2443RYoung David E · Wasilla, AKBuilt 1964 · S/N 18255543N2443SGill Robert S · Prudhoe Bay, AKFirst renewal noticeBuilt 1967 · S/N 337-0743N2443UIntream Companies LLC · Perryville, MOBuilt 1963 · S/N 17250043N2444GDurbin Brian · Lone Tree, COBuilt 1959 · S/N 51744N2444QBristow Christopher W · Fairfield, TXBuilt 1966 · S/N 18257644N2444RClancy Michael · Rifle, COBuilt 1964 · S/N 18255544N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344N2444YConrad Matthew J · Dardenne Prairie, MOBuilt 1962 · S/N 17249744N2445UPeachey Jason J · Milroy, PABuilt 1963 · S/N 17250045N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345N2445YNew England Aircraft Detailing LLC · Webster, MAS/N 17249745N2446CGolike Timothy R · Anchorage, AKBuilt 1954 · S/N 30746N2446GAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 51746N2446YMcmickle Edward R · Riverside, CAS/N 17249746N24472Payne Richard L · Flint Hill, VABuilt 1977 · S/N 15280272N2447CLevya Kevin S · Wilbur, WAS/N 30747N2447GTroyer Thomas · Chickamauga, GABuilt 1959 · S/N 51747N2447QEaton James B · Green Bank, NJBuilt 1966 · S/N 18257647N2447UMccauley Stephen M · Buckley, WAS/N 17250047N2447YNeu Aviation LLC · Benton, LABuilt 1962 · S/N 17249747N24486Wilson Seth · Shafter, CABuilt 1977 · S/N 15280283N2448EPwc Engine Air Inc · Manorville, NYS/N 17271288N2448FFlynn Charles P · Anchorage, AKBuilt 1965 · S/N 18051648N2448QEuroaviation Inc Trustee · KematenS/N 18257648N2448XBlough Robert M · Hoonah, AKBuilt 1965 · S/N 18256348N2448YTennison William T · Osprey, FLBuilt 1962 · S/N 17249748N24498Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280290N2449FBoccuti Salvatore A · Ambler, PABuilt 1966 · S/N 18051650N2449GDimzoff Justin W · Hines, ORFirst renewal noticeBuilt 1959 · S/N 51749N2449JSkydance Northwestern Inc · Minden, NVBuilt 1982 · S/N 18504364N2449LSteier Tim · Salome, AZBuilt 1966 · S/N 17255649N2449QAcme Aircraft Co III LLC · Arvada, COBuilt 1966 · S/N 18257649N2449UCurl Eric A · Olympia, WABuilt 1963 · S/N 17250049N244DAPrairie Winds Aviation LLC · Overland Park, KSBuilt 1972 · S/N 17261294N244DBAnsari Ramin · West Lafayette, INBuilt 1976 · S/N 18265043N244FRSmith Larry · Ulysses, KSBuilt 1978 · S/N 17270490N244HEDubin David A · Tucson, AZS/N 21058990N244RPMitchell N Andrew · Bridgeport, CTBuilt 1973 · S/N 182-62311N244RTAircraftwings LLC · Las Piedras, PRS/N 17261037N244SPToth Douglas F · Scottsdale, AZBuilt 1963 · S/N 205-0379N24501Dsr Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 15280292N2450GMathieson Erik L · Kapowsin, WABuilt 1959 · S/N 51750N2450LRobinson Brandon J · Winona Lake, INS/N 17255650N2450QSherry Mark A · Walla Walla, WABuilt 1966 · S/N 18257650N2450XBackcountry LLC · Ennis, MTBuilt 1965 · S/N 18256350
Back to AD 97-01-13