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.

N11BXMatthew K Cole · Gillespie, ILBuilt 1972 · S/N CE-388N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N11CTNwm Advisors LLC · San Luis Obispo, CABuilt 2020 · S/N 4960N11DFFull Flaps 11df LLC · Malvern, PABuilt 2024 · S/N 10337N11DHRegistered aircraftBuilt 1978 · S/N 18052974N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245N11ECBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1970 · S/N TH-128N11ELShchelokov Ilya Sergeyevich · Austin, TXBuilt 2020 · S/N DMO 094N11EMEstus Chad · North Las Vegas, NVBuilt 1957 · S/N D-5159N11ESEspo Air LLC · Okemos, MIBuilt 2023 · S/N 9177N11EVBonita Beech LLC · Bonita Springs, FLBuilt 1976 · S/N TH-748N11FFJet Speed Aviation Inc · Las Vegas, NVS/N TE-736N11FJPetit Chris J · Marrero, LABuilt 1961 · S/N 18253252N11FVInternational Aor Service Inc Trustee · Carson City, NVBuilt 1982 · S/N T303-00133N11GGGallagher Aviation LLC · Cincinnati, OHBuilt 1959 · S/N D-6184N11GXWestrum Enterprises LLC · Norwalk, IABuilt 1976 · S/N 310R0645N11GYYoung Layton A · Godley, TXBuilt 1972 · S/N 366N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484N11HRHf Aero LLC · Lusby, MDBuilt 1979 · S/N 34-7970233N11HTJet X Leasing Inc · Johnson, KSBuilt 1967 · S/N D-8534N11JARegistration Pending · Denison, TXRegistration pendingBuilt 1977 · S/N 340A0292N11JBFlight Risk Ventures LLC · Missoula, MTBuilt 1971 · S/N D-9234N11JESky Vista LLC · Macon, GABuilt 1974 · S/N 18263240N11JFN11jf LLC · Battle Ground, WABuilt 2025 · S/N 10554N11JJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000511N11JQLosey Charles N Jr · Oneida, TNBuilt 1965 · S/N D-7786N11KFRebel Dawg Aviation LLC · Vestavia Hills, ALBuilt 1967 · S/N TE-325N11KGErickson Marine Aircraft LLC · Sarasota, FLBuilt 2012 · S/N E-3981N11KMMcree Richard Kent · Frisco, TXBuilt 2023 · S/N 9436N11KRDawson Gray N · Roseburg, ORBuilt 1976 · S/N 21061249N11KSFaulkner Dale R · Burnet, TXBuilt 1969 · S/N D-9017N11KWTriple Bee Transport LLC · Leon, WVBuilt 2008 · S/N L2K-304N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058N11LLFord William D III · Durango, COBuilt 2013 · S/N L2K-213N11LSSmall Robert Lance · Fredericksburg, TXBuilt 1946 · S/N 1296N11MRPremier Aviation LLC · St Johns, FLBuilt 2024 · S/N 9859N11MUMills Joseph Laney · Johns Island, SCBuilt 2018 · S/N 1831N11MZD&K Harvesting Inc · Labelle, FLBuilt 2001 · S/N 0108N11NRBenemily Aviation LLC · Flagstaff, AZBuilt 2021 · S/N 2464N11PEAir Caribbean Inc · Dover, DES/N P3370322N11PGVan Bortel Aircraft Inc · Arlington, TXBuilt 2014 · S/N T24002043N11PNIvlje LLC · Chicago, ILBuilt 2016 · S/N 1445N11PRGo Anywhere Do Anything LLC · South Lake Tahoe, CAS/N 2307N11RLBeech Life LLC · Houston, TXBuilt 1980 · S/N EA120N11RMHaig Amy · Redlands, CABuilt 1993 · S/N EA-553N11RPN11rp LLC · Brecksville, OHBuilt 1978 · S/N 28R-7803241N11RTBraly And Braly Pc · Ada, OKBuilt 1967 · S/N D-8420N11SDHarris County Sheriffs Office · Spring, TXBuilt 2020 · S/N 4957N11SLJohnson Randy L · Pikeville, KYBuilt 1960 · S/N 310-0029
Back to AD 2000-23-21