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.

N324ZHannon Jim H · Cumming, GABuilt 1960 · S/N D-6478N3250U50 Uniform LLC · Traverse City, MIBuilt 1963 · S/N 18254650N3250YEonm182 LLC · El Paso, TXBuilt 1962 · S/N 18254250N3251DE S P Aviation LLC · Wilmington, DES/N 32049N3251WCorporate Flight Mangement LLC · Dallas, TXBuilt 1995 · S/N EA-576N3251YCarlson Andrew J · Ashville, NYBuilt 1962 · S/N 18254251N3252DQuigg Aircraft LLC · Muskegon, MIBuilt 1955 · S/N 32050N3252JBas Part Sales LLC · Greeley, COS/N E-3252N3252REllis Eric Lee Trustee · Lincoln, CABuilt 1995 · S/N E-2952N3252SWhite Robert E · Woodlawn, TNBuilt 1964 · S/N 18255752N3253KWarbird Adventures Inc · Ocoee, FLS/N 1246N3253SCobb Darrell V · Corsicana, TXBuilt 1964 · S/N 18255753N3254GEdling Tyrell R · The Dalles, ORBuilt 1995 · S/N E-2954N3254SAllen John C · Austerlitz, NYBuilt 1964 · S/N 18255754N3254UWright Ronald J · Olympia, WABuilt 1963 · S/N 18254654N32555Harvest Aviation · Wauchula, FLBuilt 1974 · S/N 34-7570032N3255GSmith Julian Scott · Arlington, TXS/N 24531N3256QManzella Aviation LLC · Brandon, FLBuilt 1977 · S/N 28R-7703098N3256YCowden Mark T · Kerrville, TXBuilt 1962 · S/N 18254256N3257DAlaska Dall Sheep Guides LLC · Anchorage, AKBuilt 1955 · S/N 32055N3257SFelton Frank B III · Thorndale, TXBuilt 1964 · S/N 18255757N3257XN1002q LLC · Lake Butler, FLFirst renewal noticeBuilt 1967 · S/N 310L-0107N3257YGilbert Donald L Jr · Ligonier, PABuilt 1962 · S/N 18254257N3258SRockwood Spa LLC · Houston, MOBuilt 1964 · S/N 18255758N3258XWrenn William H · Baytown, TXFirst renewal noticeS/N 310L-0108N3258YByra Paula A · Pagosa Springs, COS/N 18254258N3259DLutes Stacy J · Mooresville, NCBuilt 1955 · S/N 32057N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215N3259UMoore Christopher · Canton, PABuilt 1963 · S/N 18254659N3259YGrantham William Edward · Doerun, GAS/N 18254259N325A325a LLC · Lecanto, FLBuilt 2006 · S/N 2150N325BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2273N325CDAtoco LLC · Baxley, GABuilt 2016 · S/N 1364N325CLRobin Motorsports And Aviation LLC · Windermere, FLBuilt 2008 · S/N 3061N325CPRachke Aviation LLC · Gardner, ILBuilt 2008 · S/N 3246N325CSEcho Zulu LLC · Bend, ORFirst renewal noticeBuilt 2016 · S/N T24002103N325DCGmg Aviation LLC · Ehrhardt, SCBuilt 1981 · S/N TH-1292N325DDQuick Michael D · Middletown, CAS/N 21062748N325FGoldberg William Trustee · Telluride, COBuilt 2023 · S/N 9449N325HLHl Ventures LLC · Los Altos, CABuilt 2016 · S/N 1327N325JWKlug Transport Inc · Farmington, MOBuilt 2012 · S/N TH-2340N325KCMount Wilson Holdings LLC · Orange, CABuilt 1981 · S/N 414A0825N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990N325PGGuenther Enterprises LLC · Mission Viejo, CABuilt 2021 · S/N 2429N325PRBt Capital Assets II LLC · Saint Joseph, MOBuilt 2017 · S/N 1644N325RPN325rp Corp · Willow Spring, NCBuilt 1985 · S/N P21000848N325SHSsh Aero LLC · Saint Louis, MOBuilt 2022 · S/N 8660N325SKInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 41528N325SRFingerhut Steven · Cross Plains, TXBuilt 1966 · S/N TE-65N325TSMorning Flight LLC · Woodbridge, VABuilt 2006 · S/N 41589
Back to AD 2000-23-21