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.

N82870Martell William T · Lander, WYS/N 7AC-1520N82873Trimble Richard · Forest City, IABuilt 1946 · S/N 7AC-1523N82874Edwards Thomas M · New Tazewell, TNBuilt 1946 · S/N 7AC-1524N82875Collum Archie L Jr · Milton, FLBuilt 1946 · S/N 7AC-1525N82881Smokovitz Joseph M · Tecumseh, MIBuilt 1946 · S/N 7AC-1531N82882Kraus Russell E · Albemarle, NCBuilt 1946 · S/N 7AC1532N82888Schwegmann Jeffrey G · Birdsboro, PABuilt 1946 · S/N 7AC-1538N82889Better Living Aviation Inc · Wilmington, DEBuilt 1946 · S/N 7AC-1539N82892Middle Tennessee Aviation LLC · Arrington, TNBuilt 1946 · S/N 7AC-1542N82900Murray Aaron C · Moorhead, MNBuilt 1946 · S/N 7AC-1550N82901Stribrny Joseph H · Fairbanks, AKS/N 7AC-6432N82909Redd Charles H · Dutton, MTBuilt 1946 · S/N 7AC-1559N82911Bedeley Eugene T · Sioux Falls, SDS/N 7AC-1561N82919Castellanos Angel L · Port Orange, FLBuilt 1946 · S/N 7AC-1569N82924Guarino Charles E · Springtown, TXBuilt 1946 · S/N 7AC1574N82925Bfn Aviation LLC · Noblesville, INBuilt 1946 · S/N 7AC-1575N82932Morgan Donald F · Reno, NVBuilt 1946 · S/N 7AC-1582N82934Baker Bernard Jr · Lady Lake, FLBuilt 1946 · S/N 7AC-1584N82935Sanborn Jeffery J · Crane Lake, MNBuilt 1946 · S/N 7AC-1585N82938Stuckert Robert D · Scottdale, PABuilt 1946 · S/N 7AC-1588N82939Schmillen Greg A · Phoenix, AZBuilt 1946 · S/N 7AC-1589N82940Classic Aviation Inc · Pella, IABuilt 1946 · S/N 7AC-1590N82944Wolfe Kimberly R · Butler, KYBuilt 1946 · S/N 7AC-1595N82950Fletcher Flying Service 419 LLC · Labelle, FLBuilt 1946 · S/N 7AC-1601N82958Allen John B Jr · Sutter Creek, CABuilt 1946 · S/N 7AC-1609N82959Doherty Joseph J · Bristol, RIBuilt 1946 · S/N 7AC-1610N82963Gagne Gilbert R · Apple Valley, CABuilt 1946 · S/N 7AC-1614N82973Midland Avionics LLC · Louisville, KYBuilt 1946 · S/N 7AC-1625N82975Dabo-Champ LLC · Culpeper, VABuilt 1946 · S/N 7AC-1627N82984Moontown Airport Inc · Brownsboro, ALS/N 7AC-1636N82987Webb Jeffrey J · Fair Play, SCBuilt 1946 · S/N 7AC-1639N82989Hiers Timothy F · Barney, GAS/N 7AC-1641N82993Registration Pending · North Platte, NERegistration pendingBuilt 1946 · S/N 7AC-1645N82994Schmidt Robert A · De Forest, WIBuilt 1946 · S/N 7AC-1646N82995Heath Erik J · Milan, MIBuilt 1946 · S/N 7AC-1647N82996Leroy Philippe G · Willcox, AZS/N 7AC-1648N829JBMathis Robert · Sandersville, GABuilt 1965 · S/N 34N829LTThompson Timothy G · Kenosha, WIBuilt 2008 · S/N 1078-2008N82ACSoutheast Lsa LLC · Jacksonville, FLS/N 1000-2006N82CBStoup Kevin D · Altus, OKBuilt 1946 · S/N 7AC-4446N82KDKizita Management LLC · Los Altos, CABuilt 2019 · S/N 1182-2019N82LRuppert Russell E · Dover, PABuilt 1946 · S/N 7AC-1571N82VBSky Designs LLC · Kalamazoo, MIBuilt 1967 · S/N 491N8300Meulenberg Jacobus M J · Schenevus, NYS/N 7AC-1655N83002Gunkelman Donald K · Valley City, OHBuilt 1946 · S/N 7AC-1654N83004Marsh Steven A · Eaton Rapids, MIBuilt 1946 · S/N 7AC-1656N83011Freeland Jeanne · Sedona, AZBuilt 1946 · S/N 7AC-1665N83012Shuey Jack L Jr · Owego, NYBuilt 1946 · S/N 7AC-1666N83018Ginn Howard H Trustee · Camp Verde, AZBuilt 1946 · S/N 7AC-1674N83019Miller Timothy J · Hutchinson, MNS/N 7AC-1675
Back to AD 2000-25-02 R1