OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N36482Fair Air Inc · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870335N36487Steele Charles C · Hollandale, MSS/N 34-7870337N3648DFerry Theodore D · Bellevue, WABuilt 1956 · S/N 35348N3648UMerlin Aviation LLC · Grants Pass, ORBuilt 1963 · S/N 18255048N36496Moseler Scott · Barrington, ILBuilt 1978 · S/N 28R-7803326N3649CBayou Flight LLC · Parker, COBuilt 1954 · S/N 31147N3649USteele Aerospace Service LLC · Tulsa, OKS/N 18255049N364ACWalker Geri G · Carrollton, GABuilt 1998 · S/N E-3148N364APMartin John T · Paradise, CAS/N 35340N364AU364au LLC · Ames, IABuilt 2014 · S/N E-4031N364BBSocio Aviation Services LLC · Benton, KYBuilt 1999 · S/N E-3240N364BFFlying B Partners LLC · Wichita, KSBuilt 1977 · S/N E-1166N364BSHusky 89 LLC · Bethany, OKBuilt 2007 · S/N E-3786N364CMoore Charles K · Woodinville, WABuilt 1978 · S/N 18266262N364DBHirsch Benjamin M · Orange Park, FLBuilt 1995 · S/N E-2963N364DDJd Bonanza LLC · Mesa, AZBuilt 1996 · S/N E3056N364DFBlackley Nathan · Eugene, ORBuilt 1997 · S/N E-3091N364EMountain Desert Aviation LLC · Lake Havasu City, AZBuilt 2010 · S/N E-3944N364ELFiorini Randy · Turlock, CABuilt 1988 · S/N CE-1268N364EMSafeco Leasing LLC · Port Alsworth, AKBuilt 1968 · S/N E-56N364GGTddc Ventures LLC · Dublin, CABuilt 1990 · S/N EA-501N364HPZadeh Alidad Trustee · El Centro, CABuilt 1973 · S/N E-402N364JBBlazie Marketing Services Inc · Street, MDBuilt 1997 · S/N E-3079N364KNo Plans LLC · Alvord, TXBuilt 2007 · S/N 42557N364MWUpwind Approach LLC · Lisle, ILS/N E-3651N364SCTfs Inc · Chelsea, ALBuilt 2001 · S/N E-3374N364SSLampert David M · Atherton, CABuilt 1992 · S/N EA-542N364TJohnsons Ag-Air Inc · Tyler, MNBuilt 1962 · S/N D-7045N364TWVo Thien T · Amarillo, TXBuilt 1985 · S/N EA-449N364VKPetts Adam · Waukee, IABuilt 1981 · S/N E-1973N364WPPorter Flying Service · Durham, CAS/N E-1914N3650AMcclain Aviation LLC · Newark, DEBuilt 1969 · S/N D-9077N3650CTotty Michael N · Gainesville, MOBuilt 1954 · S/N 31148N3650HRoyal Horus Elevate LLC · San Antonio, TXBuilt 1980 · S/N 25-0434N3651UDeibel Adam · Flagstaff, AZS/N 18255051N3652YMokhtari Rasoul · Nashville, TNBuilt 1963 · S/N 21058152N36536Sky High Investments LLC · Greenwood, INBuilt 1978 · S/N 34-7870341N3653AKlemenhagen David · Wasilla, AKBuilt 1969 · S/N TC-1309N3653CDomingquez Clara · Anchorage, AKBuilt 1954 · S/N 31151N3653HDove Kenneth F · Danville, CABuilt 1980 · S/N 25-0435N3653UMedeiros Germano Manuel · Caruthers, CABuilt 1963 · S/N 18255053N3654CRose Hugh S · Fairbanks, AKBuilt 1954 · S/N 31152N3654HThompson William D · Godley, TXBuilt 1980 · S/N 25-0436N3655CViavant Toby S · Ester, AKBuilt 1954 · S/N 31153N3655UBoggs Dennis E · Buffalo, WYBuilt 1963 · S/N 18255055N36565Maxwell James B · Lewiston, IDBuilt 1968 · S/N TC-1142N3656UMccarty Troy Allen · New Plymouth, IDBuilt 1963 · S/N 18255056N3657YSims Daniel G · Martinez, CABuilt 1963 · S/N 21058157N3658YJo Co Inc · Knoxville, TNFirst renewal noticeBuilt 1963 · S/N 21058158N3659CWhite Paul S · Clarksville, TNBuilt 1954 · S/N 31158
Back to AD 2000-23-21