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.

N1ZRBio Mass LLC · Kalispell, MTBuilt 1977 · S/N P3370275N1ZTHolman Daniel P · Eagle River, AKBuilt 1954 · S/N 31597N1ZXAvstar Ltd DBA · London OntarionBuilt 1980 · S/N P3370349N2000M2000m LLC · Savannah, GAS/N 1475N2001BBangert Computer Systems Inc · Shawnee, KSBuilt 1966 · S/N D-8216N2001RAllen Aeronautics LLC · Mocksville, NCS/N 18255201N2001UWest Coast Resources Inc · Anchorage, AKBuilt 1967 · S/N 1060CN2002PGregory Edward · Council Bluffs, IABuilt 1979 · S/N 335-0022N2002RWentzel Jason A · Dupont, WABuilt 1963 · S/N 18255202N2002WWilliams Howard Dale II · Oklahoma City, OKBuilt 1965 · S/N D-7988N2003GHuntley Richard W · Bellingham, WABuilt 1958 · S/N 51303N2003NWiddoes L Curtis Jr · Friday Harbor, WABuilt 1997 · S/N 25-2005N2003RPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1963 · S/N 18255203N2004RMorasch Robert G · Walla Walla, WABuilt 1963 · S/N 18255204N2004WPeter Schiff Aero Inc · Cookeville, TNBuilt 1965 · S/N D-7966N2004XCovetous Inc · Fallbrook, CAS/N 18256104N2005GGreat Basin Aviation LLC · Eagle River, AKBuilt 1958 · S/N 51305N2005XTurnmire Jeffry B · Knoxville, TNBuilt 1965 · S/N 18256105N2006GYates Rodney R · Hubbard, ORS/N 51306N2006RBarclay Mechanical Services Of Utah Inc · Manti, UTBuilt 1963 · S/N 18255206N2007Bondair LLC · Seattle, WABuilt 2023 · S/N 9384N2007RDoc'S Flying Club LLC · Macon, GABuilt 1963 · S/N 18255207N2007TWinger Raymond E · Johnson, KSS/N 18258171N2007WChavez Jeremy · Fort Worth, TXBuilt 1965 · S/N CD-971N2008GChaump Michael · Reno, NVBuilt 1958 · S/N 51308N2008WSiamese Cat LLC · Issaquah, WABuilt 1965 · S/N D-7977N20098Registered aircraftBuilt 1999 · S/N 30-0029N2009FBowman And Dehn Enterprises Inc · Georgetown, DEBuilt 2016 · S/N 31-0143N200ARHelijet Holdings LLC · Wellington, FLBuilt 2004 · S/N 1122N200BJWright Thomas L · Clyde, OHBuilt 1975 · S/N 33701684N200BWGas Aviation LLC · Decatur, TNBuilt 1965 · S/N D-7954N200CBWarburton Patrick · Santa Rosa Valley, CABuilt 1973 · S/N TC-1517N200DFlipper 1 LLC · Fort Lauderdale, FLBuilt 1967 · S/N 379N200DPGrund Joseph R · North Cape May, NJBuilt 1979 · S/N 25-0090N200DRRowe Daniel · Alexandria, VABuilt 2019 · S/N 4860N200DSRathi Blythe P · Hayward, CABuilt 1974 · S/N 74-30699N200EFLame Deer LLC · Flemington, NJBuilt 1977 · S/N 28R-7703168N200EUSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1517N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503N200GDBowen Watson K · Abilene, TXBuilt 1988 · S/N CE-1264N200GRLpc Aviation Inc · Punta Gorda, FLS/N 1300N200HCIncredible Travels LLC · Celina, OHBuilt 2008 · S/N 3286N200JFAustin Steven G · Tigard, ORBuilt 1990 · S/N CE-1516N200LBBresciani Martin · Guaynabo, PRBuilt 2002 · S/N 0209N200LDFenske Jeffrey D · Gold Hill, ORBuilt 1973 · S/N 21059895N200LEAeromarine Holdings LLC · Waukesha, WIBuilt 1979 · S/N 310R1842N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271N200PSMerren R Todd DBA · Montgomery, ALBuilt 1967 · S/N 67-15030N200QBluth Marshall S · Great Neck, NYBuilt 1971 · S/N CE-339
Back to AD 2000-23-21