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.

N451KWKw Plastics · Troy, ALBuilt 1978 · S/N 451-78N451PCParkland College · Champaign, ILBuilt 2024 · S/N 1220-2024N451PSUpside Down Aero LLC · Aberdeen, IDBuilt 1976 · S/N 193-76N451SABobbitt Cole T · Jasper, GABuilt 2004 · S/N 944-2004N4520EDean Hank · Texarkana, ARS/N 7DC-128N4524Benjamin Robert J · Lebanon, ORS/N 11CC237AN4525ESattler Joseph C · Waverly, OHBuilt 1948 · S/N 11CC-238N4526EMcgill Alvin R · Joliet, MTBuilt 1948 · S/N 7DC-134N4529ELong Tuggin D · Smithville, MOBuilt 1948 · S/N 7DC-136N452SPhantom Aviation LLC · Portland, ORBuilt 1992 · S/N 689-92N4531EJohnson Donald B · Lino Lakes, MNBuilt 1948 · S/N 7CCM-118N4532EFloura David P · Blackduck, MNS/N 7DC-138N4533ETurner Rolf R · Sauk Rapids, MNS/N 7DC-139N4535EJensen Cynthia B · Olympia, WABuilt 1948 · S/N 11CC-243N4536ELa Rue Carl A · Cambridge, OHBuilt 1948 · S/N 7DC-140N4537EKyle Lara K · Clear Lake, IABuilt 1948 · S/N 7DC-141N4542EMaddox Jesse G · Valdez, AKS/N 7DC-144N4545EOchsenbauer David J · Ashland, WIBuilt 1948 · S/N 11CC-248N4548EAgaliotis Paul E · San Martin, CABuilt 1948 · S/N 7DC-147N4552EHeppler James Scott · Yakima, WABuilt 1948 · S/N 11CC-251N4553ESasinowski Vance J · Anchorage, AKBuilt 1949 · S/N 11CC-252N4559EPansier Donald J · Green Bay, WIBuilt 1949 · S/N 7CCM-126N455RTSouthern Genesis Aero LLC · Midland City, ALBuilt 2000 · S/N 447-2000N4563EPowelson Mark · Pataskala, OHS/N 7CCM-129N4564EPeterson Kristofor John · Talkeetna, AKS/N 7CCM-130N4566EBaker Jim A · Hermosa, SDS/N 7EC-6N4567EWilliams Daniel H · Blue Springs, MOBuilt 1949 · S/N 7CCM-133N4568EHightower Jerry C · Boyd, TXBuilt 1949 · S/N 7CCM-134N4569EStanger Joseph R · Willow, AKBuilt 1949 · S/N 7CCM-136N456PBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1997 · S/N 400-97N4571EGreen William D · Fairbanks, AKBuilt 1949 · S/N 7CCM-137N4572EMescher Daniel R · Yuba City, CABuilt 1949 · S/N 7CCM-138N4573ECheatum Jamie K · Salina, KSBuilt 1949 · S/N 7CCM-139N4574ECarlisle Kevin · Sheridan, INBuilt 1947 · S/N 7CCM-140N4575ECraig John S Jr · Glenburn, MEBuilt 1949 · S/N 7CCM-142N4578EBlight Andrew J · Endwell, NYBuilt 1949 · S/N 7CCM-148N457ACBrown David R · Niceville, FLBuilt 1999 · S/N 414-99N457FAHartfiel Joel T · Glenwood, IABuilt 1956 · S/N 457N457MCBoguy Air LLC · Kingstree, SCBuilt 1974 · S/N 466-74N4583ECheatham Glenn W J · Hot Springs, SDBuilt 1949 · S/N 7CCM-152N4586EAinslie James A · Richfield Springs, NYBuilt 1949 · S/N 7CCM-158N458ELennox Steve R · Elkhart, INBuilt 1946 · S/N 11AC-1092N4591ERichards S G · North Palm Beach, FLBuilt 1949 · S/N 7DC-156N4592ELockbaum James G · Oconomowoc, WIS/N 7DC155N4597EGormon Michael L · Colville, WABuilt 1949 · S/N 7CCM-166N459ACFurfaro Daniel E · Saint Jacob, ILBuilt 1998 · S/N 412-98N45KSee John William · Centerburg, OHBuilt 1946 · S/N 7AC5244N45MAR V Aviation LLC · Thatcher, AZS/N 1074-2008N45PPHigh Planes Air Service In · Bismarck, NDBuilt 1998 · S/N 392-98N4600EPietsch Kent D · Burlington, NDBuilt 1949 · S/N 7CCM-171
Back to AD 2000-25-02 R1