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.

N42323Gardiner Russell J · Phoenix, AZS/N 18258965N42325Henry Nolan T · Ashland, ORS/N 18258967N42326Hooper James Carl · Webster, MNBuilt 1968 · S/N 18258968N42328High Tony W · Walters, OKBuilt 1968 · S/N 18258969N4232QRamstad Trygg J · Anchorage, AKS/N 18502227N42335Gubernat John F Jr · Pepperell, MABuilt 1968 · S/N 18258971N42349Skylane 49 LLC · Glenwood Springs, COBuilt 1968 · S/N 18258976N42359Lincoln Roger Trustee · Gildford, MTBuilt 1973 · S/N 18052343N4235CColville LLC · Signal Mountain, TNBuilt 1974 · S/N 414-0534N42364Smathers Geoffrey R · Mars, PABuilt 1968 · S/N 18258986N42368Madson Chris J · King City, CABuilt 1968 · S/N 18258988N42369Hecker Darin · Grants Pass, ORBuilt 1968 · S/N 18258989N4236QTyrrell Jerry R · Woodland, WABuilt 1973 · S/N 18502228N42371Optum Sun LLC · Laguna Hills, CAS/N 18258990N42376Johnson Lytle D · Anacortes, WABuilt 1973 · S/N 18052348N42379Wh Land Holdings LLC · Kirbyville, TXBuilt 1968 · S/N 18258996N4237CBreakaway Group Aviation LLC · Franklin, TNBuilt 1974 · S/N 414-0535N42380Payne Patricia C · Spokane, WABuilt 1968 · S/N 18258997N42381Anthony David W · Wasilla, AKFirst renewal noticeS/N 18258998N42382Nb Services LLC · Sumrall, MSBuilt 1968 · S/N 18258999N42387Bernau Jeff A · Kalispell, MTS/N 18259000N42397Brissey Forrest L · Woodinville, WABuilt 1968 · S/N 18259003N423BDConcorde Transportation LLC · Freehold, NJBuilt 2020 · S/N 4893N423BEPs Capital Equipment LLC · Delray Beach, FLBuilt 2020 · S/N 2106N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658N423CCAllen Stephen David · Los Banos, CABuilt 1978 · S/N 28R-7803368N423CDGrzebik Ellerine P · Petaluma, CAS/N 1109N423CLTmt Aero Inc · Perrysburg, OHBuilt 1983 · S/N TH1394N423CPAltus Aviation LLC · Pike Road, ALBuilt 2013 · S/N 3944N423JKKraft John · Lake View, IABuilt 1982 · S/N E1951N423LGNew Cirrus 2018 LLC · Ponte Vedra Beach, FLBuilt 2026 · S/N 11266N423LL79bravo Leasing LLC · Lincoln, DEBuilt 1975 · S/N 18264071N423MDSublett Charles M · Tulsa, OKBuilt 1964 · S/N D-7454N423PPrestige Worldwyde! LLC · Concord Township, OHBuilt 2002 · S/N E 3439N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270N423RGSchue Gary C · Fredericksburg, VABuilt 2005 · S/N SES-181MB2N423RHHunt Robert H · Taylorsville, MSBuilt 1971 · S/N 33701420N423SV & L Enterprises LLC · Wilmington, DEBuilt 1981 · S/N 34-8233071N423SRHaloroc Muppets II LLC · Nashville, TNBuilt 2007 · S/N 2459N423WBMass Air LLC · Chattanooga, TNBuilt 2025 · S/N 10464N423WTCoons John K · Winston Salem, NCBuilt 1964 · S/N D-7426N423YEconome James S · Danville, CABuilt 1961 · S/N D-6845N424Ross Michael J · Los Angeles, CABuilt 1976 · S/N P3370259N42400Smith Randolph L · Orovada, NVBuilt 1968 · S/N 18259004N4240142401 LLC · Hailey, IDBuilt 1973 · S/N 18052350N42409Ross Leslie W · Truckee, CAS/N 18259006N4241BBor-It Mfg Co Inc · Ashland, OHBuilt 1974 · S/N 75-30727N42421Registered aircraftBuilt 1968 · S/N 18259011N42424Bowyer Charles W Stephen · Tucson, AZBuilt 1968 · S/N 18259013N42428Hantzsche Jackson R · Wellington, NVBuilt 1968 · S/N 18259014
Back to AD 2000-23-21