OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,536

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.

N117WWNowak Jerome S · Elmhurst, ILS/N 320D0096N1183GC A R Lease Corp · Brentwood, TNBuilt 1979 · S/N 31T-7920086N1187KLove Simplicity · Princeville, HIBuilt 1980 · S/N 318052175N1188YSkylark Flight Training LLC · Panama City, FLBuilt 1964 · S/N 30-403N1189PParks Eric · Matthews, NCBuilt 1955 · S/N 23-203N118ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496034N118BHBighorn Airways Inc · Sheridan, WYBuilt 1975 · S/N 340A0003N118BLEdge Aviation LLC · Hawthorne, FLBuilt 1965 · S/N 30-913N118CFChaudoin Stephen G Trustee · Raymond, NHBuilt 1978 · S/N TH-924N118HBTd Air LLC · Cromwell, CTBuilt 1980 · S/N 31T-8004052N118MCAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952161N118WCHalair Inc · Diablo, CABuilt 1979 · S/N 31T-8020020N1191DFas Holdings LLC · Osage Beach, MOBuilt 1986 · S/N TH-1506N1194XCantrell William Terry · Spring Hill, TNS/N 34-7570236N1197PPenley Steven A · Corinth, TXBuilt 1955 · S/N 23-212N119ACKidd Kevin A · Key West, FLBuilt 1972 · S/N TH-188N119SKKing Air 3au LLC · Wichita, KSS/N 414A0660N119TWCarter Flygare Inc · Sacramento, CABuilt 1974 · S/N TH-533N11BNAlpha 414a LLC · New Smyrna Beach, FLBuilt 1979 · S/N 414A0311N11ECBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1970 · S/N TH-128N11EVBonita Beech LLC · Bonita Springs, FLBuilt 1976 · S/N TH-748N11FVInternational Aor Service Inc Trustee · Carson City, NVBuilt 1982 · S/N T303-00133N11HRHf Aero LLC · Lusby, MDBuilt 1979 · S/N 34-7970233N11JARegistration Pending · Denison, TXRegistration pendingBuilt 1977 · S/N 340A0292N11KYKlad-Air LLC · Catlett, VABuilt 1966 · S/N 30-1181N11MPAtwill Brock · Paragould, ARBuilt 1972 · S/N 27-4821N11MTSpeedy Aviation LLC · Liberty, SCBuilt 1978 · S/N 27-7854064N11PYCuller John T · Arvada, COBuilt 1964 · S/N 30-533N11PZCentral Virginia Flyers LLC · Palmyra, VABuilt 1971 · S/N 27-4699N11QTAv8rs LLC · Sugar Valley, GABuilt 1968 · S/N 30-1780N11SBGrant Zachary J · Indianapolis, INBuilt 1976 · S/N 31-7612062N11SLJohnson Randy L · Pikeville, KYBuilt 1960 · S/N 310-0029N11SYRautiola Erik · Cresson, TXS/N TC-1468N11TDDuflo Spray Chemical Inc · Lowville, NYBuilt 1960 · S/N 27-271N11VNHilton Head Flyers LLC · Liberty, SCBuilt 1981 · S/N ME-416N11YNN3412w LLC · Lithia, FLS/N 34-8070059N11YPDanforth Equipment LLC · Leesburg, FLBuilt 1987 · S/N TH-1509N11YYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1967 · S/N 30-1573N1202BDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N TC1825N1202GTyler Brenda · Mountain Top, PABuilt 1974 · S/N 310Q1057N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649N1205GKnapp James Ross · Apex, NCBuilt 1974 · S/N 310Q1060N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N1206KOnuzo Chika N · Fayetteville, GAS/N 421C1804N1206NCapital Group Inc · Garden City, IDBuilt 1985 · S/N 421C1805N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223N120DUnited States Air Force Owner · Hanscom Afb, MABuilt 1972 · S/N 27-4799N120HAAstley Mark C · Wayne, NJBuilt 1977 · S/N 340A0295N120JDLamb Aviation LLC · Perris, CABuilt 1981 · S/N 31-8152179N120LPGramer Air IV LLC · Northville, MIBuilt 1977 · S/N 31-7812010
Back to AD 2004-25-16 R1