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.

N7430YLavion LLC DBA · Zeeland, MIBuilt 1964 · S/N 30-491N7431YRegistration Pending · Lynchburg, VARegistration pendingBuilt 1964 · S/N 30-492N7435YStc Aviation LLC · Wilmington, DEBuilt 1964 · S/N 30-498N7436CMatanane Roke C · Barrigada, GUBuilt 1976 · S/N 27-7754017N7438YFranklin Aviation Services LLC · Inverness, FLS/N 30-501N7439YGoethals Robert M · Silverdale, WABuilt 1964 · S/N 30-502N743ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701647N743SLLewis And Hart Development LLC · Nashville, TNBuilt 1984 · S/N 31P-8414037N7441YHatton Leslie A · Chesapeake, VAS/N 30-504N7442YMy Toys Inc · Jacksonville, FLS/N 30-505N7445YCherish Aviation LLC · Woodbridge, VABuilt 1964 · S/N 30-509N7446YN7446y Aero LLC · Joplin, MOBuilt 1964 · S/N 30-510N7449YMiddle Georgia Aviation Inc · Cochran, GABuilt 1964 · S/N 30-513N744AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496242N744BWDobson'S Leasing Co LLC · Ocoee, FLBuilt 1981 · S/N 414A0658N744CAMay Richard Ullmann · Soquel, CAS/N 421C1014N744ELScintitech Inc · Shirley, MAS/N 34-8233068N744JCAck-Pg-LLC · Charlestown, MABuilt 1979 · S/N 31-7912119N744PZHemmingway Gray Inc · Los Gatos, CABuilt 1981 · S/N TJ-382N7453YStratus Air Services LLC · Punxsutawney, PABuilt 1964 · S/N 30-516N7454YOrthner Aviation LLC · Chattanooga, TNBuilt 1964 · S/N 30-517N7455YTowns Bobby · Nashville, TNBuilt 1964 · S/N 30-518N7457YPeter Prince Aviation Center LLC · Milton, FLBuilt 1964 · S/N 30-520N745ASA2g International LLC · San Juan Capo, CABuilt 1977 · S/N 33701817N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043N745EPSumner Michael · Hahira, GABuilt 1974 · S/N 414-0498N745MAStrategic Health Inc · Sandy, UTS/N 3449245N7463YSkyway Flight Service LLC · Jonesboro, ARBuilt 1964 · S/N 30-526N7468YThys Edouard B · Olympic Valley, CABuilt 1964 · S/N 30-531N7469YStader Stacy H · Altoona, FLBuilt 1964 · S/N 30-532N746AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496243N746ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701850N746DMBirds Birds LLC · Bradenton, FLS/N TH-354N7471YLi Yilin · Alma, MIBuilt 1964 · S/N 30-536N7473YSale Reported · Palmer, AKSale reportedBuilt 1964 · S/N 30-538N7475YOverseas Aviaton Inc · Wilmington, DEBuilt 1964 · S/N 30-540N7476YWilliam L Stewart Code Supplies Inc · Rossville, TNBuilt 1964 · S/N 30-541N7477DDuke One LLC · Longmont, COS/N P-142N747ATHaueisen Jessica · Franklin, GABuilt 1978 · S/N 27-7854080N747AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496455N747CAAction Air Express Inc · Santa Monica, CAS/N 421C0850N747CGAir Americus LLC · Johns Creek, GABuilt 1981 · S/N 31-8152070N747DSDelaware State University · Dover, DEBuilt 2019 · S/N 4496486N747DWAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH-2002N747HPK & S Aero · Wilmington, DEBuilt 1977 · S/N TC-2034N747KPDeer Howard W III · Reston, VABuilt 1966 · S/N 30-1223N747PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1974 · S/N 34-7450112N747PHFirst State Bancshares Inc · Middleberg, KYFirst renewal noticeBuilt 1988 · S/N TH-1533N747RCConti Richard T · Orinda, CABuilt 1978 · S/N 34-7970068N747SBCloud Transport Operations LLC · Kalispell, MTBuilt 1980 · S/N TJ-297
Back to AD 2004-25-16 R1