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.

N20KPHulsey Ryan A · Cleveland, GAS/N 683N20LEQuality Leasing Inc · Niceville, FLBuilt 1994 · S/N 1809080N20LGYerena Mario Cesar Gutierrez · Bethel Island, CABuilt 1968 · S/N 28R-30491N20LKHobert Robert W Trustee · Penn Valley, CABuilt 2001 · S/N 21299N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119N20LTSeagull Services LLC · San Rafael, CABuilt 2003 · S/N 26015CN20LUCamas Wings LLC · Camas, WAS/N 685N20LXLockheed Martin Corporation · Palmdale, CABuilt 1975 · S/N 31-7552121N20MNRichardson William L · Houston, TXBuilt 1999 · S/N 425N20MRRegistered aircraftBuilt 1997 · S/N 21391N20MVElizabeth City State University · Elizabeth City, NCBuilt 2018 · S/N 172S12143N20NASchneider Adam R · Hutchinson, KSBuilt 1977 · S/N AA5B-0560N20NBStauffer Michael S · Wichita Falls, TXS/N 557N20NCJohnson Professional Aviation LLC · League City, TXS/N 559N20NDSheff Donald · Redwood City, CAS/N 687N20PAntique Preservation Association Of Greenfield · Greenfield, IABuilt 1968 · S/N 101MN20PSSolberg Kevin L · West Fargo, NDBuilt 1982 · S/N JSEB-1N20PVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496649N20QCHenderson Stephen L · Carthage, NCBuilt 1977 · S/N 28-7890227N20RDickerson Stephen R · Frisco, TXBuilt 1960 · S/N 24-1684N20RDSpurlin James Raleigh · Tomball, TXS/N 27008CN20RTTyson Richard E · Barton, FLBuilt 1966 · S/N 3309N20RVSadek Khaled · East Brunswick, NJBuilt 2026 · S/N 40453N20RXHayashi Linda · Playa Vista, CABuilt 1997 · S/N 017N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337N20SNHealy Edward · Fort Atkinson, WIBuilt 1987 · S/N 746N20SSBurton Scott C · Henderson, NVBuilt 1975 · S/N 61P-0248-043N20SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11623N20SVM&A Aircraft LLC · Rancho Cucamonga, CABuilt 2021 · S/N 3380N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677N20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2008N20TKVanguard Executive LLC · Elfers, FLBuilt 1987 · S/N 748N20TLN20tl LLC · Incline Village, NVBuilt 1987 · S/N 749N20TUClark Steven · Dade City, FLBuilt 1963 · S/N 159N20VCDanny J Daigle LLC · Greenville, MES/N 782N20VMHaney Kieron J · Irrigon, ORBuilt 1965 · S/N 918N20VTRegistered aircraftS/N 899N20WSeawind Mjw LLC · Wappingers Falls, NYBuilt 2000 · S/N 53N20XTDon Maxwell Aviation Service Inc · Longview, TXBuilt 1991 · S/N 28-0001N20YHuckabee Jim · Amarillo, TXBuilt 2000 · S/N 545320292FBN20YBBurdick Rich · Montrose, COFirst renewal noticeBuilt 1964 · S/N 2708N2100AAniakudo Obiesili · Northville, MIS/N 32R-7987002N2100DL A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N ME-41N2100SBietsch Aviation LLC · Dumfries, VABuilt 2004 · S/N 172S9589N21018Vega Aircraft LLC · Arcadia, OKBuilt 1978 · S/N 32R-7887186N21019Svetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9595N2101FVaughan Bradley C · Truckee, CABuilt 1978 · S/N 32R-7987064N2101GCarter James E · Thornville, OHBuilt 2004 · S/N T18208230N2101TTraylor John M · Helena, ALBuilt 1971 · S/N 28R-7135045N2101UVansurdam John R · Seneca, SCBuilt 1961 · S/N 147
Back to AD 2006-10-21