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.

N39WHGolden Touch LLC · Kalispell, MTBuilt 1976 · S/N 421C0070N3CHElliott Frank F · Mojave, CABuilt 1970 · S/N 33701282N3DJHatch Hyrum G · Chandler, AZS/N 421C0011N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525N3HERidgemont Real Estate Inc · Huntington Woods, MIBuilt 1974 · S/N TC-1710N3HKInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340-0538N3HNDraper Floyd Lawrence · El Paso, TXBuilt 1967 · S/N 310L-0166N3JNGas Aviation LLC · Decatur, TNBuilt 1966 · S/N 337-0558N3KXMarathon California Holdings Lp · San Diego, CABuilt 1971 · S/N 414-0161N3LGTuthill James G Jr · Burr Ridge, ILBuilt 2011 · S/N 20800525N3LNAllen Jeffrey W · Crestwood, KYBuilt 1973 · S/N 340-0301N3MUAero Equities LLC · Ventura, CAS/N TH-1864N3PEJabr Aviation LLC · Milford, IABuilt 1977 · S/N TH-820N3PMEwing John L Jr · Yuma, AZBuilt 1967 · S/N 310N-0009N3RKCorinthian LLC · Southgate, MIS/N 31T-8166022N3TCRegistration Pending · Clewiston, FLRegistration pendingBuilt 2011 · S/N 20800527N3THHayden Charles J III · Rhome, TXBuilt 1967 · S/N TC-1034N3TQAbove Blue Line LLC · Austin, TXBuilt 1973 · S/N 310Q0752N3UCYahraus Andrew · Phoenix, AZBuilt 1981 · S/N TJ-337N3UGHoffman William C · Mount Pleasant, PABuilt 1977 · S/N 27-7854050N3VACook Marvin R · Portales, NMS/N 414-0258N3VBHarrison Ted W · Grapevine, TXBuilt 1965 · S/N 320D0044N3VJMiasnikowicz Victor · Lancaster, PABuilt 1973 · S/N 310Q0746N3VMAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1973 · S/N 31-7305069N3WFFolk Wolfgang · Fairfield, CABuilt 1975 · S/N 414-0617N3WJLlorca Carlo A · Naples, FLBuilt 1974 · S/N TC-1713N3XEServ Aero Engineering Inc · Salinas, CABuilt 1963 · S/N 30-92N40001Gaines Harry E · Fontana, CABuilt 1977 · S/N 34-7770356N4001SLeckonby David · Waterford, NYS/N TC-1817N40036Paulay Sandor F · Kenmore, WAS/N 34-7770369N4008PViento LLC · Nashville, TNS/N 23-1483N4009PApplegate Ronald E · Rosamond, CABuilt 1958 · S/N 23-1484N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345N400BJAirrich LLC · Largo, FLBuilt 1974 · S/N 421B0819N400BPCole Gary · Richmond, TXBuilt 1969 · S/N P-96N400BSMb Aviation Inc · Larue, TXS/N 421C1089N400CAGroundloop Mafia LLC · Desha, ARBuilt 1974 · S/N TC-1727N400CEMcmurray Bradley Thomas · Advance, NCBuilt 1975 · S/N 421B0930N400CMAerial Surveys International LLC · Watkins, COBuilt 1976 · S/N 31T-7620040N400FCCrosswind Enterprises LLC · Box Elder, SDS/N 414A0023N400HMBarneys Services Inc · Newton, IABuilt 1979 · S/N 31-8052030N400LBAutumn Crocus LLC · Cincinnati, OHS/N 30-1059N400MJHaney Michael W · Tehachapi, CAS/N 23-1627N400RAJacko Josh E · Anchorage, AKBuilt 1974 · S/N 31-7405167N400TDHardy Mikel · Twin Falls, IDBuilt 1968 · S/N 30-1708N400TMPaxton Homes LLC · Killeen, TXS/N 421B0885N400VVCarver Aero LLC · Muscatine, IABuilt 2001 · S/N 4496105N400WMBryan Craig · Ellisville, MSBuilt 1972 · S/N 310Q0634N400WSHatbright Farm LLC · Wilmington, DEBuilt 1981 · S/N 31T-8166044
Back to AD 2004-25-16 R1