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.

N3217UWelkin Aero Inc · Garden Plain, KSBuilt 1975 · S/N 18502738N3217YBrowne Robin P · Dallas, TXBuilt 1962 · S/N 18254217N3218DWright James Cope · Round Rock, TXBuilt 1955 · S/N 32016N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918N3218KSteinhausen Darrell · Torrington, WYBuilt 1967 · S/N 15065356N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518N3218URadford Tara Lynn · Elmira Heights, NYBuilt 1963 · S/N 18254618N3218YCollins Marcus E Jr · Camilla, GABuilt 1962 · S/N 18254218N3219LBlock Taylor I · Sibley, IAS/N 17256119N3219SYogodzinkski Steve M · Amberson, PAS/N 18255719N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353N321AYCameron Kari L · Ashland, ORBuilt 1973 · S/N 18261756N321BABering Air Inc · Nome, AKBuilt 2020 · S/N 208B5613N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792N321BMMacintosh William J · Simpsonville, SCBuilt 1966 · S/N 17254361N321BSBrown Gregory N Trustee · Flagstaff, AZBuilt 1978 · S/N 18266765N321CEGreen Eggs And Ham Aero LLC · Helena, MTBuilt 1981 · S/N 421C1225N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061N321DGAdkison Edy P · Riverside, CABuilt 1969 · S/N 21059201N321DWJsj LLC · Wilmington, DEBuilt 1979 · S/N 310R1823N321EEVermont Skydiving Adventures Inc · Addison, VTBuilt 1956 · S/N 33582N321HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 414-0625N321HASkytook LLC · Wilmington, DEBuilt 1973 · S/N 421B0420N321HXGggg LLC · Hilton Head Island, SCBuilt 1981 · S/N 425-0104N321JHSkidmore Gary DBA · Terreton, IDBuilt 1978 · S/N 414A0063N321JPAzure Skyes Holdings LLC · Poulsbo, WABuilt 1980 · S/N 18504166N321KBBecker Kevin P · Orange, CABuilt 1977 · S/N 33701782N321KKPanoche Aviation Co LLC · Fresno, CABuilt 1979 · S/N 18267488N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853N321MMJohnson Curtis A · St Paul, MNBuilt 1979 · S/N 18503976N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202N321PPMathews Aviation LLC · Marysville, CABuilt 1977 · S/N 18265834N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438N321RBMessmore Micheal Henry · Toledo, WABuilt 1976 · S/N 18052677N321RPIsrael Oscar M III · Sinton, TXBuilt 1973 · S/N 340-0201N321RZRieger Joseph M · Ashland, ORBuilt 1979 · S/N 18267199N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807N321TXMartin James K · Kingsville, TXBuilt 1967 · S/N 15067252N321WHBonanza Equipment Leasing LLC · Missoula, MTBuilt 1979 · S/N 18266927N3220YTanner Fred E · Westville, FLS/N 18254327N3221SPropwash LLC · Mesquite, NVBuilt 1964 · S/N 18255721N3221VDevaney Aviation Inc · Palm City, FLBuilt 1974 · S/N 15076426N3221YRegistration Pending · Brea, CARegistration pendingS/N 18254221N3222DBeggs Patrick C · Salem, ORBuilt 1955 · S/N 32020N3222LLanier James A · Phillipsburg, KSBuilt 1967 · S/N 17256122N3222YCreighton Andrew M · Lebanon, TNBuilt 1962 · S/N 18254222N3223DCliff Robinson Real Estate Corp · Madison, INBuilt 1955 · S/N 32021N3223JPoulin Philip N · Washington, VTBuilt 1966 · S/N 15065923N3223LBerube Leo Reginald · Easley, SCBuilt 1967 · S/N 17256123N3223UPerry Joseph R · Portland, ORBuilt 1963 · S/N 18254623
Back to AD 97-01-13