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.

N142TVPaulson Douglas W · Miami, FLBuilt 1979 · S/N 28R8031020N142TWInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N TH-1841N142WAWhisair LLC · Little Rock, ARBuilt 2024 · S/N 9788N1430GRoyal Wolf Aviation LLC · Lubbock, TXBuilt 1962 · S/N CD-453N1430MSyme Brian James Shannon · Redmond, WABuilt 1975 · S/N 18264328N1431EBrandt Terry R · Hood River, ORBuilt 1979 · S/N 18503840N1431MDmd Aviation LLC · Wilmington, NCBuilt 1975 · S/N 18264329N1432CKnoxville Flyers Inc · Knoxville, TNBuilt 2003 · S/N 1332N1432ENorrisky Consulting LLC · Bozeman, MTBuilt 1982 · S/N 18268178N1433MRegistered aircraftBuilt 1975 · S/N 18264330N1434GWagner Carl · Eagle, IDBuilt 1962 · S/N CD-456N1435SGet The Noz Inc · Coeur D Alene, IDBuilt 1976 · S/N 18264983N1436AWhitney Richard T Trustee · Steamboat Springs, COBuilt 2008 · S/N E-3856N1437AWashington Adrian P · Palm Harbor, FLBuilt 1969 · S/N D-9013N1437GMason Mark D · Brighton, COBuilt 1962 · S/N D-6910N1437VBell John C · Wakefield, NHBuilt 1976 · S/N R1722190N1438SAddamo Vincent R · Porterville, CABuilt 1976 · S/N 18264986N1439010319 LLC · Hudson, NHBuilt 2023 · S/N 9266N1439CRempler David · Chandler, AZS/N 41618N143ABMisch Keith · Staten Island, NYS/N 29-0400N143CGavin Lauren Aviation LLC · Miami, FLBuilt 2008 · S/N 3224N143CPPonzo Christopher A · North Reading, MABuilt 1980 · S/N 18267699N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550N143DBBernard Daniel · GrillyBuilt 1965 · S/N 18256678N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357N143FCarlton John B · Lenoir, NCBuilt 1953 · S/N 23488N143FL143fl LLC · Roseville, MIBuilt 2026 · S/N 11180N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664N143KMBc Aircraft LLC · Edmonds, WABuilt 1977 · S/N 18265435N143MBHughes Kathryn G · Council, IDBuilt 1963 · S/N CD-693N143MDEgnazia Plane LLC · Miami, FLBuilt 2025 · S/N 10440N143MGPatriot Air Inc · Maryland Heights, MOS/N 310K0134N143PBHemdmm Corp · Wilmington, DEBuilt 1977 · S/N 28R-7703243N143PDSouder James B · Port Orange, FLBuilt 1953 · S/N 53-4134N143PMStorm Aviation LLC · Sacramento, CABuilt 2020 · S/N 2085N143RJDelta Tango Aviation LLC · Saint Louis, MOBuilt 2003 · S/N 1276N143RMOft7 LLC · Ponca, ARBuilt 1975 · S/N 18263650N143RSKidwell Aviation LLC · Apopka, FLBuilt 2020 · S/N 2219N143SBRegistered aircraftBuilt 2012 · S/N 2219N143SGPalm Tree Aloha Aviation LLC · Cameron Park, CABuilt 2026 · S/N 11514N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064N143TERegistered aircraftBuilt 2007 · S/N 1884N143TMSchnautz Danny R · Pasadena, TXBuilt 2000 · S/N 29-0242N143TTJ&W Outdoors LLC · Modesto, CABuilt 2010 · S/N 411154N143VBBurke Farm Management Service Inc · Waynesboro, GABuilt 2017 · S/N T24002143N143WWNielsen Mark Andrew Trustee · Pagosa Springs, COBuilt 2018 · S/N 1734N143XAllman Gary · Charlotte, NCBuilt 1960 · S/N CD-147
Back to AD 2000-23-21