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.

N2511RDickey Mark D · Pendleton, ORS/N 18258211N2511XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 42063N2511YPrieur Philip · Suwanee, GABuilt 2005 · S/N 41060N25120Waconda Concepts LLC · Sturgis, SDBuilt 1985 · S/N 46-8508097N2512GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 51812N2512QPeacock Jeffery D · Cleburne, TXS/N 18257712N2512SCorsentino Joseph · Temple, TXRegistration revokedBuilt 1967 · S/N 337-0812N2512XKeesee Theodore A · Lavonia, GABuilt 2005 · S/N 42077N2513GSedlickas Mark A · Graham, WABuilt 1959 · S/N 51813N2513KCarlson Thomas G · Anchorage, AKBuilt 1978 · S/N 18052964N2513TPettaway J Michael · Lake Charles, LABuilt 1968 · S/N NAV-4-2513N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013N2514FVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41093N2514RRichmond Patrick A · Glenmora, LABuilt 1967 · S/N 18258214N2514THinkle Marcus E · Brazoria, TXBuilt 1968 · S/N NAV-4-2514N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014N2515BIndependent Columbia Aviators LLC · Katonah, NYBuilt 2004 · S/N 41040N2515QHackney Joel · Trabuco Canyon, CABuilt 2006 · S/N 41585N2515TWoodside Jason S · Warrenton, VABuilt 1968 · S/N NAV-4-2515N2516SCol4 Training LLC · Wichita, KSBuilt 2006 · S/N 41570N2517XBraun Robert M Trustee · Watkins, MNBuilt 2005 · S/N 42081N2517ZGerrety Loren P · Anchorage, AKBuilt 1962 · S/N 185-0517N2518HHakan Michael · Carpinteria, CABuilt 2005 · S/N 41079N2518QSwaldi Thomas · Marion Heights, PABuilt 1966 · S/N 18257718N2518TRivard Beauregard E · Shafer, MNBuilt 1968 · S/N NAV-4-2518N2519MCoutcher Michael A · Belleview, FLBuilt 1977 · S/N 28R-7803131N2519RPentzien Inc · Omaha, NEBuilt 1967 · S/N 18258219N251AAAys Aviation LLC · Charlotte, NCBuilt 2024 · S/N 9959N251ASMil2atp Inc · Pikeville, NCBuilt 1980 · S/N 34-8070119N251BCBearce Larry J · Solon, IAS/N 28R-7803174N251BWVarsolona Frank L · Las Vegas, NVBuilt 1980 · S/N 25-0299N251CPBurshtan David H · Huntington Beach, CABuilt 2008 · S/N 3176N251DXFlight Advantage Inc · Hot Springs, ARBuilt 2005 · S/N 41068N251GT251gt Corp · Oak View, CAS/N CD-251N251RDidier Christopher W · Fay, OKBuilt 1972 · S/N 61139N251SBAvistar Aviation LLC · Brentwood, TNS/N 0213N2520CKrause Douglas R · Hinckley, OHBuilt 2005 · S/N 41516N2520GGrinch Aviation LLC · Madera, CABuilt 1959 · S/N 51820N2520QRcmt Properties LLC · Havre, MTBuilt 1966 · S/N 18257720N2520RWinston Douglas S · Star, IDBuilt 1967 · S/N 18258220N2520SPeregrine Air LLC · Colorado Springs, COBuilt 2005 · S/N 41073N2521GMountain Aviator LLC · Edwards, COBuilt 1959 · S/N 51821N2521TMoore Kevin B · Lancaster, VABuilt 1968 · S/N NAV-4-2519N2521WPc Enterprise Holdings LLC · Penfield, NYBuilt 2005 · S/N 41514N2522FGentrius LLC · Austin, TXS/N 41049N2522QJohnson Sales & Service Inc · Ong, NEBuilt 1966 · S/N 18257722N2522RPechanec Brent L · Wichita, KSBuilt 1967 · S/N 18258222N2522TLemons Lawson W · Crowell, TXBuilt 1967 · S/N NAV-4-2504N2522XAce Handyman Services LLC · Sussex, NJS/N P206-0022N2523GDannebrog Air LLC · Grand Island, NEBuilt 1959 · S/N 51823
Back to AD 2000-23-21