OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,135

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-23-21')
    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-23-21')
  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.

N107GKYoung William L · Boston, MABuilt 2014 · S/N 0790N107HMission Accomplished LLC · Boca Raton, FLBuilt 1966 · S/N TE-36N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079N107JSSayers James B · Edison, OHBuilt 1975 · S/N CJ-88N107LHale Mitchell D · Chugiak, AKBuilt 1978 · S/N 18503535N107MMBonanza Aviation LLC · Tulsa, OKBuilt 1983 · S/N E-2089N107MTTuch Michael · Gonzales, TXS/N 4846N107MYTeatree LLC · Incline Village, NVBuilt 2018 · S/N 1751N107PBAntler Air LLC · Klamath Falls, ORBuilt 2006 · S/N 2292N107PMHaase Jason M · Hastings, NEBuilt 1986 · S/N 46-8608023N107SWanagel Walter · Lisbon, CTBuilt 1949 · S/N NAV-4-1946N107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTBuilt 1984 · S/N 18268427N107TGSowder Douglas A · Spokane, WABuilt 2008 · S/N L2K-279N107THWheaton James G · Johns Island, SCBuilt 1996 · S/N 0001N107TQSouthland Air Holdings LLC · Albany, GABuilt 2013 · S/N 3996N107VWHenning Nancy E · Hardinsburg, KYBuilt 1960 · S/N CD-71N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034N1080STacoma Management Inc · Martinsville, VABuilt 1997 · S/N TH-1818N1080WParks Robert Steven · Hayward, CAFirst renewal noticeBuilt 1973 · S/N CE-435N1081VGulley Cameron L · Eastland, TXBuilt 1976 · S/N R1722109N1081YWc LLC · Austin, TXBuilt 1996 · S/N E-3039N1082PGarrett James D Jr Trustee · Coolidge, AZBuilt 1968 · S/N 18258855N1082YCalvey Eric W · Abingdon, MDS/N 25-0582N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453N1083WAeolus Aircraft LLC · Seminole, OKS/N TH-323N1084FSiktberg Timothy J · Nashville, TNFirst renewal noticeBuilt 1975 · S/N 18502739N1084PTimothy Duane High · Glenwood, MOBuilt 2000 · S/N LIV-434N10851Curran Michael F · Windham, NHS/N 25-1229N1085CBentley Geoffrey D · Marco Island, FLBuilt 1990 · S/N 25-1228N1085MDuncan Terry C Trustee · Cupertino, CABuilt 1975 · S/N 18264221N1085NWong Sonja M · Alameda, CABuilt 1981 · S/N 25-0583N1086CTeare Matthew A · Sagamore Hills, OHBuilt 2003 · S/N 0462N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564N1086MSargent John E · Vancouver, WABuilt 1975 · S/N 18264222N1086VKinney Philip S · Saint Johns, FLBuilt 1976 · S/N R1722111N1086WThomas R Cave Inc · San Jose, CABuilt 1996 · S/N EA-586N1087SVolitation Ventures LLC · El Macero, CABuilt 1996 · S/N EA-587N1087TCampagna Thomas B · Midland, TXBuilt 2008 · S/N 411033N1088DSpf America LLC · Fort Smith, ARBuilt 2009 · S/N 421015N1088LLima Whiskey Ic LLC · Mertzon, TXBuilt 1995 · S/N E-2988N1088VLeiva Lloyd · Bradenton, FLBuilt 1976 · S/N R1722112N1089CRegistered aircraftBuilt 1995 · S/N E-2989N1089EAml Aviation LLC · Lexington, KYBuilt 1996 · S/N E-3030N1089FWells Thomas J · Big Lake, AKBuilt 1975 · S/N 18502744N1089MPetersen Clayton · Albert Lea, MNBuilt 1975 · S/N 18264223N1089WKucera Christopher T · King George, VABuilt 1973 · S/N E-422N108BGN108bg Co · Wilmington, DEBuilt 2011 · S/N 3RX164
Back to AD 2000-23-21