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.

N2328YRogue Air LLC · Miller, SDBuilt 1967 · S/N 17700128N23290Walker Jeffrey · Warwick, NYBuilt 1968 · S/N 15068852N23291Oracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264083N23295Cook Erik C · Redmond, ORBuilt 1968 · S/N 15068855N23299King Keith L · Lexington Park, MDBuilt 1968 · S/N 15068858N2329EMeshoppen Air LLC · Meshoppen, PABuilt 1978 · S/N 17271235N2329FFlorida Aeronautical Survey Technologies · Fort Lauderdale, FLBuilt 2011 · S/N 208B2312N2329GRegistration Pending · Eagle River, AKRegistration pendingBuilt 1959 · S/N 51629N2329RRivers Andrew · Midland Park, NJS/N 18255429N232BTHnw Aviation LLC · Melbourne, ARBuilt 1965 · S/N 15061302N232CBLight Air Development LLC · Helena, MTBuilt 1976 · S/N 177RG0998N232DTChancellor Shares LLC · Liberal, KSBuilt 1979 · S/N 414A0232N232LSElliott Arthur M · Portland, TXBuilt 1971 · S/N 17260131N232MTAir Force Life Cycle Management Center · Lexington, MABuilt 1981 · S/N U20606200N232RSWright Aviation LLC · Lawton, OKBuilt 1974 · S/N 310Q1145N233Stone Scott Robert · New Waverly, TXBuilt 1968 · S/N 15068882N23302Adams John C · Gladstone, MOBuilt 1968 · S/N 15068860N23303Chuzy Suzy LLC · Lafayette, LABuilt 1968 · S/N 15068861N23304Gendy Shady S · Columbia, PABuilt 1968 · S/N 15068862N23305Fuhrmann Brandon R · Aberdeen, SDBuilt 1968 · S/N 15068863N23308Hotel Bravo Aviation LLC · Sumrall, MSBuilt 1968 · S/N 15068864N2330EManhattan Flying Tigers Inc · Bozeman, MTBuilt 1978 · S/N 17271236N2330GEmshwiller Mark E · Camp Verde, AZBuilt 1958 · S/N 51630N2330JWilliamsburg Air Service Inc · Kingstree, SCBuilt 1979 · S/N T18803455TN2330XKeller Ronald B · Bosque Farms, NMBuilt 1965 · S/N 18256230N23311Sweeney Daniel W · Broad Brook, CTBuilt 1968 · S/N 15068866N2331FReeves Thomas W · Issaquah, WABuilt 1964 · S/N 21058531N2331GSouth Bay Aviation Inc · Torrance, CAS/N 51631N2331RSawicki Michael T · Midland, MIBuilt 1964 · S/N 18255431N2331SMiller Randy L · Enid, OKS/N 337-0631N23322Lopez William Alberto · Miami, FLBuilt 1968 · S/N 15068873N23323Boccaccio Peter Anthony · Burke, SDBuilt 1968 · S/N 15068874N23324Walden James F · Willcox, AZBuilt 1968 · S/N 15068875N23328Scmitt Rudy · Brookshire, TXBuilt 1968 · S/N 15068876N23329Welles Richard V · Elmira, NYBuilt 1968 · S/N 15068877N2332CBalgoyen James T · Charlotte, MIBuilt 1954 · S/N 30632N2332EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271238N2332SLouisiana Military Museum · Abbeville, LAS/N 337-0632N2332YAlbi Aero LLC · Denver, COBuilt 1967 · S/N 17700132N23330N23330 LLC · Bedford, PABuilt 1968 · S/N 15068878N23333Leading Edge Aviation LLC · Lewiston, IDBuilt 1968 · S/N 15068880N23337Mosquito LLC · Chesaning, MIBuilt 1968 · S/N 15068883N2333CAfs Inc · Grants Pass, ORBuilt 1978 · S/N R18200152N2333GRegistration Pending · Belen, NMRegistration pendingS/N 51633N2333KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N U20603676N2333XHjr Aviation LLC · Reno, NVBuilt 1965 · S/N 18256233N2333YSkillman Flying Services LLC · Brookshire, TXS/N 17700133N23344Hmh Consolidated LLC · Lake Placid, FLBuilt 1968 · S/N 15068888N23348Noel Tom W · Galloway, OHBuilt 1968 · S/N 15068890N23349Fairwinds Aviation LLC · Goldsboro, NCBuilt 1968 · S/N 15068891
Back to AD 97-01-13