AD 2006-10-21

Registered aircraft · 44,908

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:2006-10-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:2006-10-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.

N1919UD&S Aviation LLC · Spring, TXBuilt 2025 · S/N 172S13295N1919YSu Ryan · Saint Augustine, FLBuilt 1964 · S/N 214N191ABRegistration Pending · Newport, ORRegistration pendingBuilt 1963 · S/N 2471N191ACLoewen Jason Scott · Wenatchee, WABuilt 1993 · S/N 711-93N191BCZabrosky Air LLC · Cedar Hills, UTBuilt 1973 · S/N 28R-7435088N191CACsa Aircraft Leasing LLC · Salt Lake City, UTS/N 17281243N191DHLee Kevin B · Beulah, NDBuilt 1999 · S/N 2035N191DJScallion Leon Ivy · Pine Bluff, ARBuilt 1965 · S/N 3206N191FAHarvey Taz E · Danville, CABuilt 2003 · S/N T18208191N191GCHughes Aviation LLC · Bedford, NHBuilt 1991 · S/N 10020N191HCTrinair Aviation LLC · Hampshire, ILBuilt 1965 · S/N 2992N191JStyer David B · Pendleton, ORBuilt 1977 · S/N 390N191JSStaben Jon C · Freeport, ILBuilt 2006 · S/N 0305N191JWWatkins James P · Bakersfield, CABuilt 2015 · S/N 0269N191MPate Earl G · Hickory, NCBuilt 1992 · S/N 20109N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003N191PALa Mooneytte LLC · Seabrook, SCBuilt 1964 · S/N 248N191PCBad Attitude LLC · Lisbon, OHBuilt 2002 · S/N 896-2002N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229N191RLOpen Air Properties LLC · Jonesboro, ARS/N 14575N191RVSpurgeon Michael · Nashville, TNBuilt 1978 · S/N 32R-7887051N191SBRasch Hellmut G · Tomball, TXBuilt 1999 · S/N 24417N191SSRoberts Anthony Curtis · Dallas, TXBuilt 1998 · S/N 3165N191TASanborn Map Company Inc · Colorado Springs, COBuilt 1974 · S/N 31-7401230N191XRosendahl Paul O · Sangar, TXS/N 129N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686N1920JDerrick James E · Godley, TXBuilt 1976 · S/N 14020N1921Koons Zachary K · Clinton, ILBuilt 1993 · S/N 20580N1922LGassi Vito · Levittown, NYBuilt 1976 · S/N M-1819N1922YDurso Joseph M Jr · Mesa, AZBuilt 1964 · S/N 217N19234Sharkey William Patrick · Walla Walla, WABuilt 1976 · S/N 17702563N1923RUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 1217-2024N1923YHyde Joe G · San Angelo, TXBuilt 1964 · S/N 218N19245Immel Justin Harrison · Minonk, ILBuilt 1976 · S/N 17702564N1924YHull Thomas · Midland, TXS/N 219N1925YMapes Peter B · Oscoda, MIBuilt 1964 · S/N 220N1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2025 · S/N 172S13436N1926YRoss Dustin · Georgetown, TXBuilt 1964 · S/N 221N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566N19277Roundtree Sod Service Inc · Jacksonville, FLBuilt 2005 · S/N T18208437N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017N1928YMaddex William E · Battle Ground, WAS/N 235N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416N192AMN34cc LLC · Liberty, NCBuilt 2021 · S/N 2881507N192CAVines Allen E Jr · Hoover, ALBuilt 2007 · S/N 1048-2007N192CCU S Department Of The Interior · Boise, IDBuilt 2012 · S/N CC18-0056N192DBTodd Tracy · Lancaster, SCBuilt 1976 · S/N 14021N192JHHogue James B · Spencer, TNBuilt 1992 · S/N 669-92N192JPBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2005 · S/N 172S9894N192MCWarrington Flying Club Inc · Doylestown, PABuilt 2006 · S/N 172S10162
Back to AD 2006-10-21