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.

N158RVVans Aircraft Inc · Aurora, ORBuilt 2001 · S/N 81541N158SFAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 172S10368N158SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4167N158SQGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-86N158TZBoney George C Jr Trustee · Chapin, SCBuilt 2000 · S/N 20037N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158N15901Harbor Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7310073N15909Downes Pamela M · Chino Hills, CABuilt 1972 · S/N 28R-7335104N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256N1590XLanders Stephen F · Riverview, FLBuilt 1975 · S/N 28R-7535344N15918Ramseier Peter A · Imperial Beach, CAS/N 28-7305185N15919Tikhomirov Anton · Ashland, MABuilt 1973 · S/N 28R-7335106N1591XTask Aviation LLC · Vancouver, WABuilt 1975 · S/N 32-7540180N15925Everglades Aviation Academy LLC · Weston, FLBuilt 1973 · S/N 34-7350109N15928Bussell Matthew W · Reno, NVBuilt 1973 · S/N 28-7305187N15929Cs Flying Ltd · Grafton, OHBuilt 1972 · S/N 28-7305188N1592RWilliams Brian S · Marietta, GABuilt 1975 · S/N AA5B-0092N15930Rogers Aviation LLC · Florence, SCBuilt 1973 · S/N 28-7305189N15931Smitty 172 LLC · Rockford, MIS/N 28R-7335108N15935Stahl Dennis E · Wood Dale, ILBuilt 1973 · S/N 28-7305190N15936Brown Norman C · Kewanee, ILS/N 28-7305191N15939Ray H Gregg · Nashville, GABuilt 1973 · S/N 32-7300021N1593XVaniscak Greg A · Fort Collins, COBuilt 1975 · S/N 28R-7535345N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197N1595RImpulsion Unlimited Inc · Huddleston, VABuilt 1975 · S/N AA5B-0095N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060N1596RTc Aviation Ltd · Fairbanks, AKBuilt 1975 · S/N AA5B-0096N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203N15979Tron Aviation LLC · Newburgh, INBuilt 1973 · S/N 28-7310079N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104N1598BTimerider Technologies Inc · Bishop, CABuilt 1982 · S/N 18268108N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210N15999Emmert Jason L · Douglas, WYBuilt 1973 · S/N 28-7310081N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245N159ARRobertson Duncan · ForfarNon-citizen corporation, flight hours not reportedBuilt 2007 · S/N 47013TN159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005N159DRPiedmont Flight Inc · Winston Salem, NCBuilt 1998 · S/N 18280128N159DSSmart Charles R · Verden, OKBuilt 1978 · S/N 70384N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816
Back to AD 2006-10-21