OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N3573FLutke Michael T · Kalamazoo, MIBuilt 1966 · S/N 18257573N3573UHigginson James E · Bellingham, WABuilt 1963 · S/N 18254973N3573VShaules Daniel J · Billings, MTBuilt 1977 · S/N R1722258N3573YDesantis Robert George · Tavernier, FLBuilt 1962 · S/N 18254473N3574URegistered aircraftBuilt 1963 · S/N 18254974N3575YMeyer Robert J · Davis, CABuilt 1962 · S/N 18254475N3576UBinse Gerald R · Yuba City, CABuilt 1963 · S/N 18254976N3576YHmh Consolidated LLC · Lake Placid, FLBuilt 1962 · S/N 18254476N3577YClifton Oil & Gas LLC · Millville, DEBuilt 1962 · S/N 18254477N3578FJag Flying Club Inc · Morgantown, WVBuilt 1966 · S/N 18257578N3579FRoberts David J · Missoula, MTBuilt 1966 · S/N 18257579N3579UIou Aviation LLC · Sheridan, WYBuilt 1963 · S/N 18254979N3579YReal Property Services LLC · Bentonville, ARBuilt 1962 · S/N 18254479N357AFour Leaf Air LLC · Cedar, MIBuilt 2003 · S/N 29-0311N357AWWorldwide Aviation Services LLC · Anderson, SCBuilt 2014 · S/N L2K-169N357BDCoventry Air LLC · Parker, COBuilt 2013 · S/N 0618N357BMBargfrede Bernard Trustee · Blackburn, MOBuilt 2019 · S/N 1870N357CEWindh Steven R · Reedley, CABuilt 1962 · S/N 271N357CSN357c5 LLC · Clinton, MOBuilt 1984 · S/N 46-8508026N357DRegis Frederic · Denver, COBuilt 1967 · S/N D-8562N357GAOhm Aviation LLC · Merion Station, PABuilt 2010 · S/N 2070N357GKGk Aviation LLC · Orlando, FLBuilt 2024 · S/N 10140N357JR24 Air LLC · Orlando, FLBuilt 2023 · S/N 9108N357JTClub Bo A36 LLC · Helena, MTBuilt 1979 · S/N EA-51N357LCSkywagon Ventures LLC · Anchorage, AKBuilt 1981 · S/N 18504295N357MMClark Melvin G · Sunnyvale, TXBuilt 1985 · S/N 46-8508092N357NSKessler Garry A · Lansing, WVBuilt 1969 · S/N 33701222N357PGEike Properties LLC · Portland, ORBuilt 2011 · S/N 0261N357PSCarbren Capital LLC · Weatherford, OKBuilt 2025 · S/N 10546N357SHill V35 LLC · Nashville, TNBuilt 1967 · S/N D-8679N357VSavoy Harolde M Trustee · Dallas, TXBuilt 2004 · S/N L2K-186N357WMMentor Partners Inc · Springfield, ILBuilt 1960 · S/N BG-357N358Bipes Anthony · Forest Lake, MNBuilt 1967 · S/N 337-0737N35806Air Dakota Flite Inc · Hettinger, NDBuilt 1973 · S/N 21060011N3580UShiels Patrick Trustee · Flagstaff, AZBuilt 1963 · S/N 18254980N3581Lewis L Dwight Jr · Lopez Island, WABuilt 1961 · S/N 18051056N3582UMorton Construction Inc · Stillwater, OKBuilt 1963 · S/N 18254982N3582YErkens Ronald B · Queen Creek, AZBuilt 1963 · S/N 18254482N35837Smernoff Michael J · Des Plaines, ILBuilt 1975 · S/N U20602749N3583YCollins Carl H · Longview, TXBuilt 1962 · S/N 18254483N3584UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1963 · S/N 18254984N3584YHassler John Cameron · East Helena, MTBuilt 1962 · S/N 18254484N35851Northwest Passage LLC · Anchorage, AKS/N U20602757N35859Hooper Ranch LLC · Elko, NVBuilt 1975 · S/N U20602763N3585FArikara Properties LLC · Beulah, NDBuilt 1966 · S/N 18257585N3585UNieder Brady W · Anchorage, AKBuilt 1963 · S/N 18254985N3585YSeemann Brian N · Lake Havasu City, AZBuilt 1963 · S/N 18254485N35868Spence Flight Service LLC · Enterprise, ORBuilt 1973 · S/N U20602107N3586FRegistration Pending · Phoenix, AZRegistration pendingBuilt 1966 · S/N 18257586N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777
Back to AD 2000-23-21