OpenAirDocs.org
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.

N11946Solari Michael R · Gilroy, CABuilt 1974 · S/N 15075724N1194MGadamic LLC · Fresno, CABuilt 1969 · S/N 17258694N1194QKirkpatrick Jason · Mosca, COBuilt 1975 · S/N U20602864N11950Plenkers Russell A · Molino, FLBuilt 1975 · S/N 17702382N11952Jones William Edward · Scottsdale, AZBuilt 1974 · S/N 15075730N11953Sanchez Chayanne R · Apex, NCBuilt 1974 · S/N 15075731N11957Kopecky Dawn D · Center, NDBuilt 1974 · S/N 15075735N11959Quyser Adil · Edison, NJBuilt 1974 · S/N 15075737N1195MBrown Alan J · Cheyenne, WYBuilt 1975 · S/N 18264240N1195UMatonti James R · Oklahoma City, OKBuilt 1976 · S/N 17266896N11962Aeroleasing Inc · Medford, ORBuilt 1974 · S/N 15075740N11968Good Guys Finish First Inc · Colorado Springs, COS/N 17702383N1196DAerobat Aoa LLC · Wilmington, DES/N A1520764N1196USwaff Properties LLC · Humble, TXBuilt 1976 · S/N 17266897N1196YYork Aero Club Inc · York, SCBuilt 1962 · S/N 15059596N11970Kiforishin Samuel · Westfield, MAS/N 15075748N11971Registration Pending · Durham, NCRegistration pendingBuilt 1974 · S/N 15075749N11974Yilmaz Enes A · Austin, TXBuilt 1974 · S/N 15075752N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763N1197MSholer Jon R · Battle Ground, WABuilt 1975 · S/N 18264241N1197UP D H S Aerial Photography Inc · St Petersburg, FLBuilt 1976 · S/N 17266898N1197VVentry Solutions Inc · Hauser, IDBuilt 1976 · S/N R1722137N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698N11995Russell Ricky · Montrose, ARS/N 18263974N119DCDuque Helen · Orlando, FLS/N 17267722N119DHJohnson Peter L · Chico, CAS/N 36257N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N119FRJeffery & Weiss Holdings LLC · Long Beach, CAS/N 17276535N119JLMayo Clive S · Palmetto Bay, FLBuilt 1973 · S/N 18262575N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121N119P4dw Interests LLC · Longview, TXS/N 17263873N119PARicciardi Brian P · Hyannis, MAS/N 402B0610N119RFRandigo LLC · Wilmington, DEBuilt 2002 · S/N 208B0929N119RKHtv Music Co · Franklin, TNBuilt 1972 · S/N 18261574N119SKKing Air 3au LLC · Wichita, KSS/N 414A0660N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235N119XUSale Reported · VentabrenSale reportedBuilt 1973 · S/N 0008N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11BNAlpha 414a LLC · New Smyrna Beach, FLBuilt 1979 · S/N 414A0311N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N11DHRegistered aircraftBuilt 1978 · S/N 18052974N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245N11FJPetit Chris J · Marrero, LABuilt 1961 · S/N 18253252N11FNScheck Christopher R · Troutdale, ORBuilt 1973 · S/N 15074423N11FRMosley John E · Jackson, MSBuilt 1971 · S/N 18260761N11FVInternational Aor Service Inc Trustee · Carson City, NVBuilt 1982 · S/N T303-00133N11GSHuddleston Edward · Oaktown, INBuilt 1976 · S/N 15078597
Back to AD 97-01-13