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.

N88PEFirst Winds LLC · Norfolk, NES/N 421C0851N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112N88RNInternational Air Services Inc Trustee · Carson City, NVS/N 310J-0077N88SHSmith Jeary K · Greenfield, INBuilt 1973 · S/N 27-7304930N88TGMakushin Logistics LLC · Fairbanks, AKBuilt 1984 · S/N 31-8452020N88TLAh Legacy LLC · Orlando, FLBuilt 1980 · S/N 31-8152066N88TWWheel-Air LLC · Mentor, OHBuilt 1998 · S/N 20800292N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609N88VFMillennial Aviation LLC · Chatsworth, CAS/N 34-8233171N88WWQwest Aviation LLC · Edwardsburg, MIBuilt 1971 · S/N 39-125N88ZMFlorida Aero Services Sales Division Inc · Brandon, FLBuilt 1976 · S/N 31-7752016N8903YBall Half Out LLC · Mesa, AZBuilt 1970 · S/N 39-58N8904ZBuess Wayne R · Shirley, NYBuilt 1961 · S/N 310G0004N8906YRegistered aircraftBuilt 1970 · S/N 39-61N8906ZGrismer Jeff Trustee · Hemet, CABuilt 1961 · S/N 310G0006N8907MWarden Richard L · Canby, ORBuilt 1963 · S/N TC-541N8908ZLevin Robert G · Roseburg, ORBuilt 1961 · S/N 310G0008N8909ZSumthin Limited · Wilmington, DEBuilt 1961 · S/N 310G-0009N890GRFly Compton Aeronautical Education Foundation · Compton, CAS/N 310H0130N890HMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052194N890NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496603N8910ZRazorhawk LLC · Birmingham, ALBuilt 1961 · S/N 310G0010N8911UBerry John O · Dexter, NMFirst renewal noticeBuilt 1965 · S/N TC-947N8911ZSt Francis Aircraft LLC · Montrose, COBuilt 1961 · S/N 310G0011N8914YHarris William M · Christiansburg, VABuilt 1970 · S/N 39-71N8917YHigh Flyers Inc · Jackson, TNBuilt 1970 · S/N 39-76N891CBKal-1 LLC · Wichita, KSBuilt 1980 · S/N 31-8012064N891NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496555N891SGSouthern Aircraft LLC · Valdosta, GABuilt 1975 · S/N 34-7570311N8923ZPanting Edwin A · Anchorage, AKBuilt 1962 · S/N 310G-0023N8924UPan American Handling LLC · Mooresville, NCBuilt 1965 · S/N TC-949N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925TSuslavich Frank · Ennis, MTBuilt 1984 · S/N 348433007N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8927ZEast Texas Aircraft Engines LLC · Palestine, TXBuilt 1962 · S/N 310G-0027N8928ZSwanson Garret C · Valentine, NEBuilt 1962 · S/N 310G0028N892MMWings Of Dubuque LLC · Dubuque, IABuilt 1980 · S/N 31-8112029N892NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496556N892PMcburney: Associates LLC · Lakeway, TXBuilt 1976 · S/N TC1947N892TGTeo Steel Inc · Ramer, TNBuilt 1980 · S/N 31-8012053N892TWTeo Steel Inc · Ramer, TNBuilt 1978 · S/N 31-7812111N8932ZMclynn Matthew J · Green Valley, AZBuilt 1962 · S/N 310G-0032N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N8934ZJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1962 · S/N 310G-0034N8938YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1971 · S/N 39-99N8939MCyrier John · Lockhart, TXBuilt 1964 · S/N TC-551N8939ZJenkins John C · Chocowinity, NCBuilt 1962 · S/N 310G-0039N893CBAec Navajo LLC · Wilmington, DES/N 31-8012007N893NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496505N893TCCaravan Air Inc · Livingston, MTBuilt 2014 · S/N 20800565
Back to AD 2004-25-16 R1