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.

N3230RAkradi Parviz · Irvine, CABuilt 1987 · S/N CE-1173N3230YCosta Flying Service Inc · Painted Post, NYS/N 18254230N3231DMcfarlane Claude L · Fitchburg, WIBuilt 1955 · S/N 32029N3232WKilgallen Keith S · Stuart, FLBuilt 1995 · S/N E-2932N3232YWise Frederick W · Windsor, PABuilt 1962 · S/N 18254232N32331Sowers Richard M · Reno, NVBuilt 1980 · S/N 21064188N3233GMach Aviation Pilot Services LLC · Andover, KSBuilt 1995 · S/N E-2933N3233JZebcon Inc · Russellville, ARBuilt 1999 · S/N E3233N3233LMann Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA633N3233SVan Ness James A · Buckley, WABuilt 1964 · S/N 18255733N3233YShepperson Ranch Co · Midwest, WYBuilt 1962 · S/N 18254233N3234PMccraw Samuel A · Cowpens, SCBuilt 1961 · S/N 305M-0015N3234YGrefsrud Travis · Pelican Rapids, MNBuilt 1962 · S/N 18254234N3235DMdb Ventures LLC · Wausau, WIBuilt 1995 · S/N E-2935N3235SPollard Brent H · Wilburton, OKBuilt 1964 · S/N 18255735N3235TBhatia Kabir · Lake Oswego, ORBuilt 1995 · S/N EA-577N3236DFrey Joseph · Fallon, NVBuilt 1955 · S/N 32034N3236QBo'S Investments LLC · Amarillo, TXBuilt 1997 · S/N E3110N3236THg Aviation LLC · Helena, MTBuilt 1995 · S/N E-2936N3236UHetrick Daniel R · Orovada, NVBuilt 1963 · S/N 18254636N3236ZJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1991 · S/N EA-526N3237YCopper Mountain Assets · Winthrop, WABuilt 1962 · S/N 18254237N3238DLutes Richard L · Hampshire, ILBuilt 1955 · S/N 32036N3238YKorff Aviation LLC · Leesburg, VABuilt 1995 · S/N E-2938N3239DJaj Flying LLC · Sutton, NEBuilt 1955 · S/N 32037N3239Q92nd West Aviation Inc · Lonoke, ARBuilt 1967 · S/N 401-0039N3239UJohnson Colten T · Richards, MOBuilt 1963 · S/N 18254639N3239VMccue Michael R · Missoula, MTBuilt 1977 · S/N R1722243N3239WHaidlen Ford Inc · Oakdale, CABuilt 1995 · S/N E-2939N3239YHarper Mark A · Winston Salem, NCBuilt 1962 · S/N 18254239N323ACKing Ag Leasing Inc · Sudan, TXBuilt 1967 · S/N 18258024N323BMMav-Cat Aero LLC · Bremerton, WABuilt 2010 · S/N 0069N323CCBarrett James P · North Little Rock, ARBuilt 1978 · S/N 28R-7803206N323CD2 Guys Aviation LLC · Okeechobee, FLBuilt 2004 · S/N 1020N323CLHoge John · Setauket, NYBuilt 2002 · S/N 40054N323DASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064753N323DCFlymax Aircraft LLC · Ball Ground, GAS/N P21000384N323DMWard Frank J · N Richland Hills, TXBuilt 1998 · S/N 29-0155N323FWarden James L · West Milford, NJBuilt 1960 · S/N CD-257N323FLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1985 · S/N 468508096N323FTPudil Zachary Thomas · West St Paul, MNBuilt 2004 · S/N 1432N323GBGs Aviation LLC · Lebanon, TNBuilt 1975 · S/N E-647N323JLLeghorn Airfleet LLC · Columbus, INBuilt 1968 · S/N TE-608N323KCBig Blessing LLC · Saint Louis, MOBuilt 2015 · S/N 4273N323KGN1234 LLC · Costa Mesa, CABuilt 2020 · S/N 4879N323KWBlue Cedar Aviation LLC · Raymore, MOBuilt 1985 · S/N 18268480N323LMSandcastle Jwm Properties LLC · Paradise Valley, AZBuilt 1992 · S/N TH-1667N323MFFla Capital LLC · Newark, DEBuilt 2023 · S/N 9426N323PMSrc Property LLC · Alpine, TXS/N EA-161N323RBAvion Flight Services LLC · Rome, GABuilt 2012 · S/N 3906
Back to AD 2000-23-21