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.

N272TWillis Patrick A · Eugene, ORBuilt 1995 · S/N 21N272TCMiller Ralph · Fleming Island, FLS/N 001N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803N272VXSpence Lorne J · Saint Cloud, FLBuilt 2019 · S/N 140272N272WYSale Reported · Eden Prairie, MNSale reported, canceledBuilt 2016 · S/N 3272N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265N2731WUsrey Curtis R · Sullivan, INBuilt 1966 · S/N 1033N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202N2732WReik Martina · Novi, MIBuilt 1966 · S/N 1034N2733KRegistered aircraftBuilt 2006 · S/N 40517N2733RPatrick Barb · Farmer City, ILBuilt 1969 · S/N 28R-35275N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341N27349Valley Airways Inc · Scottsbluff, NEBuilt 1977 · S/N 31-7712087N2736SVmc Development Inc · Sanger, TXBuilt 2020 · S/N 81921N2736WMcnamara Jeffrey E Trustee · Riverside, CABuilt 1966 · S/N 1036N2738TProtac Aviation LLC · Highland, CAFirst renewal noticeBuilt 1967 · S/N TD-693N2738WMead James R · Jonesboro, ARFirst renewal noticeBuilt 1966 · S/N 260N2739CLge Flying Club Inc · Marietta, GABuilt 1978 · S/N R18200223N2739RPerrong Andrew R · Huntingdon Valley, PABuilt 1969 · S/N 28R-35279N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321N273BGates Hiram P · Faribault, MNBuilt 1959 · S/N 131N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CCN273FWeimer Heidi L · Knoxville, TNBuilt 1973 · S/N 32-7340138N273JTros Corp · Wilmington, DEBuilt 2017 · S/N 1211N273METopel Holdings LLC · Scottsdale, AZBuilt 2000 · S/N T20608217N273MJSmith Jeffrey W · Shreveport, LABuilt 1979 · S/N 32R-7985065N273RRJet Set Aircraft Inc · Van Nuys, CABuilt 1965 · S/N 27-3020N273SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4243N27405N27405 Holding LLC · Palm City, FLBuilt 1977 · S/N 31-7752164N2740RRegistration Pending · Wilmington, DERegistration pendingS/N 28R-35280N2740WBakewell Keith · Independence, LABuilt 1966 · S/N 1038N27418Sun Aircraft Management LLC · Ormond Beach, FLS/N 31-7752169N2741HEaa Aviation Foundation Inc · Oshkosh, WIBuilt 2014 · S/N 81180N2741WEdison Robert J · Anchorage, AKBuilt 1966 · S/N 1039N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94N27423Kadrmas Arnold E · Lewiston, IDBuilt 1977 · S/N 31-7752173N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284N2742RCollinsworth Frederick W · Broken Arrow, OKBuilt 1969 · S/N 28R-35281N2742WStraub R L DBA · Stanton, TXBuilt 1966 · S/N 1040N27447Laingkids LLC · Lewes, DEBuilt 1977 · S/N 31-7812022N27449Airchoice LLC · Manchester, IABuilt 1977 · S/N 31-7812025N2744VHerrenkohl Robert D · Bay Point, CAS/N 3346N2744WWilhelm LLC · Denver, COFirst renewal noticeBuilt 2004 · S/N 172S9644N27450Flying Oyster Investments II LLC · Apollo Beach, FLBuilt 1977 · S/N 31-7812027N2745MNfh Aviation LLC · Pikeville, KYBuilt 1999 · S/N 17280586
Back to AD 2006-10-21