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.

N3282TCavu Aircraft Sales & Management Inc · Olyphant, PABuilt 1967 · S/N 17700582N3283DAllen Roger B · Gardnerville, NVBuilt 1955 · S/N 32081N3283LHill Suzanne L · Edmond, OKBuilt 1967 · S/N 17256183N3284DKornfield Edward A · Anchorage, AKBuilt 1955 · S/N 32082N3284LWill Clifford S · Grayson, GABuilt 1967 · S/N 17256184N3284MSonrise Aviation LLC · Portland, INS/N 310R1892N3284YMonnin Cass C · East Wenatchee, WAS/N 18254284N3285LDouglass Grant · Rockport, TXBuilt 1967 · S/N 17256185N3285SCastro Manny H · Tucson, AZBuilt 1964 · S/N 18255785N3285VAviate Navigate Communicate LLC · Dewey, AZBuilt 1977 · S/N R1722245N3286JJohnson David W · Biwabik, MNS/N 15065986N3286LEagle Eye Aviation LLC · Meridian, IDBuilt 1967 · S/N 17256186N3287EOff Course Aero Ventures LLC · Mechanicsville, VABuilt 1978 · S/N 17271492N3288DSmith James O · Montgomery, TXS/N 32086N3288JSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15065988N3288SEpple William E · Roggen, COBuilt 1964 · S/N 18255788N3288UVetch Rod F · Ranchester, WYBuilt 1963 · S/N 18254688N32897Mach Point Nine LLC · Phoenix, AZS/N 15065989N3289SDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 18255789N3289URutenbeck Terry L · Wiggins, COBuilt 1963 · S/N 18254689N3289YHasselbring Ted S · Nashville, TNBuilt 1962 · S/N 18254289N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401N328JKJk Aviation Venture LLC · Windermere, FLBuilt 2026 · S/N 208B5957N328LDuffield Brian · Eastvale, CABuilt 1973 · S/N 18262043N32909Zamarripa Hector · Brownsville, TXBuilt 1970 · S/N 18260423N3290FCline Mark A · Winston Salem, NCBuilt 1967 · S/N R172-0222N3290JFitzgerald Jacob J · Pullman, WABuilt 1966 · S/N 15065990N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493N3291LSun Baron · Arcadia, CABuilt 1967 · S/N 17256191N3291SRegistration Pending · Highland, ILRegistration pendingBuilt 1964 · S/N 18255791N3291ZMiller Andy D · Marana, AZBuilt 1973 · S/N 15075105N3292MHyannis Air Service Inc · Hyannis, MAS/N 402C0304N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592N3292UAnnecchini Frank C Jr · Overland Park, KSBuilt 1963 · S/N 18254692N3293DGuilliams Carl · Gilbert, AZBuilt 1955 · S/N 32091N3293YKiedinger John D · Burleson, TXS/N 18254293N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594N3294UWidener Christine A · Tucson, AZBuilt 1963 · S/N 18254694N3295JClonts Kim E · Knox City, TXS/N 15065995N3295YReid Brian M · Boise, IDS/N 18254295N3296SBeekman Steven J · Stephenson, MIBuilt 1964 · S/N 18255796N3296UBierer David E · Victor, MTBuilt 1963 · S/N 18254696N3296YBeckord Aaron P · Tacoma, WABuilt 1962 · S/N 18254296N3297LRaymond Patrick H · Jerseyville, ILBuilt 1967 · S/N 17256197N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597N3297YMust Dash Rides Flying Club LLC · Raleigh, NCBuilt 1962 · S/N 18254297N3298LThompson Edward E · Buxton, MEBuilt 1967 · S/N 17256198N3298SHolloway Cody L · Belle Plaine, KSBuilt 1964 · S/N 18255798N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495
Back to AD 97-01-13