OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669N1133APedota Darien · Northport, ALBuilt 1980 · S/N CE898N1133GGrannell Roy B · Southlake, TXBuilt 2009 · S/N 411126N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133N1134ABeaver Creek Aviation LLC · Clinton, OKBuilt 1997 · S/N E-3066N1134NFls LLC · Missoula, MTBuilt 2009 · S/N 411134N1134WAbs Aviation LLC · Cleveland, TNFirst renewal noticeBuilt 1997 · S/N E-3067N1134XWard Bernard Holman III · Wichita Falls, TXBuilt 1997 · S/N E-3074N1136ARegistered aircraftBuilt 1980 · S/N E-1694N1136GBurnside Thomas L · Kansas, ILBuilt 1978 · S/N 18266300N1136NPga Re LLC · Midland, TXBuilt 1996 · S/N E-3053N1136PBjmj LLC · Greensboro, NCBuilt 1996 · S/N E-3044N1136SBig Sky Beech LLC · Red Oak, IABuilt 1996 · S/N E-3054N1136VN1136v LLC · Sheridan, WYBuilt 1996 · S/N EA-592N1136YBonanza Aviation Inc Trustee · Wilmington, DEBuilt 1996 · S/N E-3050N1137MN1137m LLC · Bentonville, ARBuilt 1977 · S/N 21061921N11390Young Randy Jay · Spanish Fork, UTBuilt 2009 · S/N 411139N1139MMarshall J B · Talbott, TNBuilt 1975 · S/N 18264230N1139ZGonet John Charles · Southwick, MABuilt 1981 · S/N 25-0617N113ABSafford Aviation Service Inc · Coolidge, AZBuilt 1973 · S/N TC-1622N113AGOrban Cedric · Coral Springs, FLBuilt 1977 · S/N U20603750N113APInvictus Aviation LLC · Supply, NCBuilt 2015 · S/N T24002077N113AWMontana 1 LLC · Missoula, MTBuilt 1983 · S/N EA-346N113BHBighorn Airways Inc · Sheridan, WYBuilt 1967 · S/N 18051844N113BSHill Jason A · Cody, WYBuilt 1964 · S/N 18255205N113CMHuling Clinton D · Dutch Harbor, AKBuilt 1960 · S/N 18253043N113DFRegistered aircraftBuilt 1998 · S/N 3449062N113DSG D S Aviation LLC · Gatlinburg, TNBuilt 2020 · S/N 4977N113EDAlready Aviation LLC · Chattanooga, TNBuilt 2018 · S/N 4620N113FMaddox Jody S · Bouse, AZBuilt 1960 · S/N 52725N113FPPrice Ricardo Andres · Granbury, TXBuilt 2007 · S/N 42546N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072N113GSSchulte Flyers LLC · Union, KYBuilt 2004 · S/N 0934N113HBSnyder Shad J · Quincy, WABuilt 1983 · S/N 18268318N113HSOrion Aviation LLC · Springfield, MOBuilt 2013 · S/N 0484N113JLHare Richard C · Northville, MIBuilt 1966 · S/N D-8167N113JTAerotransplant Inc · Marfa, TXBuilt 1980 · S/N E-1729N113JVJohn Vance Enterprises LLC · Edmond, OKBuilt 2012 · S/N 0283N113KKolstad Christopher Van · Galata, MTBuilt 1975 · S/N 310R0107N113KKKns Air LLC · Portsmouth, NHBuilt 2018 · S/N 4724N113LCLcd Aviation Corp · Wilmington, DEBuilt 1969 · S/N 185-1459N113LSOwnship Aviation Solutions LLC · Huntsville, ALBuilt 1987 · S/N TH1531N113MRImpact Electric Inc · Temecula, CABuilt 2010 · S/N 0070N113PSSeales Paul · Port Isabel, TXBuilt 2017 · S/N 10011N113SGRac Global Aircraft Consulting LLC · San Marcos, CABuilt 1976 · S/N 18264758N113TBBeaudoin Todd · Castleton, NYS/N 18503772N113TNKn Air LLC · Sarasota, FLBuilt 2008 · S/N 31-0113N113TTHaley John R · Tomball, TXBuilt 1979 · S/N P21000281N113TWD'Antoni Gary L · Katy, TXBuilt 1973 · S/N D-9539N113VSaravis Darren S · Long Beach, CABuilt 1965 · S/N D-7958
Back to AD 2000-23-21