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.

N234SBDaly Arthur P · El Paso, TXBuilt 1981 · S/N P21000673N234SDHerndon Aviation LLC · Kokomo, INBuilt 1981 · S/N EA-200N234TCAg N234tc LLC · South Salt Lake, UTBuilt 1974 · S/N 310R0050N234TGAvionicos Corp · Sarasota, FLS/N 34-8070234N234THHalbur Lucas R · Omaha, NEBuilt 1978 · S/N 18266386N234TLLanflisi Robert A · Fairfield, CAS/N 310Q0957N234TMMisakian David L · Novato, CABuilt 1976 · S/N 18264768N234TTGloyna Edwin Scott · Lubbock, TXBuilt 2020 · S/N 2049N234TUMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N G-138N234TXRussell Military Museum · Zion, ILS/N 52-8276N234WIwaa Inc · Woodstock, GABuilt 1976 · S/N 21061618N234WBDrake Colin · Mendocino, CABuilt 1969 · S/N D-8952N234WMBay Area Skymaster LLC · Pasadena, MDBuilt 1962 · S/N 500A-1257-81N234WPUnited States Air Force Owner · Rio Vista, CABuilt 1957 · S/N BG-329N234WSMancini Gary Ray · Livermore, CABuilt 2004 · S/N 29-0343N234XLCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11503N2350CKeating John C · Prosper, TXBuilt 1953 · S/N 30650N2350MCampbell J Bryce · Stillwater, OKBuilt 1977 · S/N 28R-7803125N2351CClemens Aviation LLC · Wichita, KSBuilt 1953 · S/N 30651N2351FStewart Anthony D · Blytheville, ARBuilt 1964 · S/N 21058551N2351GBradley John · Edgewood, NMBuilt 1958 · S/N 51651N2351RBrockman Robert L · Christoval, TXBuilt 1964 · S/N 18255451N23523Fox & Bear Air Charters LLC · South Padre Island, TXBuilt 1977 · S/N E-1175N2352CMcmahan Johana · Gakona, AKBuilt 1953 · S/N 30652N2352RElkhorn Aviation LLC · Mandan, NDBuilt 1964 · S/N 18255452N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865N23534Schwabenton William J · Greensboro, NCBuilt 1977 · S/N CE-751N2353COverly Terrence Lee · Tok, AKBuilt 1953 · S/N 30653N2353GCascade Aero LLC · Scotts Mills, ORS/N 51653N23540State Of Iowa · Iowa City, IABuilt 1977 · S/N E-1180N23541Registration Pending · Middleburg, FLRegistration pendingBuilt 1977 · S/N E-1182N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085N2354BHigh Sky LLC · Rogers, ARBuilt 1968 · S/N D-8831N2354CMoma Donald R · Wasilla, AKBuilt 1953 · S/N 30654N2354FBarbee William Terry · Weslaco, TXBuilt 1998 · S/N E-3154N2354GJbtg LLC · Poplar Bluff, MOBuilt 1958 · S/N 51654N2354RCarter Bradford J · Rockland, MEBuilt 1964 · S/N 18255454N2354SSkymaster Stc LLC · Mena, ARBuilt 1967 · S/N 337-0654N2354XNorth Coast Aeronautical LLC · Cleveland, OHBuilt 1965 · S/N 18256254N23551S&M Aviation (A Co Limited Liability Co) · Colorado Springs, COBuilt 1977 · S/N E-1183N2355CFerguson Edward P · Fargo, NDBuilt 1953 · S/N 30655N2355RLima Mike Inc · Ham Lake, MNBuilt 1964 · S/N 18255455N2355TBe-3195 LLC · Conway, ARBuilt 1998 · S/N E-3195N2355XVan Every Jason E · Cleburne, TXBuilt 1965 · S/N 18256255N2356GKajans Donald F · Reno, NVBuilt 1958 · S/N 51656N2356RBledsoe Charles J · Jackson, GABuilt 1964 · S/N 18255456N23571Dlat Holdings LLC · Allen, TXBuilt 1977 · S/N TE-1120N23573Rolrice Family Limited Partnership · Tulsa, OKBuilt 1977 · S/N TC-2107N23578Green Law Aviation Inc · Culpeper, VABuilt 1977 · S/N E-1185N2357FBachand Kevin L · Leesburg, VABuilt 1964 · S/N 21058557
Back to AD 2000-23-21