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.

N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075N408JCN408jc LLC · Scottsdale, AZBuilt 1977 · S/N E-1194N408KMRivers Aviation LLC · Houston, TXBuilt 2022 · S/N 8968N408LABeach Bound Flyers LLC · Mountain Brk, ALBuilt 1979 · S/N 25-0074N408LJHuston Craig C · Keokuk, IABuilt 1975 · S/N 18264147N408NDKnowlton Dane F · Camden, ALBuilt 2005 · S/N 1599N408PGJs Extra 300 LLC · Dallas, TXBuilt 2008 · S/N 2984N408RStone Aviation LLC · Cusick, WABuilt 1954 · S/N 31149N408RFFogel Services Inc · Ladson, SCBuilt 2024 · S/N 9895N408WRocket 57 LLC · Scottsdale, AZBuilt 2016 · S/N 001N408WGBlue Sky 408 LLC · Lakeland, TNBuilt 2009 · S/N 3565N408WTTrophy Adventures LLC · Bondurant, IABuilt 2020 · S/N 2063N408XQuint Jeane E · Janesville, WIS/N 6184CN4090ATop Gun Aviation Group Inc · Santa Monica, CABuilt 1978 · S/N 310R1368N4090HSouthern Air Transport Services LLC · Dover, DEBuilt 1969 · S/N 18052083N4090SByerly Brooks · Plano, TXBuilt 1975 · S/N E-645N4091GRobinson Brant Fitzgerald · Powder Springs, GABuilt 1977 · S/N 340A0275N4091SBeechcraft Heritage Museum · Tullahoma, TNBuilt 1975 · S/N CE-556N4092TEnnyx LLC · Clermont, FLBuilt 1974 · S/N E-556N4093DZito Nick D · Ellensburg, WABuilt 1957 · S/N 34793N4093EDmkr LLC · Coronado, CABuilt 1999 · S/N E-3293N4093HWilliams Charles · Wolfeboro, NHBuilt 1980 · S/N 25-0404N4094BClosson Luke E Jr · Valdosta, GABuilt 1975 · S/N 75-30782N4094DManker Lance M · North Platte, NEBuilt 1957 · S/N 34794N4094HRichardson Scott A · Kalispell, MTBuilt 1980 · S/N 25-0411N4094S4094s LLC · Holly, MIBuilt 1975 · S/N TC-1840N4095AValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 18503910N4095DRedfern Ronnie M · Fairbanks, AKBuilt 1957 · S/N 34795N4096DSkydive Cape Cod Inc · Caddo Mills, TXBuilt 1958 · S/N 34796N4096SSmith Timothy M · Mount Pleasant, WIBuilt 1975 · S/N TC-1842N4096VWtw Air LLC · Houston, TXBuilt 1977 · S/N R1722272N4097H1234g LLC · Topeka, KSBuilt 1980 · S/N 25-0416N4098DAspegren Robert N · Vacaville, CABuilt 1958 · S/N 34798N4098HLance Aero Inc · Mechanicsburg, PAS/N 25-0417N4099SDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N TE-1037N409ACHighland Holdings LLC · Bethlehem, PABuilt 1966 · S/N 336N409BKHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0651N409CDArmbruster LLC · Amherst, OHBuilt 2005 · S/N 1286N409CFFox Charles · Massapequa Park, NYBuilt 2005 · S/N 1600N409HAFalcon Flight And Investments LLC · Lewes, DEBuilt 2008 · S/N 411039N409MFenton Richard O · Weatherford, TXBuilt 1969 · S/N D-8981N409PValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N E-3656N409PCSmith Lowry Carl Trustee · Leedey, OKBuilt 2007 · S/N 29-0488N409PDIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1973 · S/N CE-450N409PKSky Cowboy Supply Co LLC · Cape Elizabeth, MEBuilt 1978 · S/N 18503721N409RCrawford Russell W · Hurricane, UTS/N D-6011N409SJKirsh & Kirsh P C · Indianapolis, INBuilt 2005 · S/N 42084N409SSBlackwell Aviation Inc · Bell Vernon, PABuilt 1965 · S/N D-7952N409THQualitair LLC Trustee · MichelstadtS/N 337M0375N409TTMad Dog Air LLC · Spotsylvania, VABuilt 2009 · S/N 421020
Back to AD 2000-23-21