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.

N2495FKalbfleisch George R · Dry Ridge, KYBuilt 1966 · S/N 18051697N2495GHayton James B · Sedro Woolley, WABuilt 1959 · S/N 51795N2495RSale Reported · Saint Augustine, FLSale reported, canceledBuilt 1964 · S/N 18255595N2496FKrissman Ryan · Gallup, NMS/N 18051695N2496TWillis Victor R · Eagle River, AKBuilt 1964 · S/N NAV-4-2496N2497GChapman William F · Coeur D Alene, IDBuilt 1959 · S/N 51797N2497THoogasian Stephen M · Manassas, VABuilt 1973 · S/N NAV-4-2497N2497XVoeltzel Rick K · Rio Rico, AZBuilt 1965 · S/N 18256397N2498FTaylor Andrew A · Ketchikan, AKBuilt 1966 · S/N 18051700N2498GKc Aircraft LLC · Missoula, MTBuilt 1959 · S/N 51798N2498RJohnson Christopher A · Pampa, TXBuilt 1964 · S/N 18255598N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306N2498XVotava Paul A · Mcintosh, MNBuilt 1965 · S/N 18256398N249ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N CJ132N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318N249CGJulam Holdings LLC · Winter Park, FLBuilt 2018 · S/N E-4119N249CKCarolina Landing LLC · Cambridge, MDBuilt 2003 · S/N 0766N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249N249DKK-Air Inc · Egg Harbor, WIBuilt 2017 · S/N TH-2487N249EABertsch Paul J · Houston, TXBuilt 1962 · S/N D-7051N249MDMorrison William F · Athol, IDBuilt 1965 · S/N 18051501N249MVAmble Tod M · Bozeman, MTBuilt 1979 · S/N CE-884N249SAGribble Ted A · Paris, TXBuilt 2001 · S/N 29-0267N249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 21060990N249TJF Korbel & Bros · Guerneville, CABuilt 1966 · S/N TE-249N249TMSchellberg Steven A · Port Matilda, PABuilt 2003 · S/N 1333N249WHWhiskey Hotel LLC · O Fallon, MOBuilt 1978 · S/N CJ-147N249WLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-134N249WSSmith Charles L III · Petaluma, CABuilt 2004 · S/N 0975N249WTReed Christopher · Greeley, COBuilt 2017 · S/N 1535N249YJohnson Steven A · New Braunfels, TXBuilt 1969 · S/N CE-282N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293N24AKLund Kristoffer B · Encinitas, CABuilt 1968 · S/N TC-1150N24AMFlight Solutions LLC · Carefree, AZBuilt 2019 · S/N 1876N24ATBobwhite Aviation LLC · Atlanta, GABuilt 2019 · S/N 4768N24BEMystic Knights Of The Air Lodge Inc · Canton, MSBuilt 1979 · S/N E-1540N24BFWright Aviation Inc · Pikeville, KYBuilt 1980 · S/N E1736N24BKN24bk LLC · Jupiter, FLBuilt 1977 · S/N E-1145N24BTRutan Elbert L · Mojave, CABuilt 1996 · S/N 001N24BVAsana Ventures LLC · Rancho Santa Fe, CABuilt 2024 · S/N 10053N24CAWoodford Aviation Inc Trustee · Wilmington, DEBuilt 2023 · S/N 9318N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793N24CJAtluas LLC · Anna, TXS/N 18502199N24CMFirst Move Capital LLC · San Diego, CABuilt 2017 · S/N 1577N24CRTop Flying LLC · Dover, DEBuilt 2008 · S/N 2923N24CSMcmanigle Jeffrey · Osakis, MNBuilt 1975 · S/N 76-30804N24DCCraig Joshua · Bonaire, GABuilt 1975 · S/N 33701640N24DX618 Enterprises LLC · Sheridan, WYBuilt 2024 · S/N 9768N24EERomana Mathieu G · Miami Springs, FLBuilt 2008 · S/N 3276
Back to AD 2000-23-21