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.

N1903HEsp Aviation LLC · Mason City, IABuilt 1977 · S/N 28-7790351N1903NFox Leonard A · Dubois, WYBuilt 2004 · S/N 01N1903SGriffin Products Inc · Wills Point, TXBuilt 1999 · S/N 1903N1904HSpyropoulos Basil P · Lake Geneva, WIBuilt 1977 · S/N 28-7790352N1906HTriplett Gregory L · Holden, MOBuilt 1977 · S/N 32R-7780199N1906SMiskovic Dejan · San Jose, CABuilt 1999 · S/N 1906N1907JDaedal Flight LLC · Lancaster, SCBuilt 1976 · S/N 14007N1908HSandlin James B · Surgoinsville, TNBuilt 1977 · S/N 32R-7780201N19093Gedney Douglas Kevin · Issaquah, WAS/N 17702556N1909SDennerline Rhett R · Northfield, ILBuilt 1999 · S/N 1909N1909YDuncan Lori Ann · New Tazewell, TNBuilt 1964 · S/N 204N190AGCarson Ryan P · Albuquerque, NMBuilt 1990 · S/N 10000N190AMMoghaddas Ali · Lake Sherwood, CABuilt 2010 · S/N 001N190AVNghiem Daniel · Westminster, CAS/N 2165N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103N190GESale Reported · Minden, NVSale reportedS/N 81689N190GTRincon Gabriel · Baton Rouge, LABuilt 2001 · S/N 2023N190HMn Helicopters Inc · Minneapolis, MNBuilt 2007 · S/N 4215N190KASpencer William D · Martinsville, VAS/N 1N190KTChupp Aaron A · Gallipolis, OHBuilt 2003 · S/N F003N190LPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeBuilt 2002 · S/N 172S9190N190MALightning Aviation LLC · Gillette, WYBuilt 2004 · S/N 40.355N190MEMenagerie Enterprises Inc DBA · Denison, TXBuilt 2012 · S/N 172S11190N190PHJohnson Cameron M · Worthington, MNBuilt 1977 · S/N 32-7740064N190RROrr John C · Longmont, COBuilt 1997 · S/N 23039N190RVMccormick David E · Antioch, ILBuilt 1998 · S/N 30424N190SEAlbritton Randy L · Camas, WABuilt 2021 · S/N 101N190TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N 31-8012040N190YSalo Mark W · Poulsbo, WABuilt 2005 · S/N 23085CN19103Mashburn Paul M · Cumming, GABuilt 1976 · S/N 17702557N1910YPeabody Riley A · Minnetonka, MNBuilt 1964 · S/N 205N19119Rose Randy J · Egg Harbor, WIBuilt 1976 · S/N 17702559N1911HAdair Aviation LLC · Mountain Home, ARBuilt 1980 · S/N R18201550N1911TSnp Aviation LLC · Avoca, IABuilt 1971 · S/N 28-7125412N1911VLefort Charles J · Redding, CABuilt 1974 · S/N 28-7405103N1911Y1911y Aviation LLC · Windsor, ILBuilt 2025 · S/N 42336N1912PSojourner Field LLC · Kouts, INBuilt 2014 · S/N 22483N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130N1912YFrokjer Dean C · Saint Croix Falls, WIBuilt 1964 · S/N 207N1913TWilliams Ronald P · Woodway, TXBuilt 1971 · S/N 28-7125474N1913YSchmitt William Joseph · Santa Cruz, CABuilt 1964 · S/N 208N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132N1915YJordan S Connor · Elizabeth City, NCBuilt 1964 · S/N 210N1916JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13182N1916YLarsen Adam P · Gresham, ORBuilt 1964 · S/N 211N1917LEpiphany Airmotive LLC · Frisco, TXBuilt 1976 · S/N M-1817N1917YMock Joseph R · Huntsville, TXBuilt 1964 · S/N 212N1918LBurt Christopher James · Leesport, PABuilt 1976 · S/N M-1813N1918TThompson Todd · Elmore, MNBuilt 1971 · S/N 32-7140060N19194Smokey Bear Air LLC · Cascade Locks, ORBuilt 2005 · S/N T18208428
Back to AD 2006-10-21