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.

N2694CCranford Billy J · Wasilla, AKBuilt 1971 · S/N 33701378N2694HRockingham Carriage Services Inc · Greenland, NHS/N 4140493N2694QMiller William A Jr · Okeechobee, FLBuilt 1966 · S/N 18257894N2694SMock Joseph R · Huntsville, TXS/N 337-0994N2695GBackcountry Guys LLC · Prescott, AZBuilt 1959 · S/N 51995N2695LHindberg Jacob W · Fisher, MNBuilt 1967 · S/N 17255895N2695QKirbco Aviation LLC · Doniphan, MOS/N 18257895N2695RAccardo Paul A · Zwolle, LABuilt 1967 · S/N 18258395N2696CUnited States Air Force · Peterson Afb, COBuilt 1978 · S/N R18200218N2696HSunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 340A0778N2696LPark Rapids Avionics Inc · Park Rapids, MNBuilt 1967 · S/N 17255896N2696PBlue Wing Aviation LLC · Tulsa, OKBuilt 1979 · S/N 340A0779N2696QKlauber Gerald · Lake City, FLBuilt 1966 · S/N 18257896N2696UBlack Dragon Consulting LLC · Phoenix, AZS/N 340A0780N2696YD'Anna Michael Joseph · Durango, COBuilt 1962 · S/N 18051196N2697JSalem Aero Club Inc · Bridgeton, NJBuilt 1966 · S/N 15065697N2697KPrince John C III · Frierson, LABuilt 1979 · S/N 18053038N2697RMaring Matthew D · Westley, CAS/N 18258397N2697UOharra Robert J · Buckley, WAS/N 17250297N2698GPeterson Floyd M · Lago Vista, TXBuilt 1959 · S/N 51998N2698JKruglov Stephan · Mundelein, ILBuilt 1966 · S/N 15065698N2698QButler John L · Omak, WABuilt 1966 · S/N 18257898N2698RWeishaupt Louis R · Mackinaw, ILBuilt 1967 · S/N 18258398N2699DN2699d Corp Trustee · Wilmington, DEBuilt 1979 · S/N 340A0787N2699FRegistration Pending · Jonesboro, ARRegistration pendingBuilt 1966 · S/N 18256799N2699L98x LLC · Caddo Mills, TXBuilt 1967 · S/N 17255899N2699UHogue Richard L · Dos Palos, CAS/N 17250299N2699XAir Controls Billings Inc · Billings, MTBuilt 1966 · S/N P206-0199N269BJN2893e LLC · Reno, NVS/N 17270380N269CGold Beach Lumber Yard Inc · Brookings, ORS/N 421C0170N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512N269FAir2615 LLC · Wilmington, DEBuilt 1968 · S/N 421-0177N269NEOro LLC · Tilden, NES/N 17272505N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546N269PCSch Aviation Inc Trustee · SporleBuilt 1979 · S/N 340A0785N269RDHumphries Aviation LLC · Maysville, KYS/N 17252737N269TDGrant Aviation Inc · Anchorage, AKBuilt 2008 · S/N 208B2069N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104N26AWAntique Aircraft And Automobile LLC · Van Alstyne, TXS/N 32544N26BFBasco James Millard M · Richlands, NCS/N 28295N26CARogers Patricia A · Albany, ORBuilt 1979 · S/N 15283794N26CFKustatan Leasing LLC · Nikiski, AKBuilt 1975 · S/N 20700306N26CRSim International Inc · Fort Mill, SCBuilt 1973 · S/N 21060084N26CUAnselmo Jeffery A · Fairfield, CABuilt 1986 · S/N U20606984N26CWBarzelatto Brett · Thornton, COS/N 17272496N26DLHayden David Bernard Trustee · Roach, MOBuilt 1973 · S/N 18502287N26EFMischel Herbert · Las Vegas, NVS/N 15282800N26FCRwr Air Inc · Tok, AKBuilt 1974 · S/N U20602541N26FPTate Zachary W · Cypress, TXBuilt 1978 · S/N 17271318N26FSRenwick Andrew J · Senoia, GABuilt 1960 · S/N 17799
Back to AD 97-01-13