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.

N2434FHanson Inc · Kalispell, MTS/N 18051634N2434XJensen Shaun V · Anchorage, AKBuilt 1965 · S/N 18256334N2435ACooper Timothy J · Spearman, TXBuilt 1969 · S/N D-9036N2435FBas Part Sales LLC · Greeley, COS/N 180-51635N2435GVoninski John R · Manlius, NYS/N 51735N2435QVolare Aviation LLC · Wylie, TXBuilt 1966 · S/N 18257635N24365Zaisan Group LLC · Las Vegas, NVBuilt 2018 · S/N 1764N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736N2436GDk Futures LLC · Reno, NVBuilt 1959 · S/N 51736N2436RSilva Gary · Yerington, NVBuilt 1964 · S/N 18255536N2436SCranney Dan Gordon · Sevier, UTBuilt 1967 · S/N 337-0736N2436TFriesen Gregory J · Evansville, WYBuilt 1962 · S/N NAV-4-2436N2437CFogleman Brian L · Stonewall, LAS/N 30737N2437FKuersten Robert S · Middleton, WIBuilt 1965 · S/N 18051637N2437RBlackwelder John W · Columbia, KYBuilt 1964 · S/N 18255537N2437TWilson Matthew · Adrian, MIS/N NAV-4-2437N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782N2437XLudke Arnold · Oakland, NJBuilt 1965 · S/N 18256337N2438GWk Aviation LLC · Buffalo, SDBuilt 1959 · S/N 51738N2438XRousser Cattle LLC · Amarillo, TXBuilt 1965 · S/N 18256338N2439GJ+J Electric LLC · Seminole, TXBuilt 1959 · S/N 51739N2439XAlpha Aero LLC · Biddle, MTBuilt 1965 · S/N 18256339N243CDSojourn Flight LLC · Rapid City, SDBuilt 2002 · S/N 1252N243CHHartz C M · Key Largo, FLS/N 3369N243EHeads Steel Service Inc · Portland, TNBuilt 2024 · S/N 9848N243JBS & W Air LLC · Lawndale, CABuilt 2016 · S/N 1406N243LPKeaton Josh Trustee · Grants Pass, ORBuilt 2026 · S/N 11489N243MBSwanson Timothy J · Bannister, MIBuilt 1967 · S/N 337-0813N243RWN243rw LLC · Dayton, OHBuilt 2023 · S/N 9320N243RZBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1983 · S/N 21064961N243SRNational Test Pilot School · Mojave, CABuilt 2006 · S/N 2043N243WERap Aviation LLC · Dalhart, TXBuilt 2018 · S/N 1785N243WTWdt Aviation LLC · Colonial Beach, VABuilt 2024 · S/N 10164N2441RBelly Acres Capital And Management LLC · Memphis, TNBuilt 1964 · S/N 18255541N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284N2441TSelzer William J · Newaygo, MIBuilt 1962 · S/N NAV-4-2441N2442CRoberts Calvin · Bluebell, UTBuilt 1954 · S/N 30742N2442GRegistration Pending · King Salmon, AKRegistration pendingBuilt 1959 · S/N 51742N2442TBrooks Samuel A · Germantown, TNS/N NAV-4-2442N2443QHolcomb Aviation LLC · Middleton, IDS/N 18257643N2443RYoung David E · Wasilla, AKBuilt 1964 · S/N 18255543N2443SGill Robert S · Prudhoe Bay, AKFirst renewal noticeBuilt 1967 · S/N 337-0743N2443TN2443t LLC · High Springs, FLBuilt 1962 · S/N NAV-4-2443N2444GDurbin Brian · Lone Tree, COBuilt 1959 · S/N 51744N2444QBristow Christopher W · Fairfield, TXBuilt 1966 · S/N 18257644N2444RClancy Michael · Rifle, COBuilt 1964 · S/N 18255544N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345N2446CGolike Timothy R · Anchorage, AKBuilt 1954 · S/N 30746N2446GAcute Holdings LLC · Jenks, OKBuilt 1959 · S/N 51746
Back to AD 2000-23-21