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.

N123YHills David F · Nampa, IDBuilt 2009 · S/N 40278N123YWMaxwell Truck And Equipment LLC · State College, PABuilt 2005 · S/N 10606N1240JRinger Kevin L · Grants Pass, ORS/N 240N1240XPioneer Aviation LLC · Boise, IDBuilt 1963 · S/N 113N12419Fort Wayne Aircraft LLC · Fort Wayne, INBuilt 2006 · S/N 172S10306N1242BMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10307N1242JLouisiana Aviation LLC · Marksville, LABuilt 1974 · S/N 242N1242NBg-Ip LLC · Saratoga, CABuilt 2006 · S/N 172S10309N1242TDoblmaier Thomas J · North Wales, PABuilt 1972 · S/N 28-7205272N1242XCarpenter Charles P · Tarzana, CAS/N 115N1244XLackey Lance Harold · New Braunfels, TXBuilt 1963 · S/N 117N1246CTriplett Michael D · Eastsound, WAS/N 17702689N1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingBuilt 1972 · S/N 32-7200034N1247JSalazar Raul · Bradenton, FLBuilt 1975 · S/N 247N1248EBoling Derek · Paragould, ARBuilt 2005 · S/N 18281590N1249VAguilar Perez Jose L · Newton, MABuilt 1976 · S/N 27-7654046N124ABBergevin Steven C · Evergreen, COBuilt 2003 · S/N 008N124AGPegasus Enterprises LLC · Granbury, TXBuilt 1978 · S/N 31-7852103N124ASJm Helicopters And Cattle LLC · Boynton Beach, FLS/N 11232N124BDMoore Kathryn Cv Julianne · Aguila, AZBuilt 1971 · S/N 124N124BSLeair LLC · Eufaula, ALBuilt 2004 · S/N 18281390N124CKChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9808N124CTPavilonis Anthony H · Beaver, PABuilt 2011 · S/N 70124N124EFGuerrer Daniel S · Redondo Beach, CABuilt 1998 · S/N 18280315N124EWWicker Jeremy · Glen Saint Mary, FLBuilt 2022 · S/N 001N124HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9632N124HHRotorwing LLC · Sheffield, ILBuilt 2008 · S/N 12267N124HKDavid A Desimone LLC · Newnan, GAS/N R18201621N124HULeaders Kurt W · Clear Lake, MNBuilt 1998 · S/N 1413N124HWMckee Ethella C · Green Castle, MOBuilt 1989 · S/N 100N124JCDestination Aviation LLC · Destin, FLBuilt 1965 · S/N 28-2340N124JDBailes Christopher · Orlando, FLBuilt 1999 · S/N 2843239N124JKLewis Fred · Houston, TXBuilt 1966 · S/N 1046N124KAJohnson Michael Scott · Edgewood, TXBuilt 1974 · S/N 17702181N124KYMozzie Air LLC · Tampa, FLBuilt 2005 · S/N T18208453N124LCarlson Glenn E · Las Vegas, NVBuilt 1986 · S/N 40N124MARobison Ronald D · Idaho Falls, IDBuilt 1978 · S/N R18200627N124MCMonteleone Gene R · Mont Vernon, TXBuilt 1979 · S/N 502-79N124NREckhoff Daniel · Ramsey, MNBuilt 1960 · S/N 24-1839N124PJNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1964 · S/N 17252491N124STalovich Kenneth · Groveland, CABuilt 2001 · S/N S696N124SBHumphrey Eric L · Wichita, KSBuilt 2003 · S/N 1N124SCK2 Worldwide Inc · Simi Valley, CAS/N 8822001N124SGFull Props LLC · Ridgeland, SCBuilt 2008 · S/N 1071-2008N124SLSl Aviation LLC · Kalispell, MTBuilt 2021 · S/N 3382N124VURyan Jeffrey R · O Fallon, ILBuilt 1991 · S/N 10060N124WABraswell Jerrold W · Dillingham, AKS/N 31-7405242N124WEMidwest Aviation Inc · Mayfield, KYBuilt 2019 · S/N 172S12393N124WJSessions Thomas Eric Trustee · Huffman, TXBuilt 2004 · S/N 18281475N124XAgold Todd R · College Station, TXBuilt 2016 · S/N 40362
Back to AD 2006-10-21