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.

N2562QStiles Thomas W · Pocahontas, ILBuilt 1966 · S/N 18257762N2562RKehler Grain & Livestock · Saint Xavier, MTBuilt 1967 · S/N 18258262N25632Struck Larry G · Gardnerville, NVS/N D-9435N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330N2563ZWien Richard A · Fairbanks, AKBuilt 1963 · S/N 185-0563N25642Pester Jerome B · Hingham, MTBuilt 1973 · S/N CE-457N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301N2564GGarrison Jeffrey R · Clemson, SCBuilt 1959 · S/N 51864N2564RBusse William J · Twin Lakes, WIBuilt 1967 · S/N 18258264N2564ZDownwind Aviation LLC · Kodiak, AKBuilt 1963 · S/N 185-0564N25659Greenery LLC · Wilmington, DEBuilt 1973 · S/N TC-1596N2565GMoore Timothy L · Wendell, IDBuilt 1959 · S/N 51865N2565RSanders David D · Alvin, TXBuilt 1967 · S/N 18258265N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522N25665Franks Bryan · Camarillo, CABuilt 1973 · S/N CE-459N25667Bushnell Alison M · Phelan, CABuilt 1973 · S/N E-468N2566RRastetter Harold · Douglaston, NYBuilt 1967 · S/N 18258266N25675Todd James Michael · Angleton, TXBuilt 1973 · S/N E-472N25676Ciabattoni David E · Wallingford, PABuilt 1973 · S/N TC-1597N2567GSunrise Exploration Inc · Northport, WABuilt 1959 · S/N 51867N2567KBryant Kenneth D · Black Diamond, WABuilt 1978 · S/N 18052990N2567RGone Flying LLC · Loveland, OHBuilt 1967 · S/N 18258267N2567VHarness Ben · Covelo, CAFirst renewal noticeBuilt 1976 · S/N R1722223N25681Heli-Ventures Inc · Wilmington, DEBuilt 1973 · S/N CE-460N2568GKoechen Wayne L · Cooper Landing, AKBuilt 1959 · S/N 51868N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068N25691Marty Daniel A · Birmingham, ALBuilt 1973 · S/N CE-462N25698Tupelo Aeronautics Inc · Tupelo, MSS/N TC-1603N2569KHarris Curtis M · Anchorage, AKS/N 18052991N2569SMatanane Roke C · Barrigada, GUBuilt 1968 · S/N 337-0869N2569ZEitilt Aviation LLC · Parker, COBuilt 1963 · S/N 185-0569N256AWHampton Brewing Company LLC · Panama City, FLBuilt 2009 · S/N 3465N256BVBarnstormer Ventures LLC · Rye Brook, NYBuilt 2023 · S/N 9195N256CAHyannis Air Service Inc · Hyannis, MAS/N 402C0606N256CDValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 9775N256DBNortheastern Gastroenterology Associates Pa · Summit Hill, PABuilt 1998 · S/N E-3081N256DWN256dw LLC · Orlando, FLBuilt 2010 · S/N E-3926N256GRRicciotti Gerard · Annapolis, MDBuilt 1956 · S/N G-754N256LCInternational Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N 3858N256MALem Air LLC · Redmond, ORS/N LIV-461N256MDVolantem Machina LLC · Bakersfield, CABuilt 2011 · S/N 2121N256NNichols Richard C · Port Orange, FLS/N BG-398N256PTBaron Aviation Inc Trustee · Wilmington, DEBuilt 2013 · S/N TH-2350N256SG6 LLC · Ocala, FLBuilt 2026 · S/N 11160N256SJSan Juan Aviation LLC · Wilmington, DEBuilt 1979 · S/N R1723166N256SKMach Aviation LLC · Ocklawaha, FLBuilt 2021 · S/N 2428N256SRUnder The Red Sky LLC · Champaign, ILBuilt 2007 · S/N 2553N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336N256VMCode Air LLC · Oklahoma City, OKS/N 0887
Back to AD 2000-23-21