OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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.

N224EJGlenn Air LLC · Ponte Vedra Beach, FLBuilt 2023 · S/N 9476N224FRVictor 93 LLC · Hummelstown, PABuilt 2008 · S/N 2953N224GHSdl Concepts LLC · Missoula, MTBuilt 2013 · S/N T24002022N224GMVerboski Timothy W · Azle, TXBuilt 2015 · S/N 31-0137N224GRHaufe Nicole C · Madeira Beach, FLBuilt 2003 · S/N 0626N224HThompson Dennis P · Spokane Valley, WABuilt 1956 · S/N 32649N224HAMoser Myron · Chanhassen, MNBuilt 2025 · S/N 10954N224HPNguyen Cody · Richmond, CABuilt 1965 · S/N D-7806N224JC109 Ventures & Agency Services Inc · Glenburn, MEBuilt 2004 · S/N 0914N224JF224jf LLC · Waterford, MIBuilt 2006 · S/N 2031N224JGGuillory Mark T · Pineville, LABuilt 2004 · S/N 1013N224JKBrown Peter · Leavenworth, WABuilt 2018 · S/N 1660N224JMHip Flights LLC · Avon, COBuilt 2017 · S/N 1640N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812N224KGRavin Group LLC · Orlando, FLBuilt 2012 · S/N 0312N224KRJds Holdings LLC · Oneida, TNBuilt 2002 · S/N 0179N224LRCamp95 Enterprises LLC · Wheeling, WVBuilt 2002 · S/N 0155N224LWVedda Aviation Group LLC · Cleveland, OHBuilt 2012 · S/N 0293N224LZMazzia Aviation Partners LLC · Alpine, WYBuilt 2007 · S/N 2767N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089N224MJGlover William Scott · Mount Pleasant, TXS/N 1-064N224MVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1922N224NCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11608N224NHLola Leasing LLC · Sugar Land, TXBuilt 2009 · S/N 3569N224NXNexair Avionics LLC · Plymouth, MABuilt 2002 · S/N 0170N224PBDeaux James · Collierville, TNBuilt 2006 · S/N 1754N224PCCarlson Craig B Trustee · Los Altos, CABuilt 2018 · S/N 4655N224PFKurrle Ryan J · Austin, TXBuilt 2006 · S/N 1917N224PJLeng Jason W · Chehalis, WABuilt 2006 · S/N 2281N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016N224PVTrigo Air LLC · Madera, CABuilt 2015 · S/N 1226N224RFWby Inc · Orange, CABuilt 2002 · S/N 1178N224RGBonanza Aircraft Inc Trustee · Cheyenne, WYBuilt 2009 · S/N E-3894N224RJDuke Mfg Of Florida LLC · Saint Louis, MOBuilt 2013 · S/N 4027N224RTIronwood Aviation LLC · Boerne, TXBuilt 2008 · S/N 3268N224RWNomad Air LLC · North Bend, WABuilt 2005 · S/N 1595N224SSmith Darrell E · Duncan, OKBuilt 1965 · S/N TC-892N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152N224SJPrestige Aircraft LLC · Madison, WIBuilt 2003 · S/N 0705N224SRRaffo Christopher Stephen · Potomac, MDBuilt 2006 · S/N 2172N224STB & G Aviation Enterprises LLC · Lilburn, GABuilt 2004 · S/N 0882N224SYMrc1 LLC · Bernie, MOBuilt 2002 · S/N 0184N224TGPlaneview LLC · Fountain Hills, AZBuilt 2005 · S/N 1570N224UQue Estaran Haciendo LLC · North Miami, FLBuilt 2008 · S/N 3129N224W0262 Aviation Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10046N224WSEagle Aero LLC · Green Bay, WIBuilt 2022 · S/N 8807N224WTSkizer Inc · Marina Del Rey, CABuilt 2006 · S/N 1947N224YBFly Robin Fly LLC · Marietta, GABuilt 2025 · S/N 11048N2251GValentine Terence S · Glennallen, AKBuilt 1958 · S/N 51551N2251MBelfiglio Brett N · Arroyo Grande, CABuilt 1979 · S/N 28R-7931001
Back to AD 2000-23-21