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.

N2622PSouthern Luxury Logistics LLC · Greensboro, GABuilt 2006 · S/N 1821N2622YPiatt Matthew D · Wasilla, AKBuilt 1962 · S/N 18051122N2623GHubbard James D · Jacksonville, TXBuilt 1959 · S/N 51923N2624GVietnam Helicopters · Concord, CABuilt 1959 · S/N 51924N2624QKalarney Kerry T · Olathe, COBuilt 1966 · S/N 18257824N2624XBritton Daniel W · Fairbanks, AKBuilt 1965 · S/N P206-0124N2624YWarner James R · Van Alstyne, TXBuilt 1962 · S/N 18051124N2625MB-Hive Inc · Augusta, GABuilt 1973 · S/N TC-1586N2625QSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257825N2626FJohnson James E · Stevensville, MTS/N 18256726N2626KUpwind Floats LLC · Seattle, WABuilt 1979 · S/N 18053019N2626MBristow Paul M · Burleson, TXBuilt 2001 · S/N 2881N2626QTomasini William M · Boring, ORBuilt 1966 · S/N 18257826N2626R2626r LLC · Tucson, AZBuilt 1967 · S/N 18258326N2626TBi-Li Aviation LLC · Terryville, CTBuilt 2007 · S/N 2806N2627FUlrich Robert W DBA · Twisp, WABuilt 1965 · S/N 18256727N2627RTaylor John B · Norwich, OHBuilt 1967 · S/N 18258327N2628FPlata Darryl · Arlington, WABuilt 1965 · S/N 18256728N2628QSannikova Olga · Sherman Oaks, CAS/N 18257828N2628SSpencer Bennett E · Cleburne, TXBuilt 1968 · S/N 337-0928N2629FFodness Jan N · Sioux Falls, SDBuilt 1965 · S/N 18256729N2629QStallings Floyd P · Vine Grove, KYBuilt 1967 · S/N 18257829N262AKKempton Alan R · Lutz, FLS/N 25-0593N262APKirk Donald D · Fairbanks, AKBuilt 1975 · S/N 18502645N262BBFive Four November Inc · Littleton, COBuilt 1980 · S/N 25-0474N262BCTopflight Aviation Inc · Brentwood, TNBuilt 2010 · S/N 2062N262BGLarmore James N · Tucson, AZBuilt 2001 · S/N 0061N262CMyers Thomas · Hot Springs, ARBuilt 1981 · S/N 25-0520N262CACompass Aviation Inc · Shelby, NCBuilt 1981 · S/N U20606094N262CCHorton Charles M · Buckley, WABuilt 1962 · S/N NAV-4-2462N262CDSig Awy Inc Trustee · Wilmington, DEBuilt 2003 · S/N 1310N262DBElement Aviation Inc Trustee · Wilmington, DEBuilt 2008 · S/N 2915N262DGTouch And Go Aviation Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10141N262DQIschi Phillip · Soldotna, AKBuilt 1978 · S/N U20604479N262EAJeaps Aviation LLC · Edgewater, FLBuilt 2001 · S/N E-3417N262EZN262ez LLC · Canton, OHBuilt 1984 · S/N 25-0808N262GMRochester Air Center LLC · Canandaigua, NYS/N 1129N262GSMinor Michael D · Grove City, PAS/N 18265183N262JDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 3151N262JKPeachtree Aviation Inc · Woodstock, GABuilt 1981 · S/N 25-0584N262MBMurray Adventures LLC · Dallas, TXBuilt 1982 · S/N 25-0655N262MPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2004 · S/N 1425N262PMBig Bend Community College · Moses Lake, WABuilt 1992 · S/N CE-1681N262RKRegistration Pending · Corpus Christi, TXRegistration pendingBuilt 2006 · S/N 41649N262RNPro Southern Aviation LLC · Franklin, NCBuilt 2001 · S/N 0034N262RVT & J Air LLC · Wilmington, DEBuilt 1980 · S/N 25-0382N262RWMakino Kazuya · Fountain Valley, CABuilt 1982 · S/N 25-0649N262TFCirrus Design Corp · Knoxville, TNBuilt 2020 · S/N 4991N262TMSav LLC · Shelton, WABuilt 2023 · S/N 9051N262TYT3x LLC · Elkhorn, WIBuilt 2025 · S/N 10559
Back to AD 2000-23-21