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.

N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003N2582PTriple A Aviation LLC · Plano, TXBuilt 2026 · S/N E-4166N2582Q82q LLC · Glenwood, MDS/N 18257782N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786N2587SFlying Tater LLC · Toms River, NJBuilt 1968 · S/N 337-0887N2588QDlp Ventures LLC · North Platte, NEBuilt 1977 · S/N 28R-7703070N2588RPoplin Tristan · Frisco, TXBuilt 1967 · S/N 18258288N2588ZBindon Philip E · Wasilla, AKBuilt 1963 · S/N 185-0588N2589GPreisse Gene L Jr · Akron, OHBuilt 1959 · S/N 51889N2589QMolek Eugene · Warren, OHS/N 18257789N258BBGhanimian Zaven · Encino, CABuilt 1977 · S/N TH-892N258CDWyman Michael J · Greenville, SCBuilt 2002 · S/N 1186N258CPAll Furniture Services LLC · Cliffside Park, NJBuilt 2006 · S/N 1744N258CWKpj Aviation LLC · West Palm Beach, FLBuilt 2024 · S/N 10107N258DTwin Engine Express LLC · Lewes, DEBuilt 1995 · S/N TH-1740N258ESanogo Fousseni · Houston, TXBuilt 1964 · S/N TC-701N258FDFertilizer Company Of Arizona Inc · Casa Grande, AZBuilt 2024 · S/N 9884N258HP1544 Aviation Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1544N258JSNational Biomechanics Institute LLC · Santa Monica, CABuilt 2015 · S/N 2275N258KJBcr Investments LLC · Wilmington, DEBuilt 2018 · S/N 4628N258MTK5 Aviation LLC · Lewes, DES/N TH-244N258NCFidelis Flight Group Inc · Elm Springs, ARBuilt 1978 · S/N TH899N258PChamberlin Charles · Winchester, TNBuilt 1981 · S/N TC-2414N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737N258SAEmv Properties LLC · Ponce, PRBuilt 2008 · S/N TH-2224N258STPanchjanyam LLC · Jackson, MSBuilt 2002 · S/N 0307N258TCDunn Mark A · Lufkin, TXBuilt 1966 · S/N D-8351N258TFHands Services Inc · Malibu, CABuilt 2011 · S/N 0231N258TNKrause Jason · Glendale, AZBuilt 1988 · S/N TH-1539N258WTTrigger Air LLC · Wilmington, DEBuilt 2014 · S/N 4152N259Clark Jack E Jr · Mesa, AZFirst renewal noticeBuilt 1975 · S/N P337-0220N2590KHilltop Aviation Group LLC · Jay, MEBuilt 1978 · S/N 18053006N2590RMason John A · Scottsdale, AZBuilt 1967 · S/N 18258290N2591QDeadmond Matthew J · Princeton, CABuilt 1966 · S/N 18257791N2591TFerguson John W · Edwardsburg, MIBuilt 1975 · S/N U20602594N2592GLeft Heading LLC · Herriman, UTBuilt 1959 · S/N 51892N2592XLorraines Blue Sky Aviation LLC · Norman, OKBuilt 1965 · S/N P206-0092N2593GIntelinair Geospatial LLC · Indianapolis, INBuilt 1958 · S/N 51893N2593QRigoni Teresa Ann · Orting, WABuilt 1966 · S/N 18257793
Back to AD 2000-23-21