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.

N265KJCirrus Sr22t 2307 Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2307N265MBFlying Brick LLC · Monroe, NCBuilt 2024 · S/N 10163N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996N265SBCs Aero LLC · Nassau, DEBuilt 2016 · S/N 1462N265TEagle Aviation Columbia LLC · West Columbia, SCBuilt 2006 · S/N 1722N265TGRegistration Pending · Darnestown, MDRegistration pendingBuilt 2022 · S/N 8940N2660Applegate Land Holdings LLC · Jacksonville, ORBuilt 1981 · S/N 18268100N26601Trowbridge Rodney L · Haysville, KSBuilt 1968 · S/N 18259083N2660FWheels Up Aviation Inc · Lewes, DES/N 18256760N2660GFruge Cory · Egan, LABuilt 1959 · S/N 51960N2660RPa Bo Ma Inc · Alexandria, LABuilt 1967 · S/N 18258360N2660YRam Aviation LLC · Palmer, AKBuilt 1962 · S/N 18051160N2661ABerry Scott F · Destin, FLBuilt 1968 · S/N 18259102N2661QAlred Robert I · Barrow, AKBuilt 1966 · S/N 18257861N2661YAlaska Outdoor Consultants LLC · King Salmon, AKBuilt 1962 · S/N 18051161N2662GWhitman Monty · Pagosa Springs, COBuilt 1959 · S/N 51962N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162N2663QBerg Weston L · Stanton, NDBuilt 1966 · S/N 18257863N2663SMaclean Kenneth J · Northborough, MABuilt 1968 · S/N 337-0963N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195N2664FWisconsin Aviation Inc · Watertown, WIBuilt 1980 · S/N 414A0534N2664LAce Airways LLC · Quincy, WABuilt 1980 · S/N 414A0535N2664MInfcon LLC · Wilmington, DEFirst renewal noticeS/N E-2317N2664SMcclain Daniel S · Enon Valley, PABuilt 1968 · S/N 337-0964N2666GForward Logistics LLC · New Castle, VAFirst renewal noticeBuilt 1959 · S/N 51966N2666QCloos Randy J · Osburne, IDBuilt 1966 · S/N 18257866N2666SHageness Hartley · Rugby, NDBuilt 1968 · S/N 337-0966N2667Marlow Air LLC · Gilmanton Iw, NHBuilt 1965 · S/N D-7997N2667BBellanca Flyer Inc · Winter Garden, FLBuilt 1988 · S/N 89-301002N2667FVan Hooser Barry S · Pleasanton, CABuilt 1965 · S/N 18256767N2667GTundra Aviation Inc · Casselton, NDS/N 51967N2667MYce Consulting Inc · Easton, PABuilt 1989 · S/N 89-301008N2667RJorgensen Larry C · Randle, WABuilt 1967 · S/N 18258367N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347N2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 421C1216N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768N2668GGospel Ministries International · Mc Donald, TNBuilt 1959 · S/N 51968N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368N26692Fields Douglas P Jr · Brooklyn, NYBuilt 1979 · S/N 310R1849N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735N2669QBanks Ron E · Blanchard, OKBuilt 1966 · S/N 18257869N2669RStrubhar Wesley D · Foster, ORBuilt 1967 · S/N 18258369N2669SWilliams Kent A Jr · Kissimmee, FLBuilt 1968 · S/N 337-0969N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169N2669YHession Mark A · Arrington, TNBuilt 1962 · S/N 18051169N266BNPinckney Michael M DBA · Pensacola, FLBuilt 1988 · S/N 89-301001N266GSchroeder Robert J · Kaukauna, WIBuilt 1966 · S/N TE-205N266HRegistered aircraftBuilt 2008 · S/N E-3877N266JDJ D Deboskey Inc · Palm Beach Gardens, FLS/N G-810
Back to AD 2000-23-21