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.

N574WDLathrop Frederic W · Dayton, OHBuilt 1997 · S/N TH-1831N5751CRemy H Blanchaert Jr Dds Md Pa · Wichita, KSS/N 340A0974N5752YShackelford John S Jr · Roanoke, TXS/N 27-2877N57539Registration Pending · Meriden, CTRegistration pendingBuilt 1976 · S/N 31P-7630002N5755KBrooks Auto Parts Inc · Douglas, GABuilt 1964 · S/N TC-738N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975N575ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496203N575CWWheeler Dealer LLC · Wilmington, DES/N TH-2075N575EHajdukovich Robert M · Fairbanks, AKBuilt 1976 · S/N 31-7652006N575HBHot Damn Flying Service LLC · Palm Coast, FLBuilt 1973 · S/N 310Q0788N575JBForbes Consolidated Inc · New Smyrna Beach, FLS/N 414A0426N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268N5762MNewby Aviation LLC · Pingree Grove, ILBuilt 1968 · S/N 310P0062N5763KNnamsu Enterprises LLC · Walnut Creek, CAS/N TC-748N5768MHeal Your Heart LLC · Redding, CABuilt 1968 · S/N 310P0068N5768S3c LLC · Waukee, IABuilt 1972 · S/N 3400037N5773YMccabe Aero LLC · Grand Haven, MIBuilt 1965 · S/N 27-2902N577KGMccloy Mark T · Tatum, NMS/N 421C0906N577RJAviation Trust Company LLC · Oklahoma City, OKBuilt 1981 · S/N 421C1108N577SWAir Plains Services Corp · Wellington, KSS/N 421-0023N577UV & V LLC · Shenandoah, VABuilt 1966 · S/N TC-984N577WGta Air Inc · Addison, TXBuilt 1973 · S/N TH-375N5781MRudnik Andrew S · Ann Arbor, MIBuilt 1969 · S/N 310P0081N5782MGingell Robert A · Sunnyvale, CABuilt 1969 · S/N 310P0082N5783MBig Turbine Engines LLC · Wilmington, DEBuilt 1969 · S/N 310P0083N5787YMarr Steven K · Saint Charles, MOBuilt 1965 · S/N 27-2917N5794MMatlach Matthew · Brandon, FLBuilt 1969 · S/N 310P0094N5797YAce Tomato Co LLC · Daytona Beach, FLBuilt 1965 · S/N 27-2927N57APHouston William J · Ellensburg, WABuilt 1957 · S/N 23-1110N57AWGrey Horizon Group LLC · Sheridan, WYS/N TC-1116N57BWNorthwoods Airlifeline Ltd · Kingsford, MIBuilt 1968 · S/N 310N-0154N57DJPasserby Randal K · Mesa, AZS/N 30-1292N57GPFoncho Corp · San Juan, PRBuilt 1982 · S/N 31-8252043N57MPSoleil Aviation LLC · Naples, FLBuilt 1973 · S/N TC-1631N57PGulf Sierra Aviation LLC · Owasso, OKBuilt 1979 · S/N TH-1059N57RTChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N ME-172N57WAE2 Hangar LLC · Folsom, CAS/N 421C0451N5800SRabosky Gary · Frenchtown, NJBuilt 1964 · S/N TC-817N5806XJohnson Joseph S · Juneau, AKBuilt 1961 · S/N 310-0106N5806YDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1965 · S/N 27-2939N580AHMadeline Inc · Clarkston, MIS/N TH-2027N580BXPreferred Management Corp · Shawnee, OKS/N TH-2124N580EN580e LLC · Hickory, NCBuilt 1995 · S/N TH-1758N580JKMarshall John · Cold Spring, MNBuilt 1977 · S/N TH-792N580NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496257N580SPWatag Corp Trustee · Wilmington, DEBuilt 1965 · S/N 27-3046N580WFry Michael David · Madeira Beach, FLBuilt 1976 · S/N TH-774N5811KUpp Air LLC · Portland, MEBuilt 1965 · S/N TC-910N5812XAll-Bid Inc · Opelousas, LABuilt 1961 · S/N 310-0112N5814XEberly Steven K · Euless, TXBuilt 1961 · S/N 310-0114
Back to AD 2004-25-16 R1