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.

N1387MJ&D Aero LLC · Wilmington, DEBuilt 1975 · S/N 18264308N1387SGalaz Nick Anthony · Lake Havasu City, AZBuilt 1976 · S/N 18264948N1388SCowboy Taxi LLC · Payson, AZBuilt 1976 · S/N 18264949N1388ZSterling Michael · Purcell, OKBuilt 1961 · S/N D-6807N1389ZNachtigal Joel K · Bulverde, TXBuilt 1961 · S/N D-6814N138AHuff Air LLC · Uvalde, TXBuilt 2002 · S/N L2K-138N138ADDance Carlton Spencer · Center, TXBuilt 1991 · S/N CE-1638N138AFSchultz David · Murfreesboro, TNBuilt 2006 · S/N 41702N138CDN138cd LLC · Boca Raton, FLBuilt 2026 · S/N 11179N138CKMako Medical Laboratories LLC · Raleigh, NCBuilt 2009 · S/N 3492N138CRValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1584N138GGardiner Alan H · Waterford, CTBuilt 1964 · S/N D-7564N138LACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11499N138MCCherington Cirrus LLC · Belmont, MABuilt 2019 · S/N 4755N138MFN138mf LLC · Opa Locka, FLBuilt 2008 · S/N 1938N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482N138QKyff Jeffrey V · Traverse City, MIBuilt 1964 · S/N TC-612N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362N138TWSulka Andrew Mark · Pittsburgh, PABuilt 1974 · S/N D-9647N138VBAh1f Associates LLC · Clifton Park, NYBuilt 2017 · S/N T24002138N1390LGreen Rose LLC · Swartz Creek, MIBuilt 1978 · S/N 33701882N1390ZGm Aviation LLC · Woodridge, ILBuilt 1961 · S/N D-6833N1391SWysong Charles J · Hickory, NCFirst renewal noticeBuilt 1976 · S/N 18264952N1392SAbc Flying Club Inc · West Mifflin, PABuilt 1976 · S/N 18264953N1392ZRautiola Charles A · Rosemount, MNBuilt 1961 · S/N D-6822N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840N1393WWvl Aviation Inc · Wilmington, DEBuilt 2006 · S/N 42531N1393ZSdd LLC · Great Falls, MTBuilt 1961 · S/N D-6813N1394SGoodman Donald J · Bellingham, WABuilt 1976 · S/N 18264955N1395SGarcia Robert W · Floresville, TXFirst renewal noticeS/N 18264956N1395VBliz Aviation LLC · Bend, ORBuilt 2006 · S/N 41667N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012N1397ZJ&W Air LLC · Asheville, NCBuilt 1961 · S/N D-6819N1398SOff The Charts LLC · Kalispell, MTBuilt 1976 · S/N 18264959N1399MRegistered aircraftBuilt 1975 · S/N 18264314N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712N139JMPegasus Medical Management LLC · Wilmington, DES/N 2742N139KSpectrum Air LLC · Leesburg, VABuilt 2016 · S/N 2338N139LCAmedeo Flight Ops Limited · Dublin 2Built 2018 · S/N 1769N139PTCroley John T Jr · Fitzgerald, GABuilt 1964 · S/N TC-758N139QMoles Timothy E · New Cumberland, WVBuilt 1964 · S/N TC-638N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083N139TATell Christopher A · Colville, WABuilt 1974 · S/N D-9652N139YPSmuzzle Air LLC · Longboat, FLBuilt 1977 · S/N 28R-7703364N13AGWeather Modification LLC · Fargo, NDBuilt 1977 · S/N 34-7770115N13AKTailwinds Inc · Toms River, NJBuilt 1975 · S/N TH-678N13BJSevcik Clint · Medford, MNS/N 21058486N13BLCross Country Aviation LLC · Park City, UTBuilt 1975 · S/N E-724
Back to AD 2000-23-21