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.

N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563N43LDIrongate Aviation LLC · Raymond, NHBuilt 2021 · S/N 5093N43LP430lp LLC · Marlow, OKBuilt 2022 · S/N 8630N43LWRotgers Benjamin Leroy · Malabar, FLS/N 52159N43MEEvans Matthew B · Granbury, TXBuilt 1978 · S/N P21000046N43MRFlight Contract Services Inc · Las Vegas, NVS/N 414A-0016N43PGBender Brian C · Los Angeles, CABuilt 1998 · S/N 25-2019N43QCAviation LLC · Kalispell, MTBuilt 1984 · S/N TJ-467N43SLSudtell Chad S · Wasilla, AKBuilt 1954 · S/N 31611N43TBAndreu Kenneth · Valhalla, NYBuilt 1966 · S/N 18257442N43TJCyr Philip · Charlton, MABuilt 1979 · S/N 18267365N43TMMkt Development LLC · Venedocia, OHBuilt 2012 · S/N 3838N43TTBluewater Islands Inc · Cape Coral, FLBuilt 2009 · S/N 411149N43WCcp Capital Holdings LLC · Newark, DEBuilt 2025 · S/N 10551N43WGMaxfield Kenneth B Trustee · Murray, UTBuilt 1977 · S/N 28R-7703280N43WRLanaux Antoine D IV · Metairie, LABuilt 2011 · S/N 71368N43WTSummit Aviation LLC · Dover, NHBuilt 1983 · S/N 25-0792N43YIsbell Edwin Chad · Spring, TXBuilt 1974 · S/N E-576N44007Parrish Rob G · Columbus, TXBuilt 1953 · S/N G-126N4402JBruton Paul · El Campo, TXBuilt 1980 · S/N T18803736TN4405AJohnson Marvin E · Garfield, WABuilt 1970 · S/N D-9141N4406RDe Nora Christian G · San Antonio, TXBuilt 1976 · S/N 18052670N4407RRhyneer Loren S · Anchorage, AKBuilt 1976 · S/N 18502946N440BETextron Aviation Inc · Wichita, KSBuilt 2015 · S/N TH-2440N440CDN440cd LLC · Williamsburg, VABuilt 2005 · S/N 1515N440CKKeirs Christopher D · Tomball, TXBuilt 1964 · S/N TC-736N440DDeeble Kenneth M · Dayton, MTBuilt 1964 · S/N D-7461N440DMBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 34-7670040N440GVon Pasecky Ronald · Gilbert, AZBuilt 1976 · S/N D-9911N440LAParks David W · Ithaca, NYBuilt 1957 · S/N D-5257N440LWBig Dawg Air LLC · Ringgold, GABuilt 2013 · S/N E-4016N440QB&T Aviation LLC · Columbia, SCBuilt 1964 · S/N D-7410N440SUFutrell Kenneth R · New Smyrna Beach, FLBuilt 1977 · S/N E-1115N440TJs Aviation Group LLC · Sedona, AZBuilt 1976 · S/N CE-681N440TMMoeser David J · Naperville, ILBuilt 2008 · S/N 411028N4410TLavin Gregory S · Chugiak, AKBuilt 1982 · S/N 18504335N4411TRoute 66 Aerostars LLC · Galena, KSBuilt 1959 · S/N 39024N4412QWoods Flying Service LLC · Memphis, MOBuilt 1971 · S/N 18800812N4414BYoung Ronald R · Albuquerque, NMBuilt 2006 · S/N 31-0006N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N4417WReyling Joseph E · Glasgow, MTBuilt 1974 · S/N E-529N4418ABorchert Pete · Prescott, AZBuilt 1970 · S/N D-9142N4419AMccants Robley D · Mesa, AZS/N D-9147N441BEDriftwood Aviation LLC · Northport, MIBuilt 1999 · S/N 0001N441CFDelcardayre J Sid · Richmond, VABuilt 2019 · S/N 1924N441CLShumate Jeff B · Mcminnville, ORBuilt 2010 · S/N 1753N441CSNorton Aviation LLC · Longboat Key, FLBuilt 2006 · S/N 41596N441DLewis Thomas F · Chico, CABuilt 1955 · S/N 35058N441FPHumphrey Marlon · Birmingham, ALBuilt 2026 · S/N 11207N441GWEugetech LLC · Bettendorf, IABuilt 2004 · S/N 1060
Back to AD 2000-23-21