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.

N2371XCouch Sue A · Dewy Rose, GABuilt 1965 · S/N 18256271N23723Kleck Wil · Victoria, TXBuilt 1978 · S/N D-10100N23724Zhang Harvest Land · Moraga, CABuilt 1978 · S/N E-1211N2372GJohnson David B · Santa Barbara, CABuilt 1958 · S/N 51672N2372XRegistered aircraftBuilt 1965 · S/N 18256272N2373FRlo Aviation LLC · Double Springs, ALBuilt 1965 · S/N 21058573N2374GAirco International LLC · Everett, WAS/N 51674N2374XMorrison Aircraft · Harrisburg, ARS/N 18256274N23752Talton David S · Tupelo, MSBuilt 1978 · S/N E-1215N23753Lifestyle Aviation LLC · Dallas, TXBuilt 1978 · S/N CE-762N23757Walinchus Robert E · Pooler, GAS/N CE-731N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257N2375XBaldwin Todd K · Prescott Valley, AZBuilt 1965 · S/N 18256275N2376GN2376g LLC · Helena, MTBuilt 1958 · S/N 51676N23777Erb Ralph J · Mebane, NCS/N R1720096N2377CCooper Capital Specialty Salvage LLC · Old Saybrook, CTBuilt 2024 · S/N E-4156N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577N2377GLutz Matthew S · Lewistown, MTBuilt 1958 · S/N 51677N2377XBieker Tor M · Hood River, ORBuilt 1965 · S/N 18256277N23788Bellendir Timothy J · Fort Morgan, COBuilt 1967 · S/N R172E-0092N2378CHovda H O · Progreso, TXBuilt 1953 · S/N 30678N2378GStramel Matthew J · Elko, NVBuilt 1958 · S/N 51678N2379RLanzetta Kenneth · Oakland Park, FLBuilt 1979 · S/N 18266988N2379XK Fortner LLC · San Marcos, TXS/N 18256279N237AMMcconnell Edward H · Weatherford, TXBuilt 1990 · S/N 79N237CDC5 Holding LLC · San Juan, PRBuilt 2026 · S/N 11582N237CGSonoma Valley LLC · Missoula, MTBuilt 2008 · S/N 2934N237CTSkymax LLC · Stanford, KYBuilt 1968 · S/N 18258819N237DWTheis Industrial Leasing Inc · Spivey, KSS/N 35506N237JAJacvia Aircraft Inc · Scottsville, KYBuilt 2025 · S/N 11051N237LPGallatin Consulting Group LLC · Pittsburgh, PABuilt 2020 · S/N 2200N237MArdizzone Mark R · Mckinney, TXBuilt 1965 · S/N 293N237RBMed Ex LLC · Shiloh, ILBuilt 2007 · S/N 31-0025N237RJArgaeus LLC · Poway, CABuilt 2006 · S/N 2159N237RPPohlner Roger E · Fisher, ARBuilt 2008 · S/N 31-0095N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841N2380RReep Nicolas K · Yakima, WABuilt 1964 · S/N 18255480N2380XGaller Mary D Trustee · Elysian, MNBuilt 1965 · S/N 18256280N2381CLee Kevin M · Rexburg, IDBuilt 1954 · S/N 30681N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581N2381GKittelman Thomas L · Gilbert, AZS/N 51681N2381XCooper Scott J · Fellows, CABuilt 1965 · S/N 18256281N23822Platt James Wesley · Bushnell, FLBuilt 1977 · S/N E-1089N2382GGish Joseph B · Lewiston, IDFirst renewal noticeBuilt 1958 · S/N 51682N2382SMielczarek Joe I · Santa Paula, CABuilt 1967 · S/N 337-0682N2382XRolleston Moreton M III · Canton, GABuilt 1965 · S/N 18256282N2383AAero Traveler Ltd · Warminster, PABuilt 1969 · S/N D-9034N2383XComo Aviation LLC · South Weymouth, MABuilt 1965 · S/N 18256283N2383YAult Stanley K · Cinebar, WABuilt 1965 · S/N 21058583N2384DEcardiocare Air LLC · Reno, NVBuilt 2013 · S/N 0532
Back to AD 2000-23-21