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.

N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614N553WP6sm Aviation LLC · Savannah, GABuilt 1974 · S/N TC-1757N55414Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 34-7350212N5545YKolarek Frank · West Nyack, NYFirst renewal noticeBuilt 1964 · S/N 27-2644N554CCAmg/Sherfick Aviation LLC · Noblesville, INBuilt 1982 · S/N 421C1228N554JFRhoton Joel S · Borger, TXS/N TC-1286N554JSKilo Kilo Mike LLC · Jacksonville, FLBuilt 1980 · S/N TC-2323N554KCaux Brisebois Vincent · Newcastle, WAS/N TC-1179N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157N554SDAeroplanes2 LLC · Indianola, IABuilt 1964 · S/N TC-646N554TBOwen Harold E Jr · Collierville, TNBuilt 1976 · S/N TC-1998N5554GGaluk Douglas P · Wisconsin Rapids, WIBuilt 1977 · S/N 421C0249N5558PValiair Lc Trustee · Casper, WYS/N TJ-399N555BTPeters Andrew Thomas · Annandale, MNS/N 34-8233014N555CPFirebird Air LLC · Fulshear, TXBuilt 1979 · S/N 340A0651N555CSGibson Air LLC · Park Hills, MOS/N TJ-385N555CTN555ct LLC · Largo, FLBuilt 1981 · S/N 414A0822N555DCAmoroso Ricardo C · Powder Springs, GABuilt 1959 · S/N 23-1780N555DGBonnie Aero LLC · Dryden, MIBuilt 2013 · S/N 20800547N555FRWallace Jeffrey S · Bonita Springs, FLS/N 31T-8004010N555FSJacko Josh E · Anchorage, AKBuilt 1978 · S/N 31-7952046N555GTRegistered aircraftBuilt 1979 · S/N 31-7952148N555HFChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 4496176N555JECantr Holdings LLC · Fish Creek, WIBuilt 1970 · S/N TC-1329N555JGLeia Air LLC · Wilmington, DEBuilt 1979 · S/N 31-8012018N555KKGe Flyer 1 LLC · Sheridan, WYS/N 421C1022N555LFrankland Robert · Jackson, TNS/N 34-7970489N555MFCloud 555 Inc · Wilmington, DEBuilt 1980 · S/N 31-8012068N555MVDavis Elijah L · West Union, OHBuilt 1966 · S/N 310K0186N555MYSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 421B0886N555NSN8241r LLC · Leawood, KSBuilt 1969 · S/N 30-1790N555PRHarlan Thomas D · Fresno, CABuilt 1969 · S/N 27-4248N555RDGates Robert H · Santa Barbara, CABuilt 1977 · S/N TC-2025N555RFRayburn Aviation LLC · Center, TXBuilt 1974 · S/N 421B0621N555RPGreenwood Auto LLC · Itta Bena, MSS/N TC-2009N555TMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLBuilt 1969 · S/N TC-1232N555TYKiefer Karl F · Spring, TXBuilt 1974 · S/N 340-0515N555UJAero Holdings LLC · Palm City, FLBuilt 1984 · S/N 348433039N555WPSherry-Aire LLC · Sidney, MTS/N 414A0074N5561VPm Aviation Services LLC · Kailua, HIBuilt 1977 · S/N 34-7770253N5565DDirect Flight Inc · Vineyard Haven, MABuilt 1989 · S/N TH-1552N556CLLutz Ed · Pine Valley, CABuilt 1966 · S/N 337-0543N556PCChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 4496074N5571VColeman Douglas E · Tallahassee, FLBuilt 1959 · S/N 23-1784N5579YHepner Glenn L · New Port Richey, FLBuilt 1964 · S/N 27-2684N557CEBce Aviation Llp · Lexington, KYBuilt 1977 · S/N TH-864N55877N A Corp · Scappoose, ORS/N 34-7350255N5588YBrennan Thomas F · Titusville, PAS/N 27-2695N558BFMatrix Aviation LLC · Birmingham, MIS/N 421C0845
Back to AD 2004-25-16 R1