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.

N28FXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N TH-2126N28HPFrowe Robert E · Lake Dallas, TXBuilt 1975 · S/N TC-1924N28HWRuthie 54 LLC · Logan, UTBuilt 2022 · S/N 8663N28JEWallace Coke W · Healy, AKS/N 18502911N28JGStrathy Gregg M Trustee · Eugene, ORBuilt 2015 · S/N 1130N28JMWestern Aviation Services LLC · Cheyenne, WYBuilt 1979 · S/N P21000431N28KGValiair Limited Co Trustee · Casper, WYBuilt 2023 · S/N 9067N28KLWright Thomas R · Arlington, WABuilt 2010 · S/N 70025N28KYSoldo Joseph Peter · Chattanooga, TNBuilt 1984 · S/N 468508015N28LDDancing Bear LLC · Polson, MTBuilt 1970 · S/N D-9205N28LEGlenn Scott A · Overland Park, KSBuilt 1976 · S/N 28R-7635253N28LFBaker Timothy Scott · Shreveport, LABuilt 1973 · S/N 18261898N28LVCactus Clover Inc · El Paso, TXBuilt 1979 · S/N 340A0754N28MGHudson Equipment LLC · Camden, DEBuilt 1988 · S/N TH-1535N28NTHammock Flying Service Inc · Black Rock, ARBuilt 1975 · S/N 310R0243N28NWFixed Gear Sportsman LLC · Seattle, WABuilt 2017 · S/N 4540N28PCGriesman Scott W · Sandy Valley, NVBuilt 1967 · S/N 377N28PDBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 41776N28PFOcf Air LLC · Phoenix, AZBuilt 2011 · S/N 2085N28PWGoodnight Ranch Co · Englewood, KSBuilt 1965 · S/N 18256064N28RLTbda LLC · Wilmington, DEBuilt 2019 · S/N 1965N28RSElohim Airparts Sales LLC · Naples, FLBuilt 1970 · S/N 21059316N28SCDouville Kenneth · Derry, NHBuilt 2001 · S/N 1137N28SNAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2018 · S/N 1729N28SPCactus Aviation LLC · Pleasanton, CABuilt 2025 · S/N 10704N28SWShiftta LLC · Ramrod Key, FLBuilt 1979 · S/N 28R-7931308N28TDGravity2 LLC · Ramsey, NJBuilt 2025 · S/N 10733N28TJNational Marketing And Management Services LLC · Clyde Park, MTBuilt 1979 · S/N TC-2218N28TKLos Cielos Flyers LLC · San Antonio, TXBuilt 2002 · S/N 0263N28UMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9798N28VTOwens Curtis R Jr · Jourdanton, TXBuilt 1978 · S/N TC-2184N28WBMulder Air Inc · Renville, MNBuilt 1968 · S/N D-8729N29000Bevins William Brian · Phoenix, AZBuilt 1967 · S/N U206-1000N29002E A B Services LLC · Cape Coral, FLBuilt 1972 · S/N 21059777N29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLS/N 21059778N2900ATct Aerial LLC · Waukesha, WIBuilt 1953 · S/N 30100N2900FSciathan LLC · Grosse Pointe, MIBuilt 1966 · S/N 18257000N2900TEwing Richard Jr · Antelope, CABuilt 1966 · S/N 301N2900YPittman John A · Gainesville, GABuilt 1962 · S/N 18253900N29018Pacific Rim Energy Inc · Henderson, NVBuilt 1967 · S/N U206-1014N2901CBright J Tobias · Seattle, WABuilt 1954 · S/N 30801N2901KFramptom Joseph B · Little Rock, ARBuilt 1979 · S/N 18053124N2901LStraight & Level Aviation LLC · Bradenton, FLBuilt 1980 · S/N TH-1172N2901RBerry & Sons Trucking LLC · Eufaula, OKBuilt 1962 · S/N 310G0101N2902N2902 LLC · Miami, FLBuilt 1977 · S/N U20603637N29022Unifly Inc · Lackawanna, NYBuilt 1972 · S/N 21059783N29027Cb Aerosports Inc · Charlotte, NCS/N 28R-7931188N2902AMurray Kevin D · Moneta, VABuilt 1953 · S/N 30102N2902CPhil Ruhnke Construction Inc · Grangeville, IDBuilt 1954 · S/N 30802N2902KRafter J Aviation LLC · Moab, UTS/N 18053125
Back to AD 2000-23-21