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.

N1948BKc Aviation LLC · Conway, ARBuilt 1974 · S/N 177RG0564N1948FKdrd Holdings LLC · Texas City, TXBuilt 1979 · S/N 17273038N1948QHorsley Luther J · Midland, ORS/N 177RG0348N1948XGreenwood Auto LLC · Itta Bena, MSBuilt 1965 · S/N 18256048N194961w1 Aero LLC · Issaquah, WABuilt 1973 · S/N 15074450N1949PEast Bay Trading Co LLC · Fairview, PABuilt 1973 · S/N 17262835N194ARTarpley Richard · Cleveland, GABuilt 1978 · S/N 17272029N194SESamnik Enterprises LLC · Naples, MEBuilt 1972 · S/N 17260386N194SMSurveying And Mapping LLC · Austin, TXBuilt 2019 · S/N 208B5546N19501Beardsley Larry N · Leavittsburg, OHBuilt 1976 · S/N 17702574N19506Colvard Tony D · Newland, NCS/N 15074457N19508Andelt David L · Parker, COBuilt 1973 · S/N 15074459N1950FAce Of Spades Aviation LLC · Las Vegas, NVS/N 17273040N1950QSherwood Jeffrey Curtis · Cranston, RIBuilt 1973 · S/N 177RG0350N1950U3 Stones Productions LLC · Anchorage, AKBuilt 1970 · S/N 18501659N1950VJenson Kenneth E · Modesto, CABuilt 1980 · S/N 182-67632N1950ZStafford Branson T · Maple Hill, NCS/N 15059750N19514N&C Enterprises LLC · Vine Grove, KYS/N 15074461N19516Choppin Dale · Sun City, AZBuilt 1973 · S/N 15074462N19519Gulf Niner LLC · Eagan, MNBuilt 1976 · S/N 17702575N1951TBachmann Jochen W · Hudson, OHBuilt 1980 · S/N 185-04134N1951XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1965 · S/N 18256051N1951ZAnderson Zachery D · Bigfork, MTBuilt 1962 · S/N 15059751N19520Ag Avventures LLC · Hartford, WIS/N 15074465N19522Cannan Aviation Inc · Georgetown, TXS/N 15074467N19523Frana Joel A DBA · Fort Myers, FLBuilt 1973 · S/N 15074468N19524Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 15074469N19526Soebagyo Vincent · Hollywood, CABuilt 1973 · S/N 15074471N1952MLatimore Company LLC · Snohomish, WABuilt 1975 · S/N 33701665N19531Archer Collins Etheridge · Fairview, TXBuilt 1973 · S/N 15074476N19534Smith Paul C Sr · Winthrop, MES/N 15074479N1953CHanafi Robert A · Wellton, AZBuilt 1953 · S/N 30502N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306N1953ZHigginbotham Laura · Woodbine, GABuilt 1962 · S/N 15059753N1954LSmith Cody · Fairbanks, AKBuilt 1966 · S/N U2060751N1954MBecker Verne L · Manhattan Beach, CABuilt 1976 · S/N 18264500N1954SBarca Sky F · Simi Valley, CABuilt 1974 · S/N 17702197N1954UAircraft Structural Repair Inc · Hamilton, MTBuilt 1970 · S/N 18501665N1954VBray Aviation LLC · Calera, OKBuilt 1974 · S/N 17263803N1954XStull David H · Sausalito, CABuilt 1965 · S/N 18256054N19550Cheap Flight Time LLC · Athens, GAFirst renewal noticeBuilt 1973 · S/N 15074480N19558Moon Jonathan E · Butler, PABuilt 1973 · S/N 15074485N1955VJd Kracl Aircraft LLC · Gretna, NEBuilt 1974 · S/N 17263804N19564Priewe Jeff C · Como, MSBuilt 1973 · S/N 15074489N19568June Richard · Stevenson Ranch, CABuilt 1973 · S/N 15074492N1956FPenzo Michael A · Stafford, VABuilt 1979 · S/N 17273046N1956JAdamson George R · Calhan, COBuilt 1956 · S/N 32571N1957Registered aircraftBuilt 1977 · S/N 17269009N19572Borzoya Aero Group Inc · Slatington, PABuilt 1973 · S/N 15074496N19575Galis Iuri · Oklahoma City, OKBuilt 1976 · S/N 17702577
Back to AD 97-01-13