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.

N2583JLauff Samuel Jr · Ocala, FLBuilt 1964 · S/N 15061083N2583LMontgomery Robert A · Hampstead, NCBuilt 1967 · S/N 17255783N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250N2583UUfly Vi LLC · St Thomas, VIBuilt 1963 · S/N 17250183N2584JVolar LLC · Forest, MSBuilt 1965 · S/N 15061084N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005N2584URedd David C · Blanding, UTBuilt 1963 · S/N 17250184N25852Griffith Aviation Inc · Griffith, INBuilt 1977 · S/N 15280817N25855Williams Stephen W · Granbury, TXBuilt 1977 · S/N 15280820N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885N2585LAerospace Quality LLC · Piggott, ARS/N 17255785N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285N2585ULionudakis Michael A · Scotts Valley, CABuilt 1963 · S/N 17250185N25860Sorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 15280825N2586JHenegar Nathanie L · Owasso, OKFirst renewal noticeBuilt 1964 · S/N 15061086N2586LRuiz Edinson · Bakersfield, CABuilt 1967 · S/N 17255786N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786N2586SCasey Aviation Inc · Mansfield, MAS/N 17252809N2586UMaynor Roy · Brazoria, TXS/N 17250186N2587SFlying Tater LLC · Toms River, NJBuilt 1968 · S/N 337-0887N2587UEt Flight LLC · Cedar Park, TXBuilt 1963 · S/N 17250187N2588JShannon Noah Chad · Lawrenceburg, TNBuilt 1964 · S/N 15061088N2588RPoplin Tristan · Frisco, TXBuilt 1967 · S/N 18258288N2588ZBindon Philip E · Wasilla, AKBuilt 1963 · S/N 185-0588N25890Henry Mark A · Dickinson, TXS/N 15280837N25899Ace Aircraft Leasing Inc · Nazareth, PABuilt 1977 · S/N 15280842N2589GPreisse Gene L Jr · Akron, OHBuilt 1959 · S/N 51889N2589QMolek Eugene · Warren, OHS/N 18257789N2589YOrtner Airport LLC · Wakeman, OHBuilt 1962 · S/N 17249889N258BWEastern Kentucky University · Richmond, KYBuilt 1981 · S/N 17274811N258ERLewis Carlos Brandon · Indian Mound, TNBuilt 1978 · S/N 17270891N258KCBredesen Benjamin C · Nashville, TNBuilt 1978 · S/N 177RG1304N258MAJ Linn Aviation Inc · Quinlan, TXS/N 17269926N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336N258RAReynolds Darryl G · Wills Point, TXBuilt 1978 · S/N 17270533N259Clark Jack E Jr · Mesa, AZFirst renewal noticeBuilt 1975 · S/N P337-0220N25907Bishop Kenneth P · Griffin, GABuilt 1977 · S/N 15280849N2590KHilltop Aviation Group LLC · Jay, MEBuilt 1978 · S/N 18053006N2590RMason John A · Scottsdale, AZBuilt 1967 · S/N 18258290N25914Aces High Aviation LLC · Long Beach, CABuilt 1977 · S/N 15280854N25918Wichita Area Technical College · Wichita, KSBuilt 1977 · S/N 15280857N2591JNagel Larry A · Hurricane, UTBuilt 1965 · S/N 15061091N2591LHettenbach Paul A · Carrollton, TXBuilt 1967 · S/N 17255791N2591QDeadmond Matthew J · Princeton, CABuilt 1966 · S/N 18257791N2591TFerguson John W · Edwardsburg, MIBuilt 1975 · S/N U20602594N2591VLivewire Holdings LLC · Salinas, CABuilt 1974 · S/N 177RG0627N25922Byrd-Pettit Caroline A · Smithfield, NCS/N 15280859N2592GLeft Heading LLC · Herriman, UTBuilt 1959 · S/N 51892N2592JParker Alan K · Lenoir, NCBuilt 1964 · S/N 15061092
Back to AD 97-01-13