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.

N2464RStoffers William · Samoa, CABuilt 1964 · S/N 18255564N2465CToal Timothy R · Milan, ILBuilt 1954 · S/N 30765N2465GMunson Darrel L · Ogallala, NEBuilt 1959 · S/N 51765N2465TDenna David · Port Charlotte, FLBuilt 1962 · S/N NAV-4-2465N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365N2466GIreland Jeffrey L · Shobonier, ILBuilt 2004 · S/N 1244N2466QWentworth Douglas G · Simpsonville, KYBuilt 1966 · S/N 18257666N2466RToland Beldon T · Dodge City, KSBuilt 1964 · S/N 18255566N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669N2467GShort David J · Warrensburg, MOBuilt 1959 · S/N 51767N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567N2468BRegistered aircraftBuilt 1970 · S/N 18260274N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768N2468GWilliams Recycling Co Inc · Newport Coast, CABuilt 2018 · S/N E-4123N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568N2468SStolen Hours LLC · Sanford, NCBuilt 2004 · S/N 1090N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569N2469TJustice Construction Corp · Friendsville, TNBuilt 1962 · S/N NAV-4-2469N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369N246ALAiror LLC · Lees Summit, MOBuilt 1978 · S/N E-1412N246BGuynn Dane L · Peachtree City, GAS/N 310K0030N246BCKeystone Solutions LLC · Higley, AZS/N 18259539N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841N246BJJas Aviation LLC · East Hartford, CTBuilt 2005 · S/N 1438N246BMBlue Oasis Flight Support · Tamarac, FLBuilt 1978 · S/N 34-7870083N246BSCk Leasing Services LLC · Wilmington, DEBuilt 2016 · S/N 2324N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769N246BWRc Sun Enterprises Inc · Loveland, COS/N 79-30930N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314N246CMHarmon David · Abilene, TXBuilt 2013 · S/N 3929N246CRBcah LLC · Scottsdale, AZBuilt 2017 · S/N 1493N246CTThomas Charles E · Mokena, ILBuilt 1999 · S/N 23597N246CVStatus Aviation Group LLC · Red Lodge, MTBuilt 2024 · S/N 9901N246DBOps Check LLC · Niceville, FLS/N 2704N246DDSmart Roger M · Hot Springs, ARBuilt 2011 · S/N 82884N246DYWilson Ralph W Trustee · Mentor, OHBuilt 1996 · S/N E-3065N246EEBaldwin Alexander L · Saint Charles, MOS/N D-6797N246EGRosen Gary J · Manchester, MABuilt 2025 · S/N 10594N246EMRjmr Capital Holdings LLC · Tyler, TXBuilt 2020 · S/N 4913N246FAInternational Air Services Inc Trustee · Carson City, NVS/N 1153N246GMSky Scrapers LLC · Derry, NHBuilt 2002 · S/N 0260N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355N246JAN246ja LLC · Parsons, TNBuilt 2025 · S/N 10448N246JPCarolina Aviation Partners LLC · Winston Salem, NCBuilt 2019 · S/N 1844N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659N246LSJohnson Mark · Macon, MSS/N 32185N246MTKolquist Consulting LLC · Hermantown, MNBuilt 2003 · S/N 0760
Back to AD 2000-23-21