OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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.

N341TVWild Hare Enterprises LLC · Valparaiso, INBuilt 1981 · S/N 340A1277N34201Talon Air LLC · Newport, KYS/N 34-7450185N3420PKeyuravong Pisonth · Anchorage, AKBuilt 1958 · S/N 23-1384N342GRSouthern Aero LLC · Homestead, FLBuilt 1972 · S/N 34-7250021N342RCHyland'S Pharmacy LLC · Wheeler, TXBuilt 1982 · S/N 421C-1243N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396N3434PNasair LLC · Flower Mound, TXBuilt 1958 · S/N 23-1401N3437QJamerson Kendall L · Bovina, TXBuilt 1966 · S/N 320E0037N343HPMonada Air Inc Trustee · Wilmington, DEBuilt 2003 · S/N 3449281N343RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N TC-1553N3442POttmann Robert · Indialantic, FLBuilt 1958 · S/N 23-1410N3444QKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320E0044N3447PSimonovich Sheldon K · Fredericksburg, VABuilt 1958 · S/N 23-1418N3448PDabney Richard W · Tanner, ALBuilt 1958 · S/N 23-1419N344BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 4496582N344JSWhitewing Aviation LLC · Tuscola, TXBuilt 1979 · S/N 340A0781N344MCEuroaviation Inc · KematenBuilt 1973 · S/N 34-7450008N344RCHome Perfection General Contractors Inc · Pelham, ALBuilt 1984 · S/N TH-1412N344SRegistered aircraftBuilt 1972 · S/N TH-210N344TBScifers John W · Sarasota, FLS/N 34-7770181N344TCInternational Air Services Inc Trustee · Carson City, NVS/N 421C0424N3450SBoyes Robert Louis · Benton City, MOBuilt 1969 · S/N TC-1264N3452QGolden Arrow Transportation Co · Plainfield, NJBuilt 1966 · S/N 320E-0052N34549Octans Aviation Co · Watertown, SDS/N TK-62N3456PBels Holdings LLC · Albert Lea, MNBuilt 1958 · S/N 23-1428N3456QL & J Aviation Inc · Atwater, CABuilt 1971 · S/N 340-0004N3457PSewade Dawn M · New River, AZBuilt 1958 · S/N 23-1429N3458QIngram John · Los Angeles, CABuilt 1966 · S/N 320E-0058N345ACManagement Co LLC · West Columbia, SCBuilt 1977 · S/N 34-7870087N345BKMckenzie Michael C · Ventura, CABuilt 1976 · S/N 340A0113N345CDP&N Corp · Marion, IAS/N 34-7770148N345CGHargis James L · Tioga, TXBuilt 1984 · S/N TJ-468N345FAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1979 · S/N 44-7995326N345JGGo Fly Inc · Spring Hill, FLBuilt 1959 · S/N 23-1825N345PGN345pg LLC · Chicago, ILBuilt 2001 · S/N TH-2016N345YWImpact Real Estate Group LLC · Casper, WYBuilt 1969 · S/N P-85N3468PHilligoss Forrest R · Brownsburg, INBuilt 1958 · S/N 23-1442N346DWValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 340A0742N346FSRichard C Reed · Snyder, TXS/N 340A0790N346MCSkyway Aviation LLC · Purvis, MSS/N 340A-0425N3474QLyle Timothy · Lakewood Ranch, FLFirst renewal noticeBuilt 1966 · S/N 320E-0074N3475PEdixon James Richard II · Cameron Park, CABuilt 1958 · S/N 23-1449N3478QCsc Aviation LLC · Parker, COS/N 320E-0078N3479VInternational Air Services Inc Trustee · Carson City, NVS/N T30300273N347JADepete Joseph G · Louisville, KYBuilt 1978 · S/N 340A0448N3489QPlane Progress LLC · Waterloo, IABuilt 1967 · S/N 320E-0089N348GGFlplanes 21 Of Miami LLC · Miami, FLBuilt 1980 · S/N 31-8052054N3491QOuter Marker Inc · Sandy, UTS/N 320E-0091N3492QLadet William D · Las Vegas, NVS/N 320E-0092N3494AWheeler Michael R · Peculiar, MOBuilt 1962 · S/N 27-2197
Back to AD 2004-25-16 R1