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.

N4137BWalker James D · Grapevine, TXBuilt 1974 · S/N 75-30738N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566N4137SBurns Craft LLC · Wilmington, DEBuilt 1976 · S/N TC-1951N4137YMurray Robert Scott · Franconia, NHBuilt 1962 · S/N 185-0337N4138TLindquist Holdings LLC · Noblesville, INBuilt 1965 · S/N 320D0038N4138WK2 Aviation LLC · Sanford, NCBuilt 1999 · S/N 3449122N4139LCj Horizons LLC · Amboy, MNS/N 3449117N413ACJibber Aviation LLC · Westfield, MABuilt 2023 · S/N 9079N413AJSmith Leigh · Knox, INBuilt 2008 · S/N LIV-595N413AKAlhambra Aviation LLC · San Mateo, CABuilt 2016 · S/N 4429N413APAba Aviation LLC · Northbrook, ILBuilt 2018 · S/N 1685N413BMLee Aviation LLC · Sheridan, ARBuilt 1977 · S/N 414A0004N413CNOa2 Aviation LLC · Gallatin, TNBuilt 2010 · S/N 3651N413CPDean Taylor LLC · Palm Coast, FLBuilt 2008 · S/N 3257N413DGWindsock Capital LLC · Bertram, TXBuilt 1959 · S/N 35814N413EEReyenga Steven G · Shreveport, LABuilt 1962 · S/N D-6999N413EM413em LLC · Columbia, ILBuilt 2005 · S/N 29-0388N413ETRaviv Barak Trustee · Beverly Hills, CABuilt 2006 · S/N 1689N413GKKgc Holdings Ltd · Newark, TXBuilt 1973 · S/N D-9450N413HRRamirez Hector · Ocala, FLBuilt 2020 · S/N 32-0012N413JN413j LLC · Locust Grove, GABuilt 1964 · S/N TC-831N413JDJwd Aviation LLC · Johns Creek, GABuilt 2022 · S/N 8806N413KGEagle Mountain International Church Inc · Newark, TXBuilt 1976 · S/N TE-1076N413KJHuber Jeffrey C · Sidney, OHBuilt 1980 · S/N D-10307N413KSMatteo Properties · Wickliffe, OHS/N 333N413LBOficinas De Carolina Inc · San Juan, PRBuilt 1981 · S/N 18504200N413MBrookway Investments LLC · Brookhaven, MSBuilt 1977 · S/N E1151N413MP413 Aviation LLC · Washington, PABuilt 2020 · S/N 2203N413PTag Aviation LLC · Larwill, INBuilt 2004 · S/N 1073N413PGSchaefer John A · Waterloo, ILBuilt 1951 · S/N 22167N413PMJl Bonanza LLC · Keller, TXBuilt 2011 · S/N E-3968N413PTAerobear LLC · Vero Beach, FLBuilt 2012 · S/N 2133N413RSStewart Rentals LLC · Tampa, FLBuilt 2026 · S/N 11460N413SLMilestone Plane LLC · Wilmington, DEBuilt 1988 · S/N CE-1289N413SRBroussard Knoll Law Firm LLC · Marksville, LABuilt 2006 · S/N 1936N413TAInfinite Runway LLC · Union City, CABuilt 1981 · S/N 18267922N413TLSnapper Kai LLC · Kerrville, TXBuilt 2016 · S/N 4338N413WGHavana Farms Equipment · Gilliam, LABuilt 1976 · S/N E-804N413WMCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10413N413WWWilkinson Jason S · Eastvale, CABuilt 1972 · S/N 340-0176N413ZMEncore Aviation LLC · Terre Haute, INBuilt 1997 · S/N 25-2013N4140GCaribbean Development Partnership Ltd · Wilmington, DEBuilt 1977 · S/N 340A0311N4140QJohnson Kyle A · Cheshire, CTBuilt 1968 · S/N 310N-0040N4141ALady Bird Of Rhinebeck LLC · Rhinebeck, NYBuilt 1978 · S/N 310R1374N4141CCulpepper Samie D · Macon, GABuilt 2006 · S/N LIV-520N4141TPremier Properties And Investments LLC · Tarkio, MOBuilt 2005 · S/N 1442N4141XSpuddy Properties LLC · Leclaire, IABuilt 2005 · S/N 1716N4142RValiair Lc Trustee · Casper, WYBuilt 1999 · S/N 3449140N4142VLuccarelli Christopher · Merrimack, NHBuilt 1998 · S/N 3449084N4143NHouk Nathan · Morrisonville, NYBuilt 1999 · S/N 3449133
Back to AD 2000-23-21