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.

N211AJLevisee Steve · Irvine, CABuilt 1977 · S/N 18265580N211ALMallory Equipment Leasing LLC · Portland, ORBuilt 2022 · S/N 8985N211ANCalifornia In Nice Inc · San Jose, CABuilt 1974 · S/N 18263220N211ASBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 20700259N211ATGeorge'S Aerial Spraying Service Inc · Sutton, NEBuilt 1971 · S/N 18800834N211AWWeis Aaron · Waban, MABuilt 2005 · S/N 1278N211BStone Air LLC · Carrollton, GABuilt 1964 · S/N TC-714N211CADggehrig LLC · Helena, MTBuilt 2023 · S/N P06N211CFGoudreau Sean · Mount Dora, FLBuilt 1978 · S/N 21063013N211CKClark Kim A · Rogers, ARBuilt 2015 · S/N 1025N211CMMoneypit Investment Corp · Wilmington, DEBuilt 2005 · S/N 1692N211DRegistered aircraftBuilt 1966 · S/N TC-995N211DCN211dc LLC · Los Angeles, CABuilt 1979 · S/N 28-7921037N211DGSteel Crazy LLC · Page, AZFirst renewal noticeBuilt 1989 · S/N EA-489N211EBGarrard Mark E · Reno, NVBuilt 1968 · S/N TE-656N211EEV35a Speedsters LLC · Henderson, COBuilt 1968 · S/N D-8888N211EWJtb Logistics LLC · Byars, OKBuilt 1966 · S/N 337-0443N211FStoltzfus Calvin J · Great Falls, MTBuilt 1963 · S/N TC-514N211FDVuelo Seguro LLC · North Logan, UTBuilt 2025 · S/N 10396N211KCPau Hana LLC · Wilmington, DEBuilt 1977 · S/N 18265645N211LR & G Schatz Farms Inc · Lockeford, CABuilt 1979 · S/N 21063183N211LCSuddarth Steven Craig · Edgewood, NMBuilt 1974 · S/N 21060364N211LHLidzbarski Mark A · Southington, CTBuilt 2006 · S/N 1831N211MJKeefer Squared LLC · Rockmart, GABuilt 1994 · S/N 29-0019N211MVClark Aviation Inc · Greenville, SCBuilt 1999 · S/N E-3244N211MWGoad Jerry A · Oneida, TNBuilt 1973 · S/N TE-923N211PAPiedmont Air Services LLC · Helena, MTBuilt 1981 · S/N U20606415N211PFJed Air LLC · Buena Vista, COBuilt 2022 · S/N 8721N211PPGlobe Motorcycles Ltd Inc · Pembroke Pines, FLBuilt 1951 · S/N 22956N211RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2236N211SSherrifs Office Kane County Utah · Kanab, UTBuilt 1985 · S/N U20606916N211SEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2208N211SQRare Air Inc · Waterford, MEBuilt 1971 · S/N 18260755N211SVMatthews Aviation LLC · Greensboro, NCS/N 340A1000N211SWOrion Aviation LLC · Jeffersonville, INBuilt 1977 · S/N 18503327N211TCMayer William P · Anchorage, AKS/N 185-1380N211TKJaye Jeffrey S · Vacaville, CABuilt 1966 · S/N 18257295N211TMPlane Fun Inc Tr Trustee · Snellville, GAS/N 3572N211TSMartin Rolf Michael · Wellsburg, NYBuilt 2006 · S/N 29-0434N211VHull Robert Abbott · Payson, AZBuilt 1993 · S/N CE-1754N211YRegistered aircraftBuilt 1966 · S/N TE-169N211ZNAllen Michael J · Rescue, CABuilt 1985 · S/N 24-1535N21201Delta Aviation Inc · Monticello, MNBuilt 1972 · S/N 18261481N21202Diamond David Samuel Trustee · Truckee, CABuilt 1972 · S/N 18261482N21203Provence Michael D · Fort Worth, TXS/N 18261483N21205Hodl Partners LLC · Allen, TXBuilt 1972 · S/N 18261485N21206Baird David W · Kanab, UTBuilt 1972 · S/N 18261486N21207Jerdee Jonathan E · Moorhead, MNS/N 18261487N2120FWare Brandie W · Nikiski, AKS/N U206-0320N2120GSouthern Arizona Balloons Inc · Tucson, AZBuilt 1958 · S/N 51420
Back to AD 2000-23-21