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.

N25704Arrison Frank J · Doylestown, PABuilt 1973 · S/N E-475N2570QGolden Thomas J · Bishop, GAS/N 18257770N2570RSkyblazers LLC · Boones Mill, VABuilt 1967 · S/N 18258270N2570ZLucci Robert J · Long Lake, NYBuilt 1963 · S/N 185-0570N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540N2571GGolf Air LLC · Anchorage, AKBuilt 1959 · S/N 51871N25720Smile Air LLC · Macomb, MIBuilt 1973 · S/N E-479N25722Mitchell Brian J · Boise, IDBuilt 1963 · S/N 18051274N2572GMorgan Nathan · Boise, IDBuilt 1959 · S/N 51872N2572RMladejovsky Michael G Trustee · Paulden, AZBuilt 1967 · S/N 18258272N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332N2572XC S Enterprises Llp · Morristown, TNBuilt 1965 · S/N P206-0072N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390N2573KDonham Sonjia F · Portland, ORBuilt 1978 · S/N 18052995N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173N2573XSkd LLC · Spokane, WABuilt 1965 · S/N P206-0073N2574RChauvin Junius · Franklin, LAS/N 18258274N2575GAltes Matt · Mount Shasta, CABuilt 1959 · S/N 51875N2575KSchlick David L · Poulsbo, WABuilt 1978 · S/N 18052997N2575SDulin Morgan L · Midland, TXBuilt 1968 · S/N 337-0875N2575X360 Solo LLC · San Martin, CABuilt 1965 · S/N P206-0075N2576MEsposito Joseph Salvatore · Jacksonville, FLBuilt 1977 · S/N 28R-7803133N2576QHamilton Steve · Carson City, NVBuilt 1966 · S/N 18257776N2577QSlingsby J Geoffrey · Rapid City, SDBuilt 1977 · S/N 18503520N2577RSchomaker Michael J · Pleasanton, CABuilt 1967 · S/N 18258277N2577SHurt Randall L · Smithville, TNBuilt 1968 · S/N 337-0877N2577ZMaynard Christopher J · Anchorage, AKBuilt 1964 · S/N 185-0577N2579GMcglachlin Brandon E · Moundridge, KSBuilt 1959 · S/N 51879N2579KSkywagon LLC · Sterling, AKBuilt 1978 · S/N 18053000N2579SMenagh Bret J · Fresno, CABuilt 1968 · S/N 337-0879N257CDPahlavan Benham A · Santa Rosa, CABuilt 2002 · S/N 1184N257FDCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 10063N257GGGioia Travel Inc Trustee · Wilmington, DEBuilt 2024 · S/N 9925N257GMLee Aviation Company LLC · Pensacola, FLBuilt 2025 · S/N 10951N257HWSpry Logistics LLC · Ponchatoula, LABuilt 2026 · S/N 11412N257JCPetersen Michael · Truckee, CABuilt 2016 · S/N T24002102N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071N257JSDelaurentis Robert · San Diego, CABuilt 1978 · S/N 18266090N257LMSsb Aviation LLC · Wasilla, AKBuilt 1975 · S/N 18052548N257MWillis Charles A · Arlington, TXBuilt 1958 · S/N D-5604N257PGVinea Piston LLC · Augusta, GABuilt 2021 · S/N 2454N257PZJrbeers Aviation LLC · Frisco, TXBuilt 2017 · S/N 1532N257RRegistered aircraftBuilt 1957 · S/N 34411N257SCJetpurple LLC · Evanston, ILBuilt 2011 · S/N 0199N257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781N257SRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2006 · S/N 2132N257TLTornado Alley Turbo Inc · Ada, OKBuilt 2012 · S/N 2165N257TMSunrise Aviation Group LLC · Kalispell, MTBuilt 2007 · S/N 31-0049N257WMSoter Leasing LLC · Kalispell, MTBuilt 2026 · S/N 11240
Back to AD 2000-23-21