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.

N2781JRussell Scott M · Sanger, TXBuilt 1969 · S/N 18501531N2781QGibboney Phillip M · Roseville, CABuilt 1967 · S/N 18257981N2781XN2781x LLC · Kingston, GABuilt 1965 · S/N 18051581N2782FMansoori Ali S · Aurora, COBuilt 1965 · S/N 18256882N2782QBauer Aviation LLC · Reese, MIBuilt 1967 · S/N 18257982N2783FVspp Consulting LLC · Stevensville, MDBuilt 1966 · S/N 18256883N2783GLarue Terrence W · Ellensburg, WABuilt 1959 · S/N 52083N2783TCloud 9 Aviators LLC · Anchorage, AKBuilt 1981 · S/N 18504350N2784GFlaps Up LLC · Kaysville, UTBuilt 1959 · S/N 52084N2784TVerastegui Emilio F III · Albuquerque, NMBuilt 1967 · S/N D-8489N2784XGillett Welles III · Horseheads, NYBuilt 1965 · S/N 18051584N2785FAugustin Lyn H · Saint Thomas, NDBuilt 1966 · S/N 18256885N2785JDurtschi Steven R · Centerville, UTBuilt 1969 · S/N 185-1535N2785KPontiac Flying LLC · Pontiac, ILBuilt 1979 · S/N 18053067N2785TPatin Carey · New Roads, LABuilt 1967 · S/N D-8501N2786FChristoph Nicolas T · Okanogan, WABuilt 1966 · S/N 18256886N2786GAvery John W · Fergus Falls, MNFirst renewal noticeBuilt 1959 · S/N 52086N2786SCake Aviation LLC · Mcgregor, MNBuilt 2018 · S/N 1780N2786XRegistered aircraftBuilt 1965 · S/N 18051586N2787AKnudson Erik · Chandler, AZBuilt 1969 · S/N E-178N2787FWammen Gil V · Reva, SDBuilt 1966 · S/N 18256887N2787GGomez Bermudex Investments LLC · Lauderhill, FLS/N 52087N2787JLarson Jared E · Wasilla, AKBuilt 1969 · S/N 185-1537N2787KWhirlwind Aviation Inc · Fisher, ARBuilt 1979 · S/N 18053068N2787QThorell Farms Inc · Loomis, NES/N 18257987N2787TBombero Aviation LLC · Childress, TXBuilt 1967 · S/N TE-388N2788FShryock Patrick D · King Salmon, AKS/N 18256888N2788GCaldwell Gregg P · Desert Hot Springs, CABuilt 1959 · S/N 52088N2788QKahle Matthew N · Paw Paw, MIBuilt 1967 · S/N 18257988N2788THarnden Craig A · Lake City, FLBuilt 1967 · S/N CE-154N2789FHouck Joshua B · Wa Ct House, OHS/N 18256889N2789QCenterline LLC · Yankton, SDBuilt 1967 · S/N 18257989N2789TLaycock Sean P · Plymouth, MIBuilt 1967 · S/N D-8483N278AZLef278az LLC · San Angelo, TXBuilt 2022 · S/N 8716N278CDCirrus Aviators LLC · Elm Grove, WIBuilt 2002 · S/N 0337N278CFInfinity Aviation LLC · Mandan, NDBuilt 1981 · S/N 18504228N278CRRittgers Timothy · Lapeer, MIBuilt 1986 · S/N CE-1089N278DBCt42 LLC · New York, NYS/N 29-0301N278ECAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 41745N278EHE&H Aviation LLC · Kennesaw, GABuilt 2020 · S/N 2114N278GTankersley Aviation LLC · Sylacauga, ALBuilt 1979 · S/N E-1547N278GZNichols Industrial Construction Co Inc · Birmingham, ALBuilt 2023 · S/N 9535N278HJJohnson Joel P · Duluth, MNBuilt 1967 · S/N 185-1268N278JAAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 5037N278MReid Stephen M · Gardner, KSBuilt 1980 · S/N TH-1105N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318N278RHolliday Henry S · Poplarville, MSS/N E-1181N278SBKyle Benjamin LLC · Marriottsville, MDBuilt 2008 · S/N 31-0094N278SREllsworth Farm LLC · Kingsbury, NYBuilt 2007 · S/N 2419N278TCLittle Bird Air LLC · Wenatchee, WABuilt 2010 · S/N 0064
Back to AD 2000-23-21