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.

N25ZZ25zz LLC · Abilene, TXS/N 18267202N2600FZorrilla Peter · Charles Town, WVS/N 18256700N2600GBad Company Aviation LLC · Peachtree Corners, GABuilt 1959 · S/N 51900N2600LN2600l LLC · Pageland, SCBuilt 1967 · S/N 17255800N2600QBivens Jason D · Duncan, OKBuilt 1966 · S/N 18257800N2600ROrlandella Vito P · Auberry, CABuilt 1967 · S/N 18258300N2600YCurrin Thomas E · Pendleton, ORBuilt 1962 · S/N 18051100N2601FFly3h4 LLC · Hillsboro, NDBuilt 1965 · S/N 18256701N2601LCobb William J · Cincinnatus, NYBuilt 1967 · S/N 17255801N2601UK D Helicopters Inc · Shingleton, MIBuilt 1963 · S/N 17250201N2602GConran Joshua · Belmont, MIBuilt 1959 · S/N 51902N2602RSiegel Jeffrey P · Snowmass Village, COS/N 18258302N2602UVan Zee Charles C · Rancho Cucamonga, CABuilt 1963 · S/N 17250202N2603Intentus Aviation LLC · Sunset, TXS/N 32957N2603FHolloway Graham · Orcutt, CABuilt 1965 · S/N 18256703N2603KPadilla Management Inc · Burlington, WABuilt 1978 · S/N 18053013N2603LMagel David J · Lakemoor, ILBuilt 1967 · S/N 17255803N2603RHopper Jeremy G · Amity, ORS/N 18258303N2604GBlessing Christopher B · Houston, DEBuilt 1959 · S/N 51904N2604SGillespie Dan L · Discovery Bay, CABuilt 1968 · S/N 337-0904N2604UTalboy Theodore Neal · Lathrop, CABuilt 1963 · S/N 17250204N2604YLawson Charles A · Arlington, WABuilt 1962 · S/N 18051104N2605FRose Walter W · Arena, WIBuilt 1965 · S/N 18256705N2605GInnes Stephen L · Bentonville, ARBuilt 1959 · S/N 51905N2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CABuilt 1966 · S/N 18257806N2607GJensen Rodney · Aptos, CABuilt 1959 · S/N 51907N2607SHunter Gary A · Fort Wayne, INBuilt 1976 · S/N 21061338N2607ZSidney Aviation LLC · Sidney, NEBuilt 1963 · S/N 185-0607N2608JDriftless Aero LLC · Montfort, WIBuilt 1966 · S/N 15065608N2608QMiller David C · Burlington, CTBuilt 1966 · S/N 18257808N2608RRegistered aircraftBuilt 1967 · S/N 18258308N2609GRegistration Pending · Grove City, PARegistration pendingS/N 15077218N2609LHavertown Flyers LLC · Havertown, PABuilt 1967 · S/N 17255809N2609QDawson Arden H III · Eagle Nest, NMBuilt 1966 · S/N 18257809N2609YHelvey Michael H · Sheridan, WYBuilt 1962 · S/N 18051109N260DFMatchbox Holdings LLC · Harrisonburg, VABuilt 1975 · S/N 18264479N260PTPeterson Todd · El Dorado, KSBuilt 1977 · S/N 18265612N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004N260TGPickerel Enterprises LLC · Bennet, NES/N 18267521N2610GBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 402C0064N2610JTrotzke Samuel P · North Pole, AKBuilt 1966 · S/N 15065610N2610SGordon Daryl B · Bellevue, WABuilt 1968 · S/N 337-0910N2611FMccall Aviation LLC · Union Springs, ALBuilt 1965 · S/N 18256711N2611XHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0072N2612QLabarre Ben A · Hayward, WIS/N 18257812N2612SNixon Edward J · Collierville, TNS/N 337-0912N2612UNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17250212N2613FHowe Justin · Encampment, WYBuilt 1965 · S/N 18256713N2613JKoontz Jeffrey T · Phoenix, AZBuilt 1966 · S/N 15065613N2613LOzark Aviators Inc · Willow Springs, MOBuilt 1967 · S/N 17255813
Back to AD 97-01-13