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.

N204SMKrug Lee A · Coatesville, PABuilt 2005 · S/N 70759N204TAAnderson Thomas W · Mustang, OKBuilt 1967 · S/N 680059N204YUFly Invest Inc Trustee · Wilmington, DEBuilt 1989 · S/N 910N20502Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12525N20505Hickin Barkley E · Kissimmee, FLBuilt 2001 · S/N 18280953N20506Lim Arnold · Walnut Creek, CABuilt 1997 · S/N 27-0238N2050CDow Jeffrey W · Port Hadlock, WAFirst renewal noticeBuilt 1959 · S/N TD-229N2050LMolak Marc E · Austin, TXBuilt 1976 · S/N M-1859N2050WKemp Jimmie F Jr · Saint Johns, MIBuilt 2002 · S/N 81153N20519Skyhawk Leasing LLC · Mccordsville, INBuilt 2004 · S/N 172S9576N20522Sale Reported · Paulista SpSale reported, canceledBuilt 1982 · S/N R18201924N2052RDybvig Abraham M · Bothell, WABuilt 1969 · S/N 28-5444N2052VBlue Sky Personnel Services LLC · Coushatta, LABuilt 2004 · S/N 172S9583N20536Joslyn Larry J · Las Vegas, NVBuilt 2001 · S/N S1818N20537Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12526N2053JPotgieter Johannes J · Madison, TNBuilt 2002 · S/N 21027N2053RRogers Tim R · Morgan Hill, CABuilt 1992 · S/N 1511N20540Baum Martin L · Bullard, TXS/N 27-4193N20549Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12527N2054CParker Jerry B · Arcola, TXBuilt 1959 · S/N TD-245N2054LDillon Roby · Rockport, INBuilt 1976 · S/N M-1860N2054MMcdonald Patrick R · Waverly Township, PABuilt 1977 · S/N 28-7890223N2054SLewis University · Romeoville, ILBuilt 2004 · S/N 17281203N2054ZRp3 LLC · Boise, IDS/N T18208449N2055RWnc Aviation LLC · Arden, NCBuilt 2004 · S/N 172S9581N20564Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12528N20566Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12530N2057LWilson Michael Joseph · Los Banos, CABuilt 1976 · S/N M-1861N2057PBullock Gary · Saint Regis, MTBuilt 2004 · S/N T18208227N20597Hk Aircraft Leasing LLC · Lititz, PABuilt 2005 · S/N 172S9947N205ABAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1966 · S/N 211N205APPappalardo Anthony · Vero Beach, FLBuilt 2000 · S/N 46-36250N205CSFillwock Bryan T · Saint Joseph, MIBuilt 1977 · S/N 24-0223N205DMSchmidt Myron Jake · Abingdon, MDBuilt 1999 · S/N 60205N205DSUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 2002 · S/N 40.205N205FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020205N205FGRidgeline Assets LLC · Wilmington, DEBuilt 2017 · S/N 172S12093N205GTRegistration Pending · Chesnee, SCRegistration pendingBuilt 2002 · S/N 2054N205HBMattes Michael Alan · Sherman Oaks, CABuilt 1977 · S/N 24-0288N205HCGulf Coast Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S10003N205HPBoyd Bill R · Kennett, MOBuilt 1973 · S/N M1696N205JBSolsrud David A · Little Falls, MNFirst renewal noticeBuilt 1992 · S/N 713TDN205JHHarlan John M · Cedar Park, TXBuilt 1998 · S/N K055N205KDBats Aero LLC · Missoula, MTBuilt 1986 · S/N 24-3017N205MAWarbird Adventures Inc · Ocoee, FLBuilt 1979 · S/N 530-79N205MXHlavnicka Thomas L · Big Sandy, MTBuilt 1999 · S/N 15006CN205PLQuinones Luis I · Gaithersburg, MDBuilt 1987 · S/N 24-3020N205RGKeating Kevin C · Asheville, NCBuilt 1988 · S/N 243078N205RLAlcott Thomas J · Jacksonville, ILBuilt 1987 · S/N 24-3022N205SF242 Skies LLC · Troutman, NCBuilt 1977 · S/N 32R-7780311
Back to AD 2006-10-21