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.

N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669N1920MThompson William F · Fisherville, KYBuilt 1975 · S/N 18264482N1920QAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 1977 · S/N 18503502N1920XJensen Richard Vaughn · Emmett, IDBuilt 1965 · S/N 18256020N1921MRed Shirt Resources LLC · Weatherford, TXBuilt 1975 · S/N 18264483N1922TBiscoe Donald M · Cottage Grove, MNBuilt 1969 · S/N 21059220N1922UFriedrich Richard R · Newtown, CTS/N 185-1593N1922XHerman Joseph T · Lovell, WYBuilt 1965 · S/N 18256022N1923PPremium Air LLC · Hibbing, MNBuilt 2018 · S/N 4610N1924W1824 Whiskey LLC · Golf, ILBuilt 2023 · S/N 9493N1925JBuzco Aviation LLC · Thomaston, GABuilt 1966 · S/N 337-0431N1925XBtak LLC · New Baden, ILBuilt 1965 · S/N 18256025N1926QVonimhof Rudolph F · Anchorage, AKBuilt 1977 · S/N 18503503N1926UBarrett Michael D · Anchorage, AKBuilt 1973 · S/N U20602287N1926XWilkerson Kelvin E Jr · Kannapolis, NCBuilt 1965 · S/N 18256026N1927TZ And N 1927t LLC · Wapella, ILBuilt 1977 · S/N 182-65857N1928TWalters Jonathan · Malvern, OHBuilt 1990 · S/N CE-1533N1929UHolmgren David J · Plainfield, NJBuilt 1962 · S/N CD-554N192AAReardon Michael J · East Falmouth, MABuilt 1959 · S/N D-5964N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496N192AGBp Aviation LLC · Gilbert, AZBuilt 2005 · S/N 29-0406N192BCLeo Aviation Inc · Rogers, ARBuilt 2024 · S/N 10246N192BSIntoodeep Industries LLC · Palm Bay, FLS/N 2753N192BWChirles Michael A · Weston, CTBuilt 2006 · S/N 1625N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160N192CRIvas Edward P · Great Barrington, MABuilt 1992 · S/N 92-301016N192CWBowen Jeffrey Charles · Frankston, TXBuilt 1979 · S/N R1723092N192JKWest Gregory B · Cummings, GABuilt 2004 · S/N 29-0353N192JRCessna 185 LLC · Birmingham, MIS/N 18502286N192PGRhoads William M · Williamsburg, VABuilt 2008 · S/N 1923N192QFisher Robert · Shoreacres, TXS/N TC-783N192TMWalker Randy · De Queen, ARBuilt 2005 · S/N 1578N1930XDuff James J · Pueblo, COBuilt 1965 · S/N 18256030N1931MAnchor Aviation LLC · Johnstown, COBuilt 2024 · S/N 10392N1931QKlaes Sheldon T · Fairbanks, AKBuilt 1977 · S/N 18503504N1931XRuffner Ryon Garrett · Argyle, TXBuilt 1965 · S/N 18256031N1932NChubb Stanley C · Mason, MIBuilt 1973 · S/N CE-417N1932UFryer Charles Trustee · Glendale, AZBuilt 1969 · S/N 18501623N1933MShepherd Matthew R · Bloomington, INBuilt 1976 · S/N 18264487N1933XHall Michael D · Athens, ALBuilt 1965 · S/N 18256033N1934MKornetzke Jeffrey A · Lake Mills, WIBuilt 1976 · S/N 18264488N1934XMarshall Michael R · Collierville, TNBuilt 1965 · S/N 18256034N1936MScott George M · Reno, NVS/N 18264489N1936XNelson William T · Benton, KYBuilt 1965 · S/N 18256036N1937MPoultry Not Beef LLC · Chancellor, ALBuilt 1976 · S/N 18264490N1937XOrtiz Marquez Ricardo A · Melbourne, FLBuilt 1965 · S/N 18256037N1939X1939xray LLC · Chester, SCBuilt 1965 · S/N 18256039N193DC310 Charter LLC · Zanesville, OHBuilt 1980 · S/N 310R1885N193DWGilbert Louis Vincent · Houston, TXBuilt 2004 · S/N 42043N193FBDiamond Sage LLC · Herndon, VABuilt 2000 · S/N 30-0054
Back to AD 2000-23-21