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.

N2056MSteele Shelly Sam · Spicewood, TXBuilt 1977 · S/N 28R-7803102N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023N2056XWhite Christy · Wichita, KSBuilt 1965 · S/N 18256156N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247N2057ADesruisseaux Kemens · Clarksville, TNBuilt 1978 · S/N E-1420N2057GDau William K · Palmer, AKFirst renewal noticeBuilt 1958 · S/N 51357N2057MSeintec Corp · Aventura, FLBuilt 1977 · S/N 28R-7803103N2057XLewis Tommy · Winnsboro, TXBuilt 1965 · S/N 18256157N2058AFlying J Aviation LLC · Lynden, WABuilt 1979 · S/N TC-2201N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85N2058GPiercy Mark W · Lubbock, TXBuilt 1958 · S/N 51358N2058WSweet Fred A · Loves Park, ILS/N D-8192N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159N2059WMorgan Jeffrey B · Edgewater, FLBuilt 1965 · S/N D-7993N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994N205AAHzl Hanger LLC · Drums, PAS/N 205-0453N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516N205ASTurnbull Moak & Pendergrass LLC · Birmingham, ALBuilt 2023 · S/N 9344N205AWLee Kevin B · Beulah, NDBuilt 1963 · S/N 205-0522N205BBHixon George S · San Antonio, TXBuilt 1962 · S/N 205-0060N205BFWells David L · Neosho, MOBuilt 2005 · S/N 29-0386N205BPRegistered aircraftBuilt 1962 · S/N 205-0089N205BZEmbedded Advantage LLC · Chelsea, MIBuilt 2005 · S/N 29-0411N205CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0207N205CDNuclear Speed Inc · Emerald Hills, CABuilt 2023 · S/N 9145N205CLFreedenberg Philip J · Canton, CTBuilt 1963 · S/N 205-0452N205CRRlh Montana LLC · Helena, MTBuilt 1963 · S/N 205-0286N205CTBas Part Sales LLC · Greeley, COS/N 205-0226N205ECEsa Aviation LLC · Lemont, ILBuilt 2012 · S/N 2127N205FBennett James G · Erie, COBuilt 1964 · S/N 205-0573N205FJPilots Nw Inc · Bellingham, WABuilt 1962 · S/N 205-0050N205HNTischer Jesse · Des Moines, IABuilt 1963 · S/N 205-0440N205JNHand Patrick · Cape Charles, VABuilt 1967 · S/N 18258437N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286N205LSky King Airplanes LLC · Lewes, DEBuilt 1963 · S/N 205-0329N205LBLima Bravo Holdings LLC · Powell, OHBuilt 2012 · S/N 2216N205NBAirmotive Service LLC · Brigham City, UTBuilt 1962 · S/N 205-0151N205NDThompson Shane E · Warroad, MNBuilt 1966 · S/N 18051744N205NRState Of Minnesota · Grand Rapids, MNBuilt 1981 · S/N 18504317N205PMHochstetler Allen D · Fairfield, CABuilt 1964 · S/N D-7599N205RTTriple D Cessna LLC · Greenville, SCBuilt 1962 · S/N 205-0014N205SC5sc LLC · Bismarck, NDBuilt 2025 · S/N 10630N205WHJp Real Estate Management Inc · Van Nuys, CABuilt 2020 · S/N 2051N205ZDBibb James M · Citrus Heights, CABuilt 1979 · S/N 28-7921084N206Gaines Robert M · Nashville, TNBuilt 1948 · S/N 1-053N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173N20603Burlington Air Center Inc · Burlington, WIBuilt 1978 · S/N D-10207N20605Registration Pending · Escondido, CARegistration pendingBuilt 1981 · S/N 18053199
Back to AD 2000-23-21