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.

N17050Findlow Jerry E · Glasser, NJBuilt 1976 · S/N 17702498N17052Skypilot LLC DBA · Benbrook, TXBuilt 1976 · S/N 17702499N17059N79107 LLC · Orrville, OHBuilt 1982 · S/N R18201915N1705FTennis Gayland L · Bath, MIBuilt 1966 · S/N 17255100N1705RCox Brian Allen · Pasadena, CABuilt 1978 · S/N R18200525N1705VNiles Air LLC · Concord, NCBuilt 1974 · S/N 17263718N17060Jacobsen Lee E · Inchelium, WABuilt 1972 · S/N 15073612N17065Glaser Donald L Jr · Olive Branch, MSS/N 150-73615N17068Adamski Thomas R · Grantham, NHBuilt 1976 · S/N 17702501N17069Joyce Michael P · New Kent, VAS/N 15073619N1706MStocker Russell · Woodland, CABuilt 1970 · S/N 33701306N17077Shehl George William III · Charleston, WVBuilt 1972 · S/N 15073257N1707FFreije Anthony M · Anchorage, AKBuilt 1966 · S/N 17255102N1707QGarcia Jorge A · Ponce, PRBuilt 1971 · S/N 15073007N1708CHaggard Roy A · Murrieta, CABuilt 1953 · S/N 30408N1708FKnudsen Mark A · Whitmore Lake, MIBuilt 1966 · S/N 17255103N1708QJergovich Jack A · Austin, TXBuilt 1971 · S/N 15073008N1708RHall Alan D Trustee · Big Bear Lake, CABuilt 1974 · S/N 18502430N1708ZVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0008N17091Martin Stanley B · Lockhart, TXBuilt 1976 · S/N 17702502N17098Lake Michigan Asset Management LLC · Grand Rapids, MIBuilt 1972 · S/N 15073622N1709CDmj Holdings LLC · Kalispell, MTBuilt 1953 · S/N 30409N170ACBrett Price Excavating Inc · Rigby, IDS/N 18266551N170ATVan Anda Aviation LLC · Apopka, FLBuilt 1966 · S/N 17254850N170JSDocjosh Ltd LLC · Essex, NYBuilt 1962 · S/N 15059706N170KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 15079154N170SKNottingham John F · Covington, LABuilt 1979 · S/N 17273173N170SPSweatt Jeffrey · West Terre Haute, INBuilt 1981 · S/N 17275097N170SUTop Flight Consulting LLC · Fort Myers, FLBuilt 1979 · S/N 152-83248N17101Vasquez Juan E · Miami, FLBuilt 1972 · S/N 15073623N17102North Timothy · Milton, WVBuilt 1976 · S/N 17702503N17106Tate Daron D Trustee · Pasco, WABuilt 1972 · S/N 15073627N1710CSmith Peter R · Lewistown, MTBuilt 1953 · S/N 30410N1710FValley Aviators Inc · Williston, NDBuilt 1966 · S/N 17255105N1711CNorthern Flyway LLC · Anchorage, AKBuilt 1953 · S/N 30411N1711WBogaard Jeffery D · Kansas City, MOBuilt 1966 · S/N 18257108N1712CGrant Douglas E Jr · Chubbuck, IDBuilt 1953 · S/N 30412N1712QMischief Makers LLC · Tuscaloosa, ALBuilt 1971 · S/N 15073012N17132Harvey Laurence C · Lincoln, NEBuilt 1982 · S/N R18201921N17134Trappe Enterprises LLC · Street, MDBuilt 1972 · S/N 15073633N17136Ireland Brian T · Newberg, ORS/N 15073635N17137Miller Scott · Albia, IABuilt 1976 · S/N 17702506N1713MOne Zero Four LLC · Germantown, TNBuilt 1970 · S/N 33701313N1713QMaier Brandon · Eagle Grove, IABuilt 1971 · S/N 15073013N1713RNevada General Enterprises Ltd · Reno, NVBuilt 1978 · S/N R18200530N1713VGrasshopper Flying Club · Poughkeepsie, NYBuilt 1974 · S/N 17263721N17141Dawson Aircraft Inc · Clinton, ARBuilt 1972 · S/N 15073638N1714210ds Ltd · Centreville, VABuilt 1976 · S/N 17702507N17143Misner Gear K · Phoenix, AZBuilt 1972 · S/N 15073640N1714CMoreau Aviation LLC · Wasilla, AKS/N 30414
Back to AD 97-01-13