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.

N7171YHeinrich Steven W · Conroe, TXBuilt 1963 · S/N 30-191N717AUPiper Aircraft Inc · Vero Beach, FLS/N 4496655N717BDWeathered Aviation Inc · Rogers, ARBuilt 1979 · S/N 414A0337N717CGContinental Title Trust LLC Trustee · Wichita, KSBuilt 1974 · S/N 414-0495N717ERThomas James V · Cullman, ALBuilt 1985 · S/N TH-1463N717LN717l LLC · Toledo, WABuilt 1973 · S/N TC-1495N717LRJnnss LLC · Hillsborough, NJS/N 421C1109N717RTAndreini Linda J Trustee · Half Moon Bay, CAS/N 34-7670221N717TATwin C Aviation Inc · Chapel Hill, NCBuilt 1966 · S/N 30-1030N717UOcean Abaco LLC · Virginia Beach, VABuilt 1983 · S/N 31-8352026N717WSCutting Edge Sales LLC · Santa Fe, NMBuilt 1961 · S/N 27-415N7180YAl-Banna Emad R · Huntingtown, MDBuilt 1963 · S/N 30-200N7181YEagle Aeronautics LLC · Chicago, ILS/N 27-8054021N7182YMccue John M · Tuttle, OKS/N 30-206N7183KRabourn John P · Spokane, WABuilt 1963 · S/N 30-207N7186YHill Mark T · Gloucester, VAS/N 30-210N7187YAircore LLC · Apache Junction, AZBuilt 1963 · S/N 30-211N7188YRegistration Pending · Christiansted, VIRegistration pendingBuilt 1963 · S/N 30-212N7189YHesano Joseph M · Rockford, ILBuilt 1963 · S/N 30-213N718JMPage Field Aviation LLC · Fort Myers, FLBuilt 1979 · S/N TC-2257N718JRFlytwincos LLC · Las Vegas, NVBuilt 1964 · S/N 30-276N718MWescon Margin Inc · Wilmington, DEBuilt 1979 · S/N 27-8054011N718MAGlinn Andrew T · Keystone, NEBuilt 1974 · S/N 310Q1153N71908Mielke Martin W · Valley City, OHBuilt 1973 · S/N 33701500N7190YMiller Kevin · Collegedale, TNBuilt 1963 · S/N 30-214N7196YAircraft & Aviation Professionals LLC · Coldwater, MIS/N 30-220N7197DJ And J Farming LLC · Halsey, ORBuilt 1969 · S/N P-70N7199YFour Way Aircraft Ltd · Pensacola, FLBuilt 1963 · S/N 30-223N719WTTait Jesse L · Belton, TXBuilt 1979 · S/N 34-7970362N71ADSons Aviation LLC · Moody, ALS/N 30-1524N71BBMitchell Trans · Timnath, COFirst renewal noticeBuilt 1967 · S/N 30-1539N71FLWest Transportation LLC · West Bloomfield, MIBuilt 1968 · S/N 27-3969N71GMEtheredge Mark · Pell City, ALBuilt 1969 · S/N 30-1959N71GRRahmeyer Gary W · Lake Ozark, MOBuilt 1976 · S/N TH784N71GTHazduff LLC · Plainfield, INBuilt 1969 · S/N 30-1801N71JLSheets Terrell P · Duplessis, LABuilt 1965 · S/N TC-973N71JRSouthgate Development Inc · Wichita Falls, TXBuilt 1976 · S/N 421C0066N71LDLaney James R · Granbury, TXS/N 340A0764N71LKChallenge Tool & Mfg Inc · New Haven, INS/N 31-8052155N71NAYe Services Inc · Bradenton, FLBuilt 1981 · S/N 34-8233017N71PVCeleste LLC · Playa Del Rey, CABuilt 1966 · S/N 30-1261N71WDBlach Rhino Ltd LLC · Phoenix, AZS/N 310Q0107N72006Detmer Darren D · Chappell Hill, TXBuilt 1984 · S/N TJ-460N7200YBroussard Don W Jr · Wynne, ARBuilt 1963 · S/N 30-224N7201RWaltz John · Tampa, FLBuilt 1974 · S/N TC-1813N7202MG&M Baron Aviation LLC · Bradenton, FLS/N TJ-456N7202RHughbanks Matthew L · Evergreen, COBuilt 1975 · S/N TC-1819N7204EOverit Air LLC · Las Vegas, NVBuilt 1984 · S/N TJ-457N7205EAl Force 1 LLC · North Salt Lake, UTBuilt 1984 · S/N TJ-458N7206YSkyflite LLC · Hillsboro, ORS/N 30-232
Back to AD 2004-25-16 R1