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.

N159KIsland Hopper Air LLC · Ponte Vedra Beach, FLBuilt 1959 · S/N 751N159LBBender Lyle D · Lincoln, NEBuilt 2009 · S/N 40403N159MHPw Air LLC · Rockingham, VABuilt 2001 · S/N 1135N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038N159RPHeadings Norman D · Walnut, ILBuilt 1997 · S/N 0342N159RRRatliff Randall L · Glencoe, OKBuilt 2018 · S/N 41712N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817N159SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4171N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159N15AGOber John A · Candor, NYBuilt 1966 · S/N 349N15ANAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13258N15BCWingsleasing LLC · Wichita, KSBuilt 1964 · S/N 28-1712N15BEAvalon Aviation USA Corp · Murfreesboro, TNBuilt 1981 · S/N R18201806N15BKBauer Mike · Little Rock, ARBuilt 1985 · S/N D.G.A.1N15BREllis David E Jr · Midlothian, TXBuilt 1978 · S/N 32R-7880004N15CASpirit Of Life Ministries International Inc · Carthage, TXBuilt 2005 · S/N 3257401N15CBAaviation LLC · Telford, PABuilt 1976 · S/N 28R-7635291N15CKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 10012CN15CMCarolina Aero Group LLC · Youngsville, NCBuilt 2004 · S/N 2280N15DEVlazny Stephen F · Divide, COBuilt 1992 · S/N 1N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333N15ETGfeller Steve · Thornton, WABuilt 2008 · S/N CC18-0026N15EXRich David R · Glastonbury, CTS/N 5496N15FGarvin Neal R · Avon, CTBuilt 1997 · S/N 001N15FACivil Air Patrol · Maxwell Afb, ALBuilt 1978 · S/N 17270117N15FBPropit Inc · Wilmington, DES/N 018N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112N15FYEsselme Aeronautics & Astronautics LLC · Annapolis, MDBuilt 2006 · S/N 71328N15GFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2019 · S/N 3324N15GLTubb Jeffrey Scott · Farmington, NMBuilt 2016 · S/N 1209N15HUBratton Gary · Poteau, OKBuilt 1996 · S/N 1318N15HYS&S Aviation LLC · Oakley, UTS/N 3328N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494N15JWTri-Cap International · Roanoke, TXBuilt 1959 · S/N TD-225N15KFH Aviation LLC · Celina, TXBuilt 1980 · S/N 32-8006073N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780N15LFNorthrup George William · Ellicottville, NYBuilt 1998 · S/N 1395N15MHRegistered aircraftBuilt 1979 · S/N 6107338062145N15MJRegistered aircraftBuilt 2024 · S/N 172S13005N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974N15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 172RG0115N15PQUsda Aphis Ws Atoc · Cedar City, UTBuilt 2010 · S/N CC18-0043N15PTThyssen Patrick L · Conroe, TXBuilt 2009 · S/N 40257N15PUNorth Valley Aircraft Inc · Valley City, NDBuilt 1989 · S/N 3015N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068N15SNRobinson Brian · Bedford, NHBuilt 2001 · S/N 25074CN15TABasham Kristina · Danville, CABuilt 2001 · S/N 6045N15TKSpence William D · Waller, TXBuilt 1988 · S/N 1N15TSSchell Timothy N · Dubois, WYBuilt 1996 · S/N 23802
Back to AD 2006-10-21