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.

N758DCSale Reported · Altoona, FLSale reportedBuilt 1972 · S/N 310Q0471N758PBas Part Sales LLC · Greeley, COBuilt 1999 · S/N TH-1907N758WPAcr Aircraft LLC · Dover, DEBuilt 1975 · S/N TH-666N7591DMidland Avionics LLC · Louisville, KYBuilt 1971 · S/N P-171N7593YEpic Aviation Leasing LLC · Puyallup, WABuilt 1965 · S/N 30-662N7596YRodgers Kevin M · Vacaville, CAS/N 30-665N759JSIsland 414 LLC · St Simons Island, GAS/N 414-0936N75BJTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 34-7570114N75CBEastmann Transport Services LLC · El Paso, TXBuilt 1975 · S/N 421B0861N75CLClear LLC · Pierre, SDBuilt 1977 · S/N TH-878N75GMMandes George J · Homer, AKBuilt 2010 · S/N 20800518N75HDMorton Michael E · Hickory, NCS/N 30-757N75KGKahn Karen M Trustee · Santa Barbara, CABuilt 1974 · S/N TC-1810N75LKN75lk LLC · Lafayette, LABuilt 1981 · S/N 31-8152173N75MJBatidas Maria Fernanda · Tucson, AZFirst renewal noticeS/N P-73N75NXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 33701660N75RVBas Part Sales LLC · Greeley, COS/N 34-7570188N75SKRick Broke Entertainment LLC · Conyers, GABuilt 1974 · S/N 421B0646N75TAPigott Michael · Brandon, MSBuilt 1976 · S/N TC-2001N75TTReisback Scott · Olalla, WAS/N 414A0405N7600QTwin D LLC · Lake City, FLBuilt 1973 · S/N 310Q0781N7600YSchell Joseph H · Granbury, TXBuilt 1964 · S/N 30-669N7601YMines Keith A · White Cloud, MIBuilt 1964 · S/N 30-671N7602QKbg Air LLC · Deerfield Beach, FLBuilt 1970 · S/N 310Q0102N7603CSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-230N7604YHennum Gretchen I · Eagle, COBuilt 1965 · S/N 30-675N7605YPlane Care LLC · Tucson, AZBuilt 1964 · S/N 30-676N7608DSmith Charles Gregory · Richlands, VABuilt 1972 · S/N P-188N7608YJohnson Craig · Moreland, GAS/N 30-679N7609CBergstrom Aircraft Inc · Pasco, WABuilt 1976 · S/N 34-7670097N7609YDowning Gregg R · Guymon, OKBuilt 1964 · S/N 30-680N760AAce Aircraft Leasing Inc · Nazareth, PABuilt 1979 · S/N ME-303N760CNSchumacher Charles · Cambridge, MABuilt 1976 · S/N TC-1929N760FSModi Yogini · Homestead, FLBuilt 1972 · S/N 34-7250213N760RMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1975 · S/N 414-0815N7610NHarrison Danny L · Byrdstown, TNBuilt 1968 · S/N TC-1137N7611YRandall Dean A · Reno, NVS/N 30-683N7614YSky Walker Flight School LLC · Adrian, MIBuilt 1964 · S/N 30-687N761DBOne Two Air LLC · Traverse City, MIBuilt 1978 · S/N 34-7970014N7622NWingswat LLC · Placentia, CABuilt 1968 · S/N TC-1140N7624QFhs Aero Co · Olathe, KSBuilt 1973 · S/N 421B0363N7626QSnap Roll Enterprises LLC · West Chester, OHBuilt 1970 · S/N 310Q0126N7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeS/N 30-700N7628YLamantia Mark V · Ebensburg, PABuilt 1964 · S/N 30-703N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214N762JTPurdue University · West Lafayette, INBuilt 1981 · S/N ME-432N762SASua 762sa Inc · Palm City, FLBuilt 1979 · S/N 31-7912042N762SUAlmost There Air LLC · Daytona Beach, FLBuilt 1977 · S/N 27-7754003N762TBAero Crafter LLC · Miami, FLBuilt 1977 · S/N 421C0213N7630YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-706
Back to AD 2004-25-16 R1