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.

N23PCHenderson Aviation Inc · Abingdon, VAS/N TH-2071N23PFBagge Tom · Monticello, IABuilt 1968 · S/N 310P0044N23PLNewsome Jeff · Blackwell, OKBuilt 1970 · S/N P-128N23PVLake Dana · Boxford, MAFirst renewal noticeBuilt 1987 · S/N TH-1513N23RDRegistered aircraftS/N 30-469N23RHCajun Crimson Air LLC · Hoover, ALS/N 414A0258N23RLCaljet Inc · Van Nuys, CABuilt 1981 · S/N 421C1094N23TACor Yan · San Juan, PRBuilt 1978 · S/N 27-7854114N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281N23WGSamson Ryan · Escondido, CABuilt 1963 · S/N 27-565N2402ALaurelton Village Inc · Alamance, NCS/N TC-1931N24041Texas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496290N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049N240AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496650N240GBSchumaker Joseph W Jr · Petersburg, MIBuilt 1966 · S/N 310K0188N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108N240LHWitt Aaron K · Hooker, OKBuilt 1966 · S/N 30-1240N240RWestex Telco LLC · Abilene, TXS/N 3449496N240RATop Aircraft Leasing LLC · Wilmington, DES/N 310Q0108N240RTAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 421B0863N240TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496558N2413SQualitair LLC Trustee · MichelstadtBuilt 1967 · S/N 337-0713N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78N2417SPiasecki Aircraft Corporation · Coatesville, PABuilt 1967 · S/N 337-0717N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241EWFort Carlos LLC · Fort Worth, TXBuilt 1978 · S/N 421C-0496N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241N241MWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 421C0030N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589N241TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496559N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922N2425AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496252N2428PHill Tim E · Russellville, ARBuilt 1970 · S/N 39-64N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799N242GG242gg LLC · Wilmington, DEBuilt 1979 · S/N 31-7952080N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802N242RCCarrera Aviation LLC · Wilmington, DEBuilt 1972 · S/N TH-248N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042N243MBSwanson Timothy J · Bannister, MIBuilt 1967 · S/N 337-0813
Back to AD 2004-25-16 R1