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.

N25271Byrnes Daniel P · Anchorage, AKS/N 15280564N2527GRafter H Livestock · Rawlins, WYBuilt 1959 · S/N 51827N2527JHunt Wayne A · Delta Junction, AKBuilt 1964 · S/N 15061027N2527LWooten Craig J · Campobello, SCS/N 17255727N2527QTwenty Inc · Wilmington, DES/N 18257727N2527SCensair LLC · Santa Fe, NMBuilt 1967 · S/N 337-0827N2527YSuazo Tito L · Glendale, AZBuilt 1962 · S/N 17249827N25284Riverside Flight Center Inc · Tulsa, OKBuilt 1977 · S/N 15280572N25286Recreational Enterprises LLC · Sanford, FLS/N 15280573N2528JMichael Matthew C · Ames, IAS/N 15061028N2528LWings Of Faith · Stevensville, MTBuilt 1966 · S/N 17255728N2528RHutchens Robert L II · Mocksville, NCBuilt 1967 · S/N 18258228N2528YHock Adam · Ankeny, IABuilt 1962 · S/N 17249828N2529JSale Reported · Geneva, OHSale reportedBuilt 1964 · S/N 15061029N2529UCampbell Alto L III · Pike Road, ALBuilt 1963 · S/N 17250129N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635N252GSWyoming Seaplanes LLC · Alpine, WYBuilt 1976 · S/N 18265179N252HPFino Al Cielo LLC · Jacksonville, FLBuilt 1983 · S/N 18268320N252JMMccallister Billy G · Virginia Beach, VABuilt 1963 · S/N 17250277N252KCPatton Steven W · Fayetteville, ARS/N 30964N252MTAero Quest LLC · Olive Branch, MSBuilt 1977 · S/N 15280407N252RAReynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17269911N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984N252SBRoberts Christopher E · Anchorage, AKS/N 17270764N252WCMosier Paul L · Ventura, CABuilt 1979 · S/N 15284145N25301Southern Arkansas University Technical Branch · Camden, ARBuilt 1977 · S/N 15280581N25302Steiner Jason A · Sabetha, KSBuilt 1977 · S/N 15280582N2530GRegistered aircraftBuilt 1959 · S/N 51830N2530KInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 18052972N2530LSholes Lance M · Oregon City, ORBuilt 1966 · S/N 17255730N2530RHines David L · Lancaster, CABuilt 1967 · S/N 18258230N2530VAnderson Jeffrey L · Harrisburg, SDBuilt 1974 · S/N 177RG0604N2530YHarbour William T Jr · Mobile, ALBuilt 1962 · S/N 17249830N2531JCrowder Jr Thomas E · Whitesburg, GABuilt 1964 · S/N 15061031N2531LAiken Justin M · Arden, NCS/N 17255731N2531QRegistered aircraftBuilt 1968 · S/N 185-1373N25325Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280596N2532GWilliams Mark E Trustee · Reno, NVBuilt 1959 · S/N 51832N2532JDel Mar College District · Corpus Christi, TXBuilt 1964 · S/N 15061032N2532RDelong Erika Dee · Forest Lake, MNBuilt 1967 · S/N 18258232N2532SGrant Roderick M · Dillingham, AKBuilt 1973 · S/N 18502246N2532UMills Randall J · Monroe, MIBuilt 1963 · S/N 17250132N2532YBatie Gregory T · Rogers, ARBuilt 1962 · S/N 17249832N2532ZWest Charles A · Independence, ORBuilt 1962 · S/N 185-0532N25332Ewing John L Jr · Yuma, AZBuilt 1977 · S/N 15280600N2533QBusse Alana · Thousand Oaks, CABuilt 1966 · S/N 18257733N2533RAdams Michael B · Scottsdale, AZBuilt 1967 · S/N 18258233N2533VHasselvander Brian K · Columbia, MSBuilt 1974 · S/N 177RG0605N2534RRobuck Dale J · Knoxville, IABuilt 1967 · S/N 18258234
Back to AD 97-01-13