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.

N7953PLahiff Patrick R · Michigan City, INS/N 24-3190N7954JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7635125N7954YBrausch Jon D · Huron, OHBuilt 1966 · S/N 30-1050N7955PStockton Chemical Inc · Wallis, TXBuilt 1962 · S/N 24-3192N7956PAdventist World Aviation · Wilson, NCS/N 24-3193N7957PMcleod Joseph M · Carthage, NCBuilt 1962 · S/N 24-3194N7958YAl Banna Emad R · Huntingtown, MDBuilt 1966 · S/N 30-1054N795JBMountain High LLC · Ketchum, IDBuilt 1969 · S/N 24-4894N7962PMills Thomas E · Tuolumne, CABuilt 1962 · S/N 24-3199N7962YMay Anthony E · Stacyville, IABuilt 1966 · S/N 30-1060N7963PWhitaker Joel D · Sagle, IDBuilt 1962 · S/N 24-3200N7965PLucius William Christopher · Henderson, NVBuilt 1962 · S/N 24-3202N7966YAlbano Alan T · Elbert, COS/N 30-1064N7967YDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 30-1065N7968PDavison William A · Hamilton, MTBuilt 1962 · S/N 24-3205N7968YMustang Aeronautics LLC · Chandler, AZS/N 30-1066N7970PStevens Jon A · Byron, MNBuilt 1962 · S/N 24-3207N7971YRegistration Pending · Collierville, TNRegistration pendingS/N 30-1070N7974YHughes Frank H · Hackberry, LABuilt 1966 · S/N 30-1073N7975PB&R Aircraft LLC · Wadsworth, OHBuilt 1962 · S/N 24-3212N7977SMelkuti Attila J · Carlsbad, CAS/N 24-2547N7977YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1076N7978PKozak Aeronautical Company · Wilmington, DEBuilt 1962 · S/N 24-3215N7978YBurnett Philip B · Lamar, ARBuilt 1966 · S/N 30-1077N7979PSanders Bill H · Wichita, KSBuilt 1962 · S/N 24-3216N797MTJib Inc · Groton, CTBuilt 1978 · S/N 34-7870433N7980PLibby Michael F · Frazier Park, CABuilt 1962 · S/N 24-3217N7980YCherry Michael A · Winchester, ILBuilt 1966 · S/N 30-1080N7982PSylverne Edward F · Mount Airy, MDBuilt 1962 · S/N 24-3220N7983YMclaughlin Scott A · Defiance, IABuilt 1966 · S/N 30-1085N7984PMiller Jason Christopher · Woodbury, NJBuilt 1962 · S/N 24-3222N7985PScarpelli Kenneth R · Wichita, KSS/N 24-3223N7986YRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1966 · S/N 30-1089N7988YLevel Up Aviation LLC · Dothan, ALBuilt 1966 · S/N 30-1092N7989PAllen Rodney · Englewood, COBuilt 1962 · S/N 24-3227N7992PEngler William O · Filion, MIBuilt 1962 · S/N 24-3231N7993PMartz Todd B · Pleasant Hill, CABuilt 1962 · S/N 24-3232N7994PLetourneau University · Longview, TXS/N 24-3235N7996PFredrick Bruce T · Barrigada, GUS/N 24-3237N7997PGilbert Aviation LLC · Mendon, VTBuilt 1962 · S/N 24-3238N7997YN7997y Inc · Miami, FLBuilt 1966 · S/N 30-1102N7998YAirjohn LLC · Cheyenne, WYBuilt 1966 · S/N 30-1103N7999PAtair LLC · San Diego, CABuilt 1962 · S/N 24-3072N79BACampbell Allen · Marietta, PAS/N 30-1842N79GBurke Robert · Pierre, SDBuilt 1964 · S/N 30-362N79RGLouisne Gonzales · East Windsor, NJBuilt 1966 · S/N 24-4399N79VM3 Itg Aviation LLC · Allentown, NJBuilt 1969 · S/N 28R-35230N7EYCharnwood Aviation Inc Trustee · Wilmington, DEBuilt 1964 · S/N 30571N7FPBrooks David · Forney, TXBuilt 1959 · S/N 24-1160N7HTJohns Aviation LLC · Dawson, GABuilt 1967 · S/N 30-1643
Back to AD 97-01-01 R1