OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N122KMBruce Mellor Inc · Escalon, CABuilt 2001 · S/N 0036N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413N122MBSuncrest Industries Inc · Lake Forest, CABuilt 2022 · S/N 8607N122MG122mg Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1250N122MTKing Aviation Services LLC · Marietta, OHBuilt 2019 · S/N 1856N122PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 2797N122PGMcgaw Thomas D · Petaluma, CABuilt 1961 · S/N TC-149N122PTLove Ralph E Jr Trustee · Carmel, CABuilt 2008 · S/N L2K-184N122RLuv2av8 · Fort Pierce, FLBuilt 1997 · S/N L IV-169-PN122RCCurtis Alvis Jr · Bakersfield, CAS/N 21059298N122RHPadussis Gary Theodore · Cape May, NJBuilt 1993 · S/N 93-301017N122RLJenaero LLC · Cincinnati, OHBuilt 1978 · S/N TC-2177N122RRDebold David A · Spring, TXBuilt 1961 · S/N D-6706N122RSN864sr LLC · Phoenix, AZBuilt 2008 · S/N 3241N122RWShick Kenneth W · Rosamond, CABuilt 2004 · S/N GT001N122SJDeloof Dion S · Austin, TXBuilt 1963 · S/N D-7118N122SMCirrus Aircraft LLC · Middletown, DEBuilt 2018 · S/N 1658N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283N122SPPort Cyber Aviation Sr LLC · Austin, TXBuilt 2025 · S/N 11005N122SZValiair Lc Trustee · Casper, WYBuilt 2018 · S/N 1834N122TFWampler Kenneth E · Pottstown, PABuilt 1957 · S/N 21022N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794N122VAVollman David B · Bunkie, LABuilt 2011 · S/N 0163N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203N122VSOrwin LLC · Winter Park, FLBuilt 2014 · S/N 4155N122VWJk Aviation LLC · Fresno, CAS/N D-6435N122WB2sea2it LLC · Ossining, NYBuilt 1973 · S/N 33701487N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094N122XPWatch Ya Head Aviation 1 LLC · Zionsville, INS/N R1722055N122YWilsbach Kenneth · Fort Myer, VAS/N L2K-249N122ZM122 Zulu Mike LLC · Wheaton, ILBuilt 2018 · S/N 1760N122ZTJdw Aviation Inc Trustee · Wilmington, DEBuilt 2020 · S/N 4882N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875N1231BRise Companies Aviation LLC · Hawley, MNBuilt 2020 · S/N 2166N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793N1231ZD&J Vtail LLC · Punta Gorda, FLBuilt 1961 · S/N D-6693N1232FLloyd Land Plane I LLC · Brighton, COBuilt 1975 · S/N 18502794N1232KCorporate Air LLC · West Mifflin, PABuilt 1984 · S/N 340A1815N1233BSutton Aircraft Salvage LLC · Palmer, AKS/N 51215N1233FFlyboyz LLC · Bourbon, MOS/N 182-61270N1233MFrench Rollie T · Vermillion, SDBuilt 1975 · S/N 18264251N1233VFlybuy Investments LLC · Natchitoches, LAS/N R1722147N1233WDouble Crown Investments LLC · Earlsboro, OKBuilt 1970 · S/N 18260263N1234FSkydive New Hampshire LLC · Moab, UTFirst renewal noticeS/N 33444N1234MDelta Mike Aviation LLC · Darien, CTBuilt 1997 · S/N 29-0127N1234QDembowski Rodrick · Seattle, WABuilt 1969 · S/N E-165N1234TBonanza LLC · Huntington, WVBuilt 1967 · S/N CE-141N1234VFrailey Randy J · Chouteau, OKBuilt 1979 · S/N D-10221
Back to AD 2000-23-21