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.

N1506MBonn Steven · Hummelstown, PABuilt 1975 · S/N 18264356N1506ZTopspeed Black LLC · Alpharetta, GABuilt 1961 · S/N CD-395N1507SArteta David A · Wake Forest, NCFirst renewal noticeBuilt 1962 · S/N D-6935N1508CHutchings Alan J · Clewiston, FLBuilt 1953 · S/N 30208N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816N1508KWny Aero LLC · Orchard Park, NYBuilt 2010 · S/N 0042N1509CHammerquist Blake T · Benicia, CABuilt 1954 · S/N 30882N1509MChalk 2 Inc · Apple Valley, CABuilt 1975 · S/N 18264357N1509ZHeinrich John W · Chandler, AZBuilt 1961 · S/N TC-210N150CFDesutter S Bryan · Manito, ILBuilt 1980 · S/N 340A1215N150DRVan Den Heuvel Michael E · Middleton, WIBuilt 1990 · S/N CE-1473N150GVy Holdings LLC · Midland, GABuilt 2025 · S/N 10723N150JBMyers Clifford A · Arbuckle, CABuilt 1977 · S/N R1722521N150LCLipoff Jay I · Sarasota, FLBuilt 2005 · S/N 41501N150SALedges Aviation LLC · Palm Beach, FLBuilt 2007 · S/N 1863N150SCAnderson Thomas R · Seattle, WABuilt 1973 · S/N U20601958N150UUKoshar Steven R · Coloma, MIBuilt 1961 · S/N D-6630N150ZZSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2007 · S/N 2609N1510SClark Lahn F · Pasco, WABuilt 1962 · S/N D-6940N1511CBouton Vern H · Fairbanks, AKFirst renewal noticeBuilt 1953 · S/N 30211N1511WFlorida Float Plane LLC · Coral Gables, FLBuilt 1972 · S/N TH-217N1512CMolek Jon · Warren, OHBuilt 1953 · S/N 30212N1512SIrwin Dennis R · San Diego, CABuilt 1962 · S/N D-6941N1512WBryant John Mark · Knoxville, TNBuilt 1972 · S/N D-9332N15138Lone Star Flight Museum · Houston, TXBuilt 1967 · S/N R1720133N1513CSteffen Thomas E · Decatur, TXBuilt 1953 · S/N 30213N1513SHoward Michael G · Slaughters, KYBuilt 1962 · S/N CD-473N1514BLilu LLC · Siloam Springs, ARBuilt 1988 · S/N CE-1276N1514MVaquera Moises C · Orland, CABuilt 1975 · S/N 18264359N1514VVanreeth James E · Washington Island, WIBuilt 1976 · S/N R1722198N1514ZDierold Robert S · Carrollton, TXBuilt 1961 · S/N D-6832N1515CMountain Taildraggers LLC · Aspen, COBuilt 1953 · S/N 30215N1515FCain Ronald A · Slidell, TXBuilt 1965 · S/N 185-0844N1515MSurecraft LLC · Dover, DEBuilt 1988 · S/N CE-1304N1515WCenturionair LLC · Greenville, SCBuilt 1972 · S/N TH-218N1515ZYanks Air Museum · Baldwin Park, CABuilt 1961 · S/N D-6831N1516CSpotorno John Alan · Redwood City, CABuilt 1953 · S/N 30216N1516MWrubel David · Atlanta, GABuilt 1988 · S/N E-2459N15178Gill Robert S · Woodinville, WABuilt 1966 · S/N R172-0179N1517FSalter 11x LLC · Duluth, MNS/N 185-0854N1517UN1517u LLC · Mequon, WIBuilt 1969 · S/N 20700117N1517ZFreedom Aviation LLC · Beaufort, SCBuilt 1961 · S/N CD-412N15186N15186 LLC · Dyer, INBuilt 1988 · S/N E-2456N1518UN1518u LLC · Waukesha, WIS/N 20700118N15194Mcgrath Kevin M · Cloquet, MNBuilt 1967 · S/N R172-0195N1519CMinor Edward H · Gordon, NES/N 30219N1519SSimmons Gene R · Vicksburg, MIFirst renewal noticeBuilt 1962 · S/N CD-498N151ALCirrus Sr22t 11110 Inc Trustee · Wilmington, DEBuilt 2025 · S/N 11110N151CGN151cg Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0344N151CTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1984 · S/N 18268410
Back to AD 2000-23-21