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.

N99HJMf Property Management LLC · Hattiesburg, MSBuilt 1978 · S/N 414A0041N99JCHerold Edward E · Santa Cruz, CABuilt 1975 · S/N TC-1801N99JZUnadventurous LLC · Amarillo, TXBuilt 1984 · S/N TJ-474N99LFLake Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1261N99MDJinkins Richard D · Rewey, WIBuilt 1955 · S/N 23-325N99PAMckelvey Jeffrey R · Dadeville, ALBuilt 1978 · S/N TJ-179N99RFEcho Bravo Aviation LLC · Nashville, TNBuilt 1974 · S/N TH-463N99RKNorth Shore Flying Club · Libertyville, ILBuilt 1992 · S/N TH-1649N99TBHadden Banjamin D · Incline Village, NVBuilt 1976 · S/N 31-7612074N99TDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1991 · S/N TH1641N99VATwin Otter International Ltd · Las Vegas, NVBuilt 1976 · S/N 31T-7720007N99VK421 Golden Eagle LLC · Cheyenne, WYBuilt 1969 · S/N 421A0091N99WPMarco Investments · Ripley, MSBuilt 1978 · S/N TH-958N99WTSudick Daniel · Dadeville, ALBuilt 2000 · S/N TH-1959N9AMHangen Mark C · Flagstaff, AZBuilt 1969 · S/N 310P0196N9APWellsville Flying Service Inc · Wellsville, NYS/N 27-7305129N9AYProclaim Aviation Ministries · Worthington, MNBuilt 1980 · S/N 421C0844N9DCColeman Jet Solutions LLC · Highland Park, ILBuilt 1982 · S/N 44-8107065N9DGRichmond Stephen C · Luthersville, GAS/N 30-1585N9EPMcavian LLC · Perryton, TXBuilt 1981 · S/N TJ-378N9FWWright Air Service Inc · Fairbanks, AKBuilt 1974 · S/N 31-7405468N9GTRedemption Inc · Kodiak, AKBuilt 1989 · S/N 20800153N9LJBurgauer Aviation LLC · Mount Calm, TXS/N 33701777N9LTRegistered aircraftBuilt 2001 · S/N TH-1989N9MN15 Point LLC · Lafayette, INS/N 414-0851N9NCEmpresas Marex Inc · Mayaguez, PRBuilt 1978 · S/N 414A0202N9NSTs&L Aircraft LLC · Alexandria, MNBuilt 1979 · S/N TJ-238N9NXTalkeetna Aero Services Inc · Anchorage, AKS/N 20800129N9NYDanner Jason · Burleson, TXBuilt 1965 · S/N 30-739N9PEN9pe LLC · Locust Grove, GABuilt 1972 · S/N 39-143N9QExecutive Express LLC · Elizabeth City, NCBuilt 1975 · S/N 31-7512014N9RNBerry Bryan E · Wilson, NCBuilt 1982 · S/N T30300126N9RYDpr Capital LLC · Farmington, UTS/N 340A0211N9RZChapman Inc · Sherman, TXS/N 421C0236N9SDResort Aviation LLC · Surfside Beach, SCS/N 421B0888N9TXRegistration Pending · San Ysidro, CARegistration pending, canceledBuilt 1978 · S/N 31-7812060N9WJWsw Rental Of Sarasota LLC · Longboat Key, FLBuilt 1973 · S/N 340-0185
Back to AD 2004-25-16 R1