OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N409VRegistered aircraftBuilt 1965 · S/N TE-7N40ABSchumacher Steven Joseph · Fayetteville, ARBuilt 1983 · S/N CE-1020N40AESchwartz Michael · Missoula, MTBuilt 1964 · S/N 18255664N40APCaelus Air LLC · Sheridan, WYBuilt 1981 · S/N 250572N40ARBock Owen · Grand Rapids, MIBuilt 1984 · S/N 28R-8431032N40AUBkf Aviation Ltd · Brookline, MABuilt 2007 · S/N 31-0038N40BBPawlak Jakub Piotr · Lafayette, INBuilt 1977 · S/N 18265944N40BLK & B Real Estate Holdings LLC · Huntley, MTS/N 18264088N40BZHazlewood Aviation LLC · Wichita, KSFirst renewal noticeBuilt 2008 · S/N 411034N40CFG&M Flyers LLC · Wilmington, DEBuilt 1998 · S/N 29-0136N40CLPowell Sherman B · Pulaski, TNBuilt 1974 · S/N 653N40CXSchuette David A · Flemington, NJBuilt 2006 · S/N 41670N40CYGross William Patrick · Pine Bluffs, WYBuilt 2005 · S/N 41075N40ECHill Richard C · Buckeye, AZS/N 18256692N40FMKiessling Jay J · Erie, PABuilt 1997 · S/N 25-2012N40GHagerty Environmental LLC · Kennett Square, PABuilt 1972 · S/N D-9342N40GBSlb Enterprises LLC · Newark, DEBuilt 1977 · S/N 340A0264N40GDSimply Living LLC · Fort Myers, FLBuilt 2003 · S/N 0473N40GMSteven E Cox · Bend, ORBuilt 1964 · S/N D-7343N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438N40JBElk River Aero LLC · Noel, MOS/N TH-338N40JCDbs Aviation LLC · Sulphur Springs, TXBuilt 1973 · S/N 421B0384N40JHJohnson Sean M · Martinez, CABuilt 1975 · S/N E-772N40KGFour Stars Aviation Inc · Mclean, VABuilt 1983 · S/N E-2067N40KTDemuth Gabriel J · Jackson Springs, NCBuilt 1968 · S/N D-8717N40LSFenhaus Jason · Billings, MTBuilt 1973 · S/N 18262242N40LTNilsson Winston · Merrill, ORBuilt 1953 · S/N 30527N40MMChupp Family Trust LLC · Kalispell, MTBuilt 1964 · S/N TC-740N40MWCarbone Peter E Jr · Hopkinton, MAFirst renewal noticeBuilt 1980 · S/N E-1708N40NFTroposphere Holding LLC · Austin, TXBuilt 2024 · S/N 9870N40NGOng Timothy · Redmond, WABuilt 2008 · S/N ES-086N40NLVetter Brent E · Helena, MTBuilt 1958 · S/N D-5743N40NYJohnson Elite International LLC · Tucson, AZBuilt 1970 · S/N 414-0160N40PGFunanich Jon J Trustee · Fairfield, CABuilt 1980 · S/N TJ-309N40PMFlypie Industries LLC · Hudson, WIBuilt 1986 · S/N 4608005N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323N40SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 340A0650N40TEWild Warbirds LLC · Uvalde, TXS/N CE577N40TRKwong Elwood · Foothill Ranch, CABuilt 1977 · S/N E-1190N40VKelly Donald William Jr · Roswell, GABuilt 1971 · S/N TE-799N40WABergstedt Yvonne · Anchorage, AKBuilt 1956 · S/N 32588N40WTPritchett Thomas A · Covington, GABuilt 1953 · S/N 30324N40XSSasser F Michael · Cedar Park, TXBuilt 1978 · S/N E-1278N40YMN40ym LLC · Mattituck, NYBuilt 2025 · S/N 10616N4100KLivingston And Wilson Aviation LLC · Anaconda, MTBuilt 2017 · S/N T24002132N4101PKnepp Terry Wayne · Montgomery, INBuilt 1977 · S/N E-1026N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N4102SFlying Drahthaar LLC · Billings, MTBuilt 1975 · S/N TE-1038N4103SSky High Aviation LLC · Fishers, INBuilt 1975 · S/N TE-1039N4104SSky West Aviation Inc Trustee · Albuquerque, NMS/N CE-558
Back to AD 2000-23-21