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.

N31VRGlaze Roy J · Smyrna, TNBuilt 1976 · S/N 33701731N31YKJendair LLC · New York, NYBuilt 1973 · S/N 310Q0934N32009Ecliax LLC · Craig, AKBuilt 1987 · S/N 20800022N3200LRapid Imaging Solutions LLC · American Fork, UTBuilt 1965 · S/N 310J0200N32015Rock Solid Aviation LLC · Lake Charles, LABuilt 1974 · S/N 34-7570007N3209DCirrus 1jr LLC · Webster, NYBuilt 1994 · S/N TH-1735N320ARAir Sal Leasing Inc · Fort Myers, FLS/N 320E-0079N320AUAuburn University · Auburn, ALBuilt 2020 · S/N 4496496N320BTThomas Lance E Trustee · Mesa, AZBuilt 1965 · S/N 320C0048N320FWMurrell James F · Douglas, AZBuilt 1967 · S/N 320F-0018N320GCNordquist Mark O · Petaluma, CABuilt 1970 · S/N 39-60N320JBIce II Cody W · Houston, MOBuilt 1964 · S/N 320C0019N320JKTru-Point Tactical LLC · Columbia, MSBuilt 1966 · S/N 320E0048N320MRSic Direct Aviation Inc · Kingwood, TXBuilt 1969 · S/N 30-1917N320MSConsulat Inc · Cheyenne, WYBuilt 1966 · S/N 320E-0065N320RBLogan David J · Saint Helens, ORBuilt 1963 · S/N 27-2389N320RMRd Harrison Inc · Lexington, NCS/N 340A0939N320SKDevries James E · Bejou, MNBuilt 1967 · S/N 320E-0077N320SWEast West Investment Advisors LLC · Sandy Point, VABuilt 1980 · S/N 414A0451N320TTCarroll Richard J · Pocatello, IDBuilt 1966 · S/N 320E-0081N320VCDelta Three Air Services Inc · Burton, OHBuilt 1966 · S/N 320E-0016N320WDAt Liberty LLC · Apple Valley, MNBuilt 1974 · S/N TH-426N3211PJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1957 · S/N 23-1152N3211UHc LLC · Troy, ALS/N TH-1911N3216Ropp Dwight F · Pasco, WAS/N 30-796N3216MN3216m Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0826N321ACB & H Aviation LLC · Marion, KYBuilt 1974 · S/N 27-7405334N321BURegistration Pending · Tavares, FLRegistration pendingBuilt 1966 · S/N 310K0184N321CCMclaughlin Ralph B · Groveland, CAS/N 277304950N321CEMaroon Sky LLC · Navasota, TXBuilt 1981 · S/N 421C1225N321DDGreene Jonathan U · Pompano Beach, FLBuilt 1980 · S/N TJ-278N321FUTms Turboprop 2xl LLC · Wilmington, DES/N 31T-8166063N321HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 414-0625N321HASkytook LLC · Wilmington, DEBuilt 1973 · S/N 421B0420N321JHSkidmore Gary DBA · Terreton, IDBuilt 1978 · S/N 414A0063N321KBBecker Kevin P · Orange, CABuilt 1977 · S/N 33701782N321LBSpeer Transport LLC · El Cajon, CABuilt 1981 · S/N 31T-8166012N321NCArizona Air Salvage · Phoenix, AZBuilt 1977 · S/N 27-7754101N321RPIsrael Oscar M III · Sinton, TXBuilt 1973 · S/N 340-0201N321SJTmg Aircraft Holdings LLC · New Port Richey, FLBuilt 1977 · S/N 31-7752038N321WMMartinez Jose A · Orlando, FLBuilt 1975 · S/N TH-571N3227PTucker Patricia A · Hamilton, MTBuilt 1957 · S/N 23-1114N3229QHansen Ralph H Jr Trustee · Encinitas, CABuilt 1977 · S/N 34-7770222N322CCoffman Robert P · Bigfork, MTS/N 320C0073N322FCFuego Enterprises Inc · Atlanta, GABuilt 2003 · S/N 3449275N322RMPhillips George Thomas · Carson City, NVBuilt 1981 · S/N 414A0827N322SACimarron LLC · Kurten, TXBuilt 1985 · S/N TH-1488N322SMShivers James C II · Columbus, OHS/N 27-4417N3234LTarrant County College · Fort Worth, TXBuilt 1967 · S/N 27-3626N323APEm Concordia Inc · Brooklyn, NYS/N 31-8252031
Back to AD 2004-25-16 R1