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.

N2995FCj3 Aviation LLC · Idaho Falls, IDBuilt 1966 · S/N 18257095N2996CSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 30896N2996FSmooth Air LLC · Mequon, WIBuilt 1966 · S/N 18257096N2996TSims Barry Don Sr · Canadian, TXBuilt 1967 · S/N 369N2996YCrowe Timothy P · Gilbert, AZBuilt 1962 · S/N 18253996N29970Andrecheck Cynthia R · Bethel, AKBuilt 1981 · S/N 185-04292N29972Windblown Ranch Inc · Echo, ORBuilt 1981 · S/N 185-04162N2997CSmith Philip W · Copeland, KSBuilt 1955 · S/N 30897N2997YSkyriders LLC · Flagstaff, AZBuilt 1962 · S/N 18253997N2998FChristian Halls International · Arlington, TXBuilt 1966 · S/N 18257098N2998KWallingsford Don C · Yorba Linda, CABuilt 1980 · S/N 18053155N2998MM T Aviation LLC · Grove, OKBuilt 1986 · S/N CE-1097N2998TMartony Joseph M · Chandler, AZBuilt 1967 · S/N 371N2998YReynolds Peter · Athol, MABuilt 1962 · S/N 18253998N2999AFindly Raymond Lee · Ravenna, KYBuilt 1953 · S/N 30199N2999CCarnine Daniel L · Seeley Lake, MTBuilt 1954 · S/N 30899N2999MLopez Eve · Santa Monica, CABuilt 1985 · S/N CE-1074N2999NGarcia Michael R · Marshall, VABuilt 1986 · S/N CE-1081N299AOverman Robert W · Fairfield, OHBuilt 1964 · S/N 320B-0057N299AGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 29-0252N299AKSoquel LLC · Reno, NVBuilt 2025 · S/N 11033N299ATFlyafrica Aviation LLC · Stormville, NYBuilt 2015 · S/N 2292N299BFMacvey Troy R · Milan, INBuilt 1967 · S/N 310L-0093N299BGHarrison Rv Inc · Jefferson, IABuilt 1989 · S/N CE-1366N299CDLinmac LLC · Miami, FLBuilt 2002 · S/N 1267N299CGJacobs Jim · Great Barrington, MABuilt 2014 · S/N 0865N299JWRas Aviation LLC · Elyria, OHBuilt 2004 · S/N 1034N299KAir Transport LLC · Troy, MTBuilt 1979 · S/N TJ-185N299KDSouthern Utah University · Cedar City, UTBuilt 2000 · S/N 760N299LRed Willow Aviation & Spraying Inc · Mccook, NEBuilt 2009 · S/N L2K-299N299LG2 Huskies LLC · Sheridan, WYBuilt 2003 · S/N 29-0299N299MPHessjet LLC · Mc Donald, TNBuilt 2005 · S/N 1396N299MRPlane Viewing LLC · Colbert, WABuilt 2003 · S/N 0753N299PMFailte Aire LLC · S Abingtn Twp, PAS/N 0306N299PTWright W Gregory III · Kinsale, VABuilt 1969 · S/N 18259631N299SBCurrier Holdings LLC · Fairbanks, AKS/N HB2N299SRCharleston Executive Aviation LLC · Johns Island, SCBuilt 2007 · S/N 1886N299WAccelerated Information Technologies Inc · Gates Mills, OHBuilt 2001 · S/N E-3382N299WTCgi Technical Services Inc · Redding, CABuilt 2023 · S/N 9419N29APItzkowitz Arnold · Selbyville, DEBuilt 1993 · S/N E-2823N29AWParticle Airways LLC · Mapleton, UTBuilt 2025 · S/N 11072N29AYCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11483N29BCD' Jm Holdings LLC · Sugar Land, TXBuilt 1974 · S/N P3370172N29BEAltaii Ali · Gibraltar, MIBuilt 1971 · S/N 340-0005N29BP29 Bp LLC · Goshen, NYBuilt 2018 · S/N 4699N29CCSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-117N29CFJ Plane LLC · Mason City, IABuilt 2019 · S/N 1922N29CPClifford Robert J · Dania Beach, FLFirst renewal noticeBuilt 1970 · S/N TH-33N29CSKntj Properties 1 LLC · Wildwood, MOBuilt 1989 · S/N TH-1558N29CWHamilton Aerospace LLC · Lovettsville, VAS/N 34-7570306
Back to AD 2000-23-21