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.

N3873BNpa Baron LLC · Gladewater, TXBuilt 1981 · S/N TH-1255N3874YDavenport Henry B III · Charles Town, WVBuilt 1981 · S/N TH-1256N38750Mike Mcfadden Enterprises Inc · Laurel, MDBuilt 1977 · S/N 34-7770336N38760Davis Robby E · Plant City, FLBuilt 1969 · S/N 30-1999N38768Ovajet Group Inc · Miami, FLBuilt 1977 · S/N 34-7770085N3885GRichland Aviation Inc · Sidney, MTBuilt 1976 · S/N 340A0220N388LBSdgair LLC · Port Orange, FLBuilt 1964 · S/N 30-511N388METrinity Aviation Group LLC · Hudson Oaks, TXBuilt 1955 · S/N 23-322N388SPWeber Donald E · Saint David, AZS/N 340-0337N389ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 2089N389WAOlsen Donald Jr · Silverdale, WABuilt 1966 · S/N 337-0389N38AFAir 1st Aviation Companies Inc · Aiken, SCS/N 348233001N38CEBrad Keener Dds Pa · Harrison, ARBuilt 1971 · S/N TH-116N38CMSale Reported · Fay-Aux-LogesSale reportedBuilt 1979 · S/N 340A0901N38DZWoolard Flying Service Inc · Corning, ARBuilt 1990 · S/N TH-1577N38FE239 Lear LLC · Dover, DES/N 340-0096N38FJAty Aviation Inc · Watertown, SDBuilt 1989 · S/N 4495009N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829N38KCChanney Aviation Group LLC · Las Vegas, NVBuilt 1983 · S/N 31-8352033N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960N38MCGulf Air Aviation · Wilmington, DES/N 31-7405476N38NHendrix Stuart Brent Trustee · Atascadero, CABuilt 1973 · S/N P-220N38NTYorkavitz James B · Valley City, OHBuilt 1980 · S/N TJ-270N38RCharliefoxtrot LLC · Farmington, MOBuilt 1973 · S/N TC-1541N38TLBonanza 1 LLC · Hernando, MSBuilt 1991 · S/N TH1642N38TWPlanemarketing LLC · Vero Beach, FLS/N 31T-8104008N3908CMccreery Aviation Co Inc · Mcallen, TXBuilt 1976 · S/N 421C0136N3908XDeutsch Chad A · Evansdale, IAS/N 34-7570308N3909XSmith Aero Inc · Huntington Beach, CABuilt 1975 · S/N 34-7670001N390ASOcala Aviation Services Inc · Ocala, FLS/N 27-3117N390JDSevern Aeronautics Ltd · Annapolis, MDBuilt 1978 · S/N 31T-7820061N390JPLucky7 Air LLC · Lenoir, NCBuilt 1981 · S/N 31T-8166027N390UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496025N390WWalter Paul F · Milwaukee, WIBuilt 1970 · S/N 39-39N3911GGunderson Mark H · Reno, NVS/N 340A0230N3912GAllen Byron · Friendswood, TXS/N 340A0231N391MGHagedorn Aviation Inc · Columbus, OHBuilt 1975 · S/N 27-7554131N391SAndrews Patrick D · Neosho, MOBuilt 1970 · S/N TC-1095N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145N3922CN3922c LLC · Dover, DEBuilt 1977 · S/N 421C0419N3923CSwope Aviation LLC · Elizabethtown, KYBuilt 1976 · S/N 421C0147N3926GSellman Richard L · Missoula, MTS/N 340A0236N3929CWest Candace F · Helena, MTBuilt 1969 · S/N 27-4049N392ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 2092N3930XWilson Martin E · Arlee, MTBuilt 1975 · S/N 34-7570317N3936GBaker George G · Junction City, ORBuilt 1976 · S/N 340A0237N3938GHaverlock Aircraft LLC · Richmond Heights, OHS/N 340A0239N39393International Air Services Inc Trustee · Carson City, NVS/N 3449485N393FBRegistered aircraftBuilt 2002 · S/N TH-2026N393MPDutch Indian Air LLC · Riverdale, CABuilt 1976 · S/N 421C0203
Back to AD 2004-25-16 R1