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.

N2724XParrott Charles F · Bridgton, MEBuilt 1965 · S/N 18051524N2725F85 Charlie Papa LLC · Phoenix, AZBuilt 1965 · S/N 18256825N2726GFarmhouse Aerospace LLC · Laurel, MTBuilt 1959 · S/N 52026N2727LAircraft Trustee Services Inc Trustee · Dover, DES/N 414A0602N2727QEstes Gregory T · Jonesville, VABuilt 1967 · S/N 18257927N2728BBig Island Gravity LLC · Kapaau, HIBuilt 1959 · S/N 52028N2728TMilk Ranch LLC · Stephenville, TXBuilt 1967 · S/N D-8447N2728XUsda Forest Service Fepp · Trenton, NJBuilt 1965 · S/N 18051528N2729FSexton & Sanders Law Firm Pa · Fort Smith, ARBuilt 1965 · S/N 18256829N2729LVip Wellness LLC · Victoria, TXBuilt 1979 · S/N 414A0431N2729QCraft Phyllis C · Damascus, GABuilt 1967 · S/N 18257929N2729TWasileski David J · Auburn, NYS/N D-8451N272AAEdj Aviation Limited · Fort Myers Beach, FLBuilt 1960 · S/N CD-34N272BBearair II LLC · Libertyville, ILBuilt 1975 · S/N 18264193N272CDSegers Ernst E · Pensacola, FLBuilt 2010 · S/N 3541N272CSTres Vientos LLC · Santa Fe, NMBuilt 2011 · S/N ESP-217-16N272CTInncal Inc · Stockton, CABuilt 1993 · S/N E-2824N272DDelta Delta Aviation LLC · Pickerington, OHBuilt 2021 · S/N 5095N272DGDeutscher Kevin W · Chandler, AZBuilt 2024 · S/N 0272-2024N272EVSanderlin Aviation LLC · Seattle, WABuilt 2026 · S/N 11477N272HMBas Part Sales LLC · Greeley, COBuilt 2015 · S/N 1079N272MSHinkle Paul · Broken Arrow, OKBuilt 1964 · S/N D-7429N272NSKroeber Thomas · Pawlet, VTBuilt 1980 · S/N 18267402N272QFlying Docs LLC · Tomball, TXBuilt 1966 · S/N TE-236N272RHLewis Coleman · Dallas, TXBuilt 2008 · S/N 3054N272SBofinger Jr John M · Hewitt, NJBuilt 1965 · S/N D-8002N272SCRobert Gardner Enterprises LLC · Mercer, MEBuilt 1977 · S/N 18052939N272TMRam Precision Industries Inc · Dayton, OHBuilt 2017 · S/N 1655N272VWigley Ben Jr · Huntington, ORBuilt 1956 · S/N 33362N2730ASteigenga Nathan L · Suffolk, VAS/N E-1229N2730MSua LLC · Artesia, NMBuilt 1980 · S/N 414A0437N2730PRegistration Pending · Palm Harbor, FLRegistration pendingBuilt 2005 · S/N 41071N2730QSkylane Corp · Pittston, PABuilt 1967 · S/N 18257930N2730RRp Aviation Inc · Alliance, OHBuilt 1978 · S/N CE-792N2730XSmith Daniel E · Anchorage, AKBuilt 1965 · S/N 18051530N2731KYoung Aviation LLC · Oshkosh, WIBuilt 1979 · S/N 18053045N2731Q31q LLC · Boise, IDBuilt 1967 · S/N 18257931N2731TFocus LLC · Missoula, MTBuilt 1967 · S/N D-8454N2732GPrince Benjamin D · Lincoln, MTS/N 52032N2732KDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1979 · S/N 18053046N2732TJellor Realty Inc · Los Angeles, CABuilt 1979 · S/N 414A0449N27339Rice John G · Craig, AKBuilt 1970 · S/N 18052140N2733FMetzger William M · Boonville, INBuilt 1965 · S/N 18256833N2733GSkydive Ky LLC · Cecilia, KYS/N 52033N2734BStella Air Inc · Wyoming, PABuilt 1979 · S/N 414A0454N2734FWard Christopher C · Lufkin, TXBuilt 1965 · S/N 18256834N2734GSplit Rock Aerospace LLC · Southport, CTBuilt 1979 · S/N 414A0456N2734HGriebel Kyle L · Lafayette, COBuilt 1959 · S/N 52034N2734Q1175 Bangtail Way LLC · Greycliff, MTBuilt 1967 · S/N 18257934N2735JAlpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0466
Back to AD 2000-23-21