OpenAirDocs.org
AD 97-05-03 R1

Registered aircraft · 2,861

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-05-03-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-05-03-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.

N28CKC Star Aviation LLC · Evansville, INBuilt 1997 · S/N 525-0210N28FDPacific Air Center LLC · Long Beach, CABuilt 2014 · S/N 525-0822N28LALv Air LLC · Lompoc, CABuilt 1980 · S/N 550-0200N28QAHuff Air LLC · Uvalde, TXBuilt 1997 · S/N 5250215N28RKRd Aviation Lp · Redlands, CABuilt 1995 · S/N 525-0111N290CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 090N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317N2923CColley Robert E · Jamestown, TNBuilt 1955 · S/N D-310N2927VHereth Eric W · El Cajon, CAS/N D-311N2929VEllis Donald D W · High Springs, FLBuilt 1947 · S/N D-313N292MEN292me LLC · Englewood, COBuilt 1980 · S/N 292N294CWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 525-0114N294RTSouthland Equipment Services LLC · Cottondale, ALBuilt 1995 · S/N 560-0264N295CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 295N295DS4f Managment LLC · Salem, ORBuilt 1994 · S/N 525-0091N295MLCorning Companies LLC · Billings, MTBuilt 2019 · S/N 525-1043N2975VBuckalew James E · Kingsville, TXBuilt 1947 · S/N D-371N2976VDolby Kevin L · El Paso, TXBuilt 1947 · S/N D-372N2979VZxtair LLC · Mankato, MNBuilt 1947 · S/N D-376N2983VBellgardt Robert · North Bend, WABuilt 1947 · S/N D-380N2987BKrog Donald C · Somerville, NJBuilt 1953 · S/N D-3625N2989VContessa Holdings Ltd · Cheyenne, WYS/N D-386N298CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 298N298WB45 Srl Inc · Houston, TXBuilt 2000 · S/N 258476N2991VParsons Franklin R Jr Trustee · Kiowa, COS/N D-389N2992VSheridan Jeffrey S · Lakeville, MNBuilt 1947 · S/N D-390N2994VJetmx Inc · Goodyear, AZS/N D-392N2997VMcmahon Jeffrey J · Paris, KYBuilt 1947 · S/N D-396N299FLAircraft Solutions LLC · Fredonia, WIS/N 435N299PRMeregrass Inc · Dublin, TXBuilt 2000 · S/N 299N299RKGasser LLC · Midland, TXBuilt 2002 · S/N 550-1027N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343N29CLJordan Air LLC · Fort Smith, ARBuilt 1984 · S/N 404N29LNLucky29 Liquors LLC · Loveland, COS/N 389N29QCN560wp LLC · Portland, ORBuilt 2004 · S/N 560-0675N2GQ6 Echo November LLC · Murfreesboro, TNBuilt 1981 · S/N 550-0286N2RCRico Marketing Corp · Flint, MIBuilt 1995 · S/N 5600319N2TWJuliett Papa LLC · Kalispell, MTBuilt 1994 · S/N 560-0286N2ZBCitizen Aero Inc Trustee · Sheridan, WYBuilt 2021 · S/N 525-1101N3001VHillier David C · Oakdale, CABuilt 1947 · S/N D-400N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487N300BVCj Bravo Victor LLC · Ridgeland, MSBuilt 2001 · S/N 525-0418N300CHWorldwide Option LLC · Lewes, DEBuilt 1990 · S/N 560-0080N300CQHawker 4 LLC · Jensen Beach, FLBuilt 2001 · S/N 258555N300FCDresden Aviation LLC · Atlanta, GABuilt 1998 · S/N 525-0248N300GCN300gc LLC · Los Angeles, CABuilt 1981 · S/N 550-0311N300TCOrlando Financial Corp · Bear, DEBuilt 1978 · S/N 241N300WBGarmin International Inc · Olathe, KSBuilt 1994 · S/N 5600271N300XL1911 Partners LLC · Rockledge, FLBuilt 1979 · S/N 276N3013VCusick Christopher J · La Jolla, CABuilt 1947 · S/N D-415
Back to AD 97-05-03 R1