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.

N7384YMccafferty Robert S · Duluth, GABuilt 1964 · S/N 30-438N7385RCw Aircraft LLC · Atlanta, GABuilt 1976 · S/N TH-734N7386RHebert William N · Angel Fire, NMBuilt 1974 · S/N TC-1729N7386YAlbee Philip · Cameron Park, CABuilt 1964 · S/N 30-440N7387YLillquist Brien I · Oak Harbor, WABuilt 1964 · S/N 30-442N7388YForward Aero LLC · Thomasville, PABuilt 1964 · S/N 30-443N7389YPascoe Aviation Inc · Gulf Breeze, FLBuilt 1964 · S/N 30-444N738JRRutkosky John J DBA · Palm Coast, FLS/N 33701878N738TFester John P · Sullivan, MOS/N TH-706N7390DErda LLC · Wilmington, DES/N P-108N7391YAeronautical Technical Service Inc · Collierville, TNS/N 30-447N7396YAllen Charles M · Puryear, TNBuilt 1964 · S/N 30-454N73BGRw Air Services Inc · Hatfield, PAS/N 31T-8004027N73CAShelor Investments LLC · Christiansburg, VAS/N TH-1889N73CZBm Air LLC · Anaconda, MTBuilt 1980 · S/N 31-8052177N73EPColburn & Associates LLC · Woodruff, SCBuilt 1973 · S/N 340-0240N73HMTrn Aviation LLC · Lewes, DES/N 421C0234N73HW73 Hotel Whiskey Llp · West Fargo, NDBuilt 1979 · S/N TJ-223N73KMThomas Jackson S · Baton Rouge, LABuilt 1965 · S/N TC-935N73LHWillow Shade Ltd · Englewood, COBuilt 2016 · S/N 20800588N73LKMoore David E · Stuart, FLBuilt 1979 · S/N 31-7912123N73MJArk Flight LLC · Miramar Beach, FLBuilt 1975 · S/N 34-7670114N73RTRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N 31-8252023N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474N73VPyle Dana · Naples, FLBuilt 1961 · S/N 23-2026N73WHBumble Bee Aviation LLC · Brookfield, WIS/N 27-7305184N73ZFlying Rocks LLC · Sparkill, NYFirst renewal noticeBuilt 1964 · S/N 30-359N7400YWright Amos L Jr · Enterprise, ALBuilt 1964 · S/N 30-457N7402YN5746u LLC · Dover, DES/N 30-460N7404YSlowpoke Air LLC · Palm Harbor, FLBuilt 1964 · S/N 30-463N7406YTucker Engineering Associates Inc · Locust, NCS/N 30-465N740AGStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 421A-0033N740HCVuksanovic David A · Fountain Hills, AZBuilt 1984 · S/N 31P-8414043N740MHumphrey William A · Grosse Ile, MIBuilt 1965 · S/N 337-0160N740SBirch Tree Aviation LLC · Unadilla, GABuilt 1969 · S/N 33701221N740WJAlm Holding LLC · Winton, CABuilt 1979 · S/N 340A0740N7410YDuncan Paul J · Bartlett, TNBuilt 1964 · S/N 30-472N7413YOutka Air LLC · Aberdeen, SDBuilt 1964 · S/N 30-475N7418YArmbrister Justin R · Blue Ridge, TXBuilt 1964 · S/N 30-482N74199Aldrich Curtiss R · Aguila, AZBuilt 1965 · S/N 27-3026N741DFSeeding Operations And Atmospheric Res (Soar) LLC · San Angelo, TXBuilt 1975 · S/N 414-0633N741TJJackson Thomas R Jr · Spearfish, SDBuilt 1964 · S/N 30-477N7420DMajeste Air LLC · Loveland, COBuilt 1970 · S/N P-134N7420YLegacy Aviation Inc · Stuart, FLBuilt 1964 · S/N 30-484N7421YHinkle Anthony Gray · Mineola, TXBuilt 1964 · S/N 30-486N7429YDewitt Troy C · Lake Elmo, MNBuilt 1964 · S/N 30-489N742ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701646N742CSSnider William A · Hye, TXBuilt 1973 · S/N 34-7450065N742LTSomid Resources LLC · Choudrant, LABuilt 2020 · S/N 4496495N742NEPotkulski Daniel M · Locust Grove, GABuilt 1978 · S/N TK82
Back to AD 2004-25-16 R1