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.

N225XGomez Miguel W · Livermore, CABuilt 1957 · S/N D-5032N225YZYankee Zulu LLC · New York, NYBuilt 2015 · S/N 2291N22604Tarten Air Inc · Smiths Creek, MIBuilt 1978 · S/N E-1287N2260GJump Tn LLC · Greeneville, TNBuilt 1958 · S/N 51560N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204N2261CGandy John W III · Mt Vernon, TXBuilt 1953 · S/N 30561N2261LGaf Skyborne Aviation Ventures LLC · El Dorado Hills, CABuilt 1979 · S/N E-1535N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206N2262TMarsh John E · Washington, DCBuilt 1968 · S/N 185-1420N2262XStampfler Richard D · Groveland, MABuilt 1965 · S/N 337-0162N2263CWalker William S · Shallotte, NCBuilt 1953 · S/N 30563N2264GMessner Mark R · Chesapeake, OHBuilt 1958 · S/N 51564N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767N2265FRegistration Pending · Wilmington, DERegistration pendingBuilt 1967 · S/N 310L-0065N2265GWilder James S · Eagle, IDBuilt 1958 · S/N 51565N2266FTechnical Education Services Inc · Virginia Beach, VAS/N 310L-0066N2266SWeekend Air LLC · Incline Village, NVBuilt 1976 · S/N 21061210N2266XBarney Julius C · Lutz, FLBuilt 1965 · S/N 337-0166N2267AWilson Ronald W · Bluffton, SCBuilt 1969 · S/N D-9027N2267XRound Engine Aero · Nashville, MIBuilt 1965 · S/N 337-0167N2268CCozach LLC · Wilmington, DEBuilt 1982 · S/N T30300081N2268FKephart Peter J · Washington, MOBuilt 1966 · S/N 310L-0068N2268MMorgan Kinder LLC · Friendswood, TXBuilt 2003 · S/N 0642N226ACTitle 46 LLC · Hamilton, MTBuilt 1979 · S/N 18267019N226BBurton Robert B · New York, NYBuilt 1977 · S/N 21061701N226BBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 3426N226BCBrown John D · Parkersburg, WVBuilt 2006 · S/N 1826N226BGMahoney Timothy P · Nantucket, MABuilt 2004 · S/N 0837N226BRValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10662N226CHyland Nathan W · Queen Creek, AZBuilt 1979 · S/N 25-0034N226CDHughes William · Woodstock, ILBuilt 2001 · S/N 1130N226CFWendler William F II · Bridgton, MEBuilt 2021 · S/N 4994N226CHDraper Michael John · Chenoa, ILBuilt 2004 · S/N 0875N226CRBentley Mooney LLC · Seattle, WAS/N 25-0570N226FDBlue Mountain Aviation LLC · Newark, DEBuilt 2023 · S/N 9105N226HPRegistration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N 414A0084N226JHAmeritech Flight Services LLC · Hummelstown, PABuilt 2009 · S/N 3443N226JTTerrell Jeffrey L · Clear Lake Shores, TXBuilt 1969 · S/N 18259919N226KBBex Investments LLC · Oklahoma City, OKS/N 4746N226LMSun Star Aviation LLC · Oshkosh, WIBuilt 2002 · S/N 3449270N226LPLetourneau Plastics Inc · Oconto, WIBuilt 2014 · S/N TH-2409N226MASum Beech Inc · Knoxville, TNS/N CE-641N226MLSierra Kilo Capital Holdings LLC · Arvada, COBuilt 2020 · S/N 2052N226MMKdf Air LLC · Missoula, MTBuilt 2020 · S/N 2138N226NSdj LLC · Mercer Way, WABuilt 2024 · S/N 9854N226PKCirrus Design Corp · Knoxville, TNBuilt 2016 · S/N 1471N226PMClrmet Partners LLC · Lindon, UTBuilt 2019 · S/N 1868N226RHHarding Christopher · Houston, TXBuilt 2006 · S/N 2290N226RPGlory Fly LLC · Waxhaw, NCBuilt 2018 · S/N E-4114N226SBSb Sierra Partners LLC · Santa Barbara, CABuilt 2022 · S/N 8549
Back to AD 2000-23-21