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.

N2980CBrown Cow LLC · Eagle River, AKS/N 30880N2980TMyers Thomas · Wills Point, TXBuilt 1966 · S/N 354N2980YLeisz Jeffrey A · Bloomington, INBuilt 1962 · S/N 18253980N2981KNiles Air LLC · Concord, NCBuilt 1980 · S/N 18053145N2981TKool-E5 LLC · Valdosta, GABuilt 1966 · S/N 355N2981YBeebe Michael · Rangeley, MEBuilt 1962 · S/N 18253981N29820Wtc Aviation LLC · Shreveport, LABuilt 2018 · S/N 4617N29821Jks Enterprises Inc · Park Rapids, MNBuilt 1972 · S/N 18261233N2982ASkywagon Pilots Inc · Santa Clara, CABuilt 1953 · S/N 30182N2982KHalcomb Billy J · Pond Creek, OKBuilt 1980 · S/N 18053146N2982MBergeron John E · Shenandoah, TXBuilt 1977 · S/N 28R-7803158N2983FHalle Michael P · Livingston, TXBuilt 1966 · S/N 18257083N2983TSlatter Lowell J · Buhl, IDBuilt 1966 · S/N 356N2984CRosser Brian K · Minden, NVBuilt 1954 · S/N 30884N2984YRondeb Aircraft LLC · Wilmington, DEBuilt 1962 · S/N 18253984N2985CBraham John P · Fairbanks, AKBuilt 1954 · S/N 30885N2985YJones Aviation Inc · Biggs, CABuilt 1962 · S/N 18253985N2986AMorris Blain E · Delta Junction, AKBuilt 1953 · S/N 30186N2986EYbarguen Johnny C · Rosenberg, TXBuilt 1982 · S/N 18268225N2986KSmith John F III · Middletown, DEBuilt 1980 · S/N 18053149N2987CYount Lawrence F · Shelton, WABuilt 1954 · S/N 30887N2987FRegistered aircraftBuilt 1966 · S/N 18257087N2987TDaly Arthur P · El Paso, TXBuilt 1966 · S/N 360N2988FTaf Aerial Services LLC · Beeville, TXBuilt 1966 · S/N 18257088N2988KMelvin Perry D · Warner Robins, GABuilt 1980 · S/N 18053151N2988TSwiftmeyers LLC · Benton Harbor, MIBuilt 1966 · S/N 361N2989TMid America Museum Of Aviation And Transportation · Sioux City, IABuilt 1966 · S/N 362N298CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1175N298CSCirrus Sr22 Somex Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1408N298FMStuart Scott · Lincoln, NEBuilt 2016 · S/N E-4098N298PJAxelrod Timothy S Trustee · Bandon, ORBuilt 2006 · S/N 71609N298SMSmb Flyer LLC · Queen Creek, AZBuilt 1973 · S/N 18262327N298VBEdholm Joseph · Lino Lakes, MNBuilt 1959 · S/N 50364N2990L&L Aviation Inc · Advance, NCBuilt 1963 · S/N 0038N2990ATottle K M DBA · Limington, MEBuilt 1953 · S/N 30190N2990CLyng Stephen G · Kenosha, WIBuilt 1954 · S/N 30890N2990KGundersen Timothy A · Henderson, NVBuilt 1980 · S/N 18053153N2990TStahl Bradford C · Jackson, CAS/N 363N2991FBerryessa Alan E · Cedarville, CABuilt 1966 · S/N 18257091N2991TRothgeb Michael A · Burns, ORBuilt 1966 · S/N 364N2991YRabska William G · Suisun City, CABuilt 1962 · S/N 18253991N2992TMeyers 200 LLC · Malden, MOBuilt 1966 · S/N 365N2993CFrei Jayci N · Grangeville, IDS/N 30893N2993FDaniels Aviation Inc · Inverness, MSS/N 18257093N2993TElghammer Garrott W · Niles, MIBuilt 1967 · S/N 366N2993YBranch Robert W · Fort Mohave, AZS/N 18253993N2994ADicicco Matthew Trustee · Los Gatos, CABuilt 1953 · S/N 30194N2994TZakraisek Donald S · Sandy, UTBuilt 1967 · S/N 367N29950Nichols William K · Bainbridge, GABuilt 1974 · S/N TC-1760N2995CAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1948 · S/N NAV-4-1727
Back to AD 2000-23-21