OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N11SMMusser Scott S · Pasco, WABuilt 2023 · S/N 9573N11SYRautiola Erik · Cresson, TXS/N TC-1468N11TCShiver James B Jr · Stanley, NMBuilt 1977 · S/N 21062230N11TJKubic Daniel W · Advance, NCBuilt 1979 · S/N 310R1683N11UYInternational Air Services Inc Trustee · Carson City, NVS/N EA-218N11VBRobertson Matthew · Nashville, TNBuilt 1969 · S/N D-9031N11VGSage Aviation LLC · Saint Louis, MOBuilt 1976 · S/N D-9891N11VKHoskins Terry Wayne II · Knoxville, TNBuilt 1961 · S/N TC-200N11VVSchmidt Milton W · Cincinnati, OHBuilt 1994 · S/N 29-0010N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086N11VZLowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N E-397N11WAlae Exploration LLC · Gainesville, FLBuilt 2002 · S/N 0262N11WHT T Aero LLC · Pauls Valley, OKBuilt 1956 · S/N 33447N11WKPage John · Carmel, CABuilt 2014 · S/N 0856N11WPPlacer Aviation LLC · Loomis, CABuilt 1990 · S/N E-2546N11WSAviation Trust Company LLC · Oklahoma City, OKS/N P3370017N11XAErwin Troy · Schertz, TXBuilt 2011 · S/N 11E-00996N11XEHenley Mark A · Sulphur Rock, ARS/N 11E00995N11XMWesley F Walker · Rock Hill, SCBuilt 1999 · S/N E-3225N11XTKacur John Edward Sr · Halethorpe, MDBuilt 2000 · S/N 1103N11YESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1995 · S/N 29-0038N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498N11YNN3412w LLC · Lithia, FLS/N 34-8070059N11YZHuggins David R · Carmichael, CABuilt 1970 · S/N 18260401N11ZTQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1108N12000Bear Creek Air LLC · Helena, MTBuilt 1968 · S/N 18259487N1201MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 8510N1202BDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N TC1825N1202GTyler Brenda · Mountain Top, PABuilt 1974 · S/N 310Q1057N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649N1203NBracy Rodney E · Middleville, MIBuilt 1972 · S/N 12046N1203WPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R-2106N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767N1204ZAquila Aero LLC · Denison, TXBuilt 1961 · S/N D-6667N1205BEngel Shane J · Willow, AKBuilt 1963 · S/N 205-0190N1205GKnapp James Ross · Apex, NCBuilt 1974 · S/N 310Q1060N1206DMagnolia Underground Construction Inc · Byhalia, MSBuilt 2020 · S/N 2211N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769N1206ZGlg Properties LLC Series 13 · Bridgeport, TXS/N D-6678N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966N1207C3 Rs Incorporated · Perry Hall, MDBuilt 2003 · S/N 0455N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771N1208ZMaurice L Prince Jr Pc · Lafayette, LABuilt 1961 · S/N TC-60N1209MShook Steve Trustee · Boulder, COBuilt 1975 · S/N 18264243N120APredictive Bytes LLC · Houston, TXBuilt 2024 · S/N 10297N120ACNiebla Holding LLC · Miami, FLBuilt 2025 · S/N 10575N120BSkysuite Aviation LLC · Tujunga, CABuilt 1962 · S/N TC-230N120BCHunyadi James W · Toledo, OHBuilt 1979 · S/N P21000404N120DBB & I Leasing LLC · Berryville, VABuilt 1978 · S/N E1276N120GXLow & Slow Aviation Ventures LLC · Fort Myers, FLBuilt 2006 · S/N 29-0459
Back to AD 2000-23-21