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.

N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468N14690Davis Scott · Morse, TXBuilt 1973 · S/N 74-30637N14691Weakley Robert Kayce · Pleasant View, TNS/N 74-30682N14695Johnson Charles E · Vernon, TXBuilt 1974 · S/N 74-30688N1469FSkywagon 185 LLC · Ocala, FLBuilt 1975 · S/N 18502847N1469SS & J Farms · Floydada, TXBuilt 1976 · S/N 18265016N1469WIrwin Alfred Homer · Lizella, GABuilt 2007 · S/N 41733N146ACUnited States Air Force Owner · Usaf Academy, COBuilt 1967 · S/N R1720147N146BPNoughton Larry W · Fort Myers, FLBuilt 1994 · S/N CE-1775N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057N146CPlanes & Parts Inc · Weston, FLBuilt 1964 · S/N TC-599N146DMValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 10233N146EN146e LLC · Thomasville, GABuilt 1982 · S/N 18268292N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247N146GSKyser LLC · Wilmington, DEBuilt 2007 · S/N 2393N146JJValiair Ltd Co Trustee · Casper, WYBuilt 2002 · S/N 1265N146LLRichard Richard D · Broussard, LABuilt 2009 · S/N 222N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032N146SBN146sb LLC · Vienna, VABuilt 2007 · S/N 2574N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176N146VBHappyface246vb LLC · Hollywood, FLBuilt 2018 · S/N T24002146N146WTLevanders Aircraft II LLC · Grand Island, NEBuilt 2002 · S/N 0324N146YBayer Peter D · Naperville, ILBuilt 1955 · S/N 32098N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N146ZFNo Boundry Airplane LLC · Council Bluffs, IABuilt 1984 · S/N 46-8408002N14705Bernath Robert J · Saint Johns, FLBuilt 1974 · S/N 74-30668N14706Carter Delton W · Sumner, TXS/N 74-30716N14709Godfrey Lawrence J · Leucadia, CABuilt 1973 · S/N 74-30650N1470GBaker Dennis J · Shipman, ILS/N CD-465N1470QHillyer Joe F · Soldotna, AKBuilt 1977 · S/N 18503483N14721Mcdonald Trading Post Inc · Plainview, TXBuilt 1973 · S/N 74-30647N14729Heard Terrell · Amarillo, TXBuilt 1974 · S/N 74-30707N14732Robson Thomas A · Mcdonough, GABuilt 1974 · S/N 75-30756N14736Stern Gerald W · Ft Worth, TXBuilt 1974 · S/N 74-30703N14738Stern Gerald W · Fort Worth, TXBuilt 1974 · S/N 74-30694N1473FSilveira Paul J · Valdez, AKS/N 18502851N1473KTailwinds Aviation LLC · Punta Gorda, FLBuilt 2007 · S/N 41773N1473M182p LLC · Oklahoma City, OKBuilt 1975 · S/N 18264340N1473SBattin Robert C · Cartersville, GABuilt 1976 · S/N 18265020N14740Coleman Edward H · Tulare, CABuilt 1973 · S/N 74-30642N14744Trimble Anthony W · Weatherford, TXS/N 74-30630N14745Rockwell Donnal E · Ozona, TXBuilt 1973 · S/N 74-30656N14751Maiorka Kevin D · Lockhart, TXBuilt 1974 · S/N 74-30666N14754Registration Pending · Clarkston, MIRegistration pendingBuilt 1975 · S/N 75-30765N1475FAc Group LLC · Helena, MTBuilt 1975 · S/N 18502853N1475SMurdoch-Haig Alexandra · Kailua, HIBuilt 1976 · S/N 18265022N1476251 Adventures LLC · East Montpelier, VTS/N 74-30649N14764Bl14764 LLC · Homer, LABuilt 1974 · S/N 74-30701N1476SBk1 Farms LLC · Rock Port, MOBuilt 1976 · S/N 18265023N14771Shiner Aviation LLC · Georgetown, TXBuilt 1974 · S/N 75-30732
Back to AD 2000-23-21