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.

N3096ESilver Hair Air LLC · Fairfax, VABuilt 1946 · S/N 7AC-6685N3097EBean James P · Tulsa, OKBuilt 1946 · S/N 7AC-6688N30PCHaas Brent R · Willcox, AZBuilt 2026 · S/N 1492-2026N30SBFlare LLC · Chattanooga, TNBuilt 2004 · S/N 955-2004N30WHAcme Aerosports Inc · Huntsville, ALBuilt 1977 · S/N 997-77N3101EVolpp J Michael · Muncie, INBuilt 1946 · S/N 7AC-6692N3106EMiddleline Aviation Inc · Ballston Spa, NYBuilt 1946 · S/N 7AC-6705N3107EJones Donald T Jr · Yona, GUS/N 7AC-6698N3108AMccutcheon Jeffery T · Clinton, LABuilt 1946 · S/N 7AC-6699N3109EDexter Fred H · Live Oak, FLBuilt 1946 · S/N 7AC-6706N310WAHbhis LLC · Gnadenhutten, OHBuilt 2002 · S/N 437-2002N3111ELochner Richard A · Eagle River, AKBuilt 1948 · S/N 7AC-6708N3112EKuhn Darrell G · Irma, WIBuilt 1946 · S/N 7AC-6710N3114ESmith Ronald M · Brawley, CABuilt 1946 · S/N 7AC6711N3115EBushman Kyle P · Pleasant Hill, ORBuilt 1946 · S/N 7AC-6712N3117EKiehle Ingrid E · Anchorage, AKBuilt 1946 · S/N 7AC-6714N3118EJordan Michael J · Hahira, GABuilt 1946 · S/N 7AC-6715N311PMGullwing Research LLC · Boise, IDBuilt 2018 · S/N 592-2018N31251Registration Pending · Marana, AZRegistration pendingS/N 399-72N31252Buchholz Claus W · Haslett, MIBuilt 1972 · S/N 249-72N31256Mason Crosby H · Zebulon, NCBuilt 1972 · S/N 330-72N31257Lea Nathan · Belgrade, MTBuilt 1972 · S/N 400-72N31259Rowlett Jeffery B · Tuckerman, ARBuilt 1972 · S/N 883-72N31260Vix Aircraft Services LLC · Batesville, ARBuilt 1972 · S/N 67-72N31262Sauer Roger A · Glenburn, NDBuilt 1972 · S/N 401-72N31263Handerson Ronald J · Sitka, AKBuilt 1972 · S/N 402-72N31266Registration Pending · Wasilla, AKRegistration pending, pending cancellationBuilt 1972 · S/N 403-72N31267Kieffaber Thomas M · Sagamore Hills, OHBuilt 1972 · S/N 887-72N31268Brown Gregory J · Cordova, TNBuilt 1972 · S/N 404-72N31269Happenstance LLC · Cabot, ARBuilt 1972 · S/N 885-72N31270Kunkle James K · Santa Ynez, CABuilt 1972 · S/N 68-72N31272Nelson Debra M · Astoria, ORBuilt 1972 · S/N 406-72N31273Haselmo Zak-Newton · Park River, NDS/N 52-72N31280Kaster Kenny C · Prineville, ORBuilt 1972 · S/N 408-72N31281Citabria 1972 LLC · Soldotna, AKBuilt 1972 · S/N 888-72N31283Somes Jason · Santa Rosa Valley, CAS/N 334-72N31284Allen Earl R · Cottonwood, CABuilt 1972 · S/N 411-72N31285Ramsey Blake P · Wasilla, AKBuilt 1972 · S/N 413-72N31290Huntting Preston I · Camp Verde, AZBuilt 1972 · S/N 69-72N31292Beranek John W · Prairieburg, IABuilt 1972 · S/N 417-73N31293Scroggins Darrel T · Springfield, MOBuilt 1972 · S/N 56-73N31294Molyneux Gawen G · Yucaipa, CABuilt 1972 · S/N 336-73N31298Rivers Jerry M · Chesterfield, SCBuilt 1972 · S/N 891-73N3129EMack Air LLC · Shelbyville, TNBuilt 1946 · S/N 7AC-6726N312TSWoodford John E · Madison, WIBuilt 1998 · S/N 408-98N3130ECowley Shane R · Bartlett, TXS/N 7AC-6727N3132EBlue River Aviation LLC · Palmer, AKS/N 7AC-6729N31339Mceachern Robert · Tupelo, MSBuilt 1958 · S/N 7AC-1325N3133EViall Patricia L · Scio, ORFirst renewal noticeBuilt 1946 · S/N 7AC-6730N31346Daacke Michael L · Glen Rock, PABuilt 1946 · S/N 7AC-1286
Back to AD 2000-25-02 R1