OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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.

N9513EDowdy Andrew L · Maxwelton, WVFirst renewal noticeBuilt 1946 · S/N 11AC-1149N9515EBarron Shawn · Tiffin, OHBuilt 1946 · S/N 11AC-1151N9518ESvec Adolph Ralph · Marengo, ILBuilt 1946 · S/N 11AC-1154N9518SSprunk Logan J · Chaffee, NDBuilt 1965 · S/N 7GCB-283N9519EGoth Warren W · Beloit, KSS/N 11AC-1155N9519SKs Flying Club Inc · Manhattan, KSBuilt 1965 · S/N 7ECA-257N951AGAcn951ag LLC · Worthington, OHBuilt 1999 · S/N 850-99N9520SPease Richard C · Snow Camp, NCBuilt 1965 · S/N 8N9522TVeillon Joseph B · Alexandria, LAS/N 555N9523SHogan Edison D · Macon, ILBuilt 1965 · S/N 95N9526EOsswald Louis C · Hubertus, WIBuilt 1946 · S/N 11AC-1162N9529SRegistered aircraftBuilt 1965 · S/N 331N952BPhillips Chad · Teague, TXBuilt 2006 · S/N 1408-2006N952EROliver Lawrence G · Lewiston, MEBuilt 2011 · S/N 1109-2011N952WAMcenery William J · East Haddam, CTBuilt 1973 · S/N 394-73N9530ECantwell Paul M · Momence, ILBuilt 1946 · S/N 11AC-1167N9531SUpland Amy L · Miami Springs, FLBuilt 1966 · S/N 349N9534SBall Ronald C · Colby, KSBuilt 1965 · S/N 297N9536SExpress Aviation LLC · Philadelphia, MSBuilt 1966 · S/N 94N9537ERegistered aircraftBuilt 1946 · S/N 11AC-1174N9537SHowell Alice R · Bainbridge, GABuilt 1965 · S/N 23N9538SClark William · Easton, MOBuilt 1965 · S/N 304N9539ERegistration Pending · Wickenburg, AZRegistration pendingBuilt 1946 · S/N 11AC-1180N9539SFox Norman A · Maryville, TNBuilt 1965 · S/N 305N9540EHegarty Ryan · West Sand Lake, NYBuilt 1946 · S/N 11AC-1178N9540SNeufeld Maria · Seminole, TXBuilt 1965 · S/N 258N9543EMccoy Steve C · Hinton, WVBuilt 1946 · S/N 11AC-1179N9543STherkelsen Robert D · Burlington, WABuilt 1965 · S/N 271N9544EBell Steven C · Lamesa, TXBuilt 1946 · S/N 11AC-1181N9548EPalmenteri Louis J · Rhome, TXBuilt 1946 · S/N 11AC1187N9549SZippy Airways LLC · Columbus, OHBuilt 1965 · S/N 7ECA363N9551SBerberich John E · Wasilla, AKS/N 364N9552EOleary Ruth · Jacksonville, FLS/N 11AC-1189N9552SSmith Ranch Inc · Broadus, MTBuilt 1965 · S/N 42N9555SMcquillin Duane C · Palmer, AKBuilt 1965 · S/N 370N9557ECleveland Lorne T · Tyler, TXS/N 11AC-1193N9558SKansas Air LLC · Linn, KSS/N 39N955SAMiller David S · Mt Sterling, KYBuilt 2005 · S/N 1383-2005N9560EShook Devin T · Fairbanks, AKS/N 11AC-1197N9561SFerguson Glen P · Cascade, MTS/N 56N9562EAnderson Rick L · Valley City, NDS/N 11AC-1199N9562SVon Bevern Brian J · Overland Park, KSBuilt 1966 · S/N 84N9563SMumm Paul D · Geneva, NEBuilt 1965 · S/N 337N9564ERhodes Jake H · Lenoir, NCBuilt 1946 · S/N 11AC-1201N9564SRegistration Pending · Taylorsville, KYRegistration pendingBuilt 1965 · S/N 7ECA-62N9565SLittle Lambert W · Hamilton, TXFirst renewal noticeS/N 373N956DPInfinity Aviation LLC · Comstock, WIBuilt 2021 · S/N 614-2021N956JWKms Investigations & Consulting LLC · Colleyville, TXBuilt 2021 · S/N 1479-2021N956RHHuston Ben E · Sanger, TXBuilt 2006 · S/N 510-2007N9570EWamsley Dearle James · Trimble, MOS/N 11AC1208
Back to AD 2000-25-02 R1