OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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-01-R1')
    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-01-R1')
  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.

N820HGGeorgia Aviation Authority · Eastman, GABuilt 2004 · S/N 2844114N820JKEkins Sean A · Mesa, AZBuilt 1973 · S/N 28R-7335334N820PJGoetzman Chad Joseph · North Myrtle Beach, SCBuilt 1972 · S/N 28R-7235021N820TOneil John M · Leicester, NCFirst renewal noticeBuilt 1959 · S/N 24-1102N8210PJohnson James E · Calhoun, LABuilt 1963 · S/N 24-3463N8211YMccoy Darren T · Caledonia, MIBuilt 1966 · S/N 30-1338N8212CPumpkin Seed Aviation LLC · Wilmington, DEBuilt 1975 · S/N 34-7670120N8212PTweeddale Thomas Allan · Denton, TXBuilt 1963 · S/N 24-3465N8213YBoomer Joshua G · Floyds Knobs, INBuilt 1966 · S/N 30-1340N8215PAme LLC · Kalispell, MTBuilt 1963 · S/N 24-3468N8215YGlassburn Teresa L · Winthrop, WAS/N 30-1343N8216YMedia Stew LLC · Carson City, NVS/N 30-1344N8217PDanilchuk Phillip A · Auburn, GAS/N 24-3470N8217YMaledy John Trustee · Salem, MOBuilt 1966 · S/N 30-1345N8219YDurden Julian F Jr · Twin City, GABuilt 1966 · S/N 30-1347N8220PParsell Scott · Katy, TXBuilt 1963 · S/N 24-3473N8221PMoreau Donald G · Dayton, TXBuilt 1963 · S/N 24-3474N8221TPhinney Hartley · Gallatin, TNS/N 34-8070227N8221YBill Kennedy Aviation LLC · Stuart, FLBuilt 1966 · S/N 30-1349N8222ACarr Paul W · Plano, TXBuilt 1980 · S/N 34-8070230N8222BCordero Jose Robert · El Paso, TXBuilt 1980 · S/N 34-8070231N8222PWeirich Joseph J · South Milwaukee, WIBuilt 1963 · S/N 24-3475N8223CCurless Timothy A · Demotte, INBuilt 1975 · S/N 28R-7635134N8224YWoodard Earl G Jr · Danville, GABuilt 1966 · S/N 30-1353N8226YC P L Air LLC · Middletown, DEBuilt 1966 · S/N 30-1356N8228JJerome George A · West Hills, CABuilt 1980 · S/N 34-8070252N8228QMahaffey & Gore Pc · Oklahoma City, OKBuilt 1980 · S/N 34-8070253N822JSN822js LLC · Norcross, GABuilt 1973 · S/N 28R-7335425N82306Wiseman Anamarie C · Orlando, FLBuilt 1980 · S/N 34-8070257N8234YBurkey Jeffrey C · Stuart, FLBuilt 1966 · S/N 30-1360N8235PZiesman Ernest D · Henderson, NVBuilt 1963 · S/N 24-3488N8235YLyons Kenneth L · Port Neches, TXS/N 30-1361N8236PLeary Patrick W · Lewistown, MTBuilt 1963 · S/N 24-3490N8237PNarveson Kristian · Pueblo West, COBuilt 1963 · S/N 24-3491N8238FVip Jets Net LLC · Miami, FLBuilt 1976 · S/N 34-7770081N8239P3so II LLC · Louisville, KYBuilt 1963 · S/N 24-3493N8239YMurray Coy L · Guntersville, ALBuilt 1966 · S/N 30-1365N8241PRegistered aircraftBuilt 1963 · S/N 24-3495N8242PLake Donald T · Green Valley, AZFirst renewal noticeBuilt 1963 · S/N 24-3496N8243PMountain Mooney Inc · Idaho Falls, IDS/N 24-3497N8243YHampton Brent · Edgewood, TXBuilt 1966 · S/N 30-1369N8244YDow Jeff · Port Hadlock, WABuilt 1965 · S/N 30-917N8246YVon Gruben Steven E · Bonita Springs, FLBuilt 1967 · S/N 30-1372N8247PEldredge Michael J · Modesto, CABuilt 1963 · S/N 24-3501N8248PArmstrong Kristian Trustee · Airville, PABuilt 1963 · S/N 24-3502N8249POgan Steve G · Pierre, SDBuilt 1963 · S/N 24-3503N8250DCasavannah Aviation LLC · Clearwater, FLBuilt 1980 · S/N 34-8070330N8250PSedberry Jason A · Kokomo, INS/N 24-2563N8250YStoltz Kevin · Locust Grove, GABuilt 1966 · S/N 30-1376N8251PDefranco Ross A · Los Angeles, CABuilt 1963 · S/N 24-3505
Back to AD 97-01-01 R1