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.

N25208Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13393N25212Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13396N25213Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13399N25218Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13402N25219Octopus Flying Club Inc · Riverdale, MDS/N 970N2521NOpen Heavens Aerospace LLC · Fort Gratiot, MIS/N 901N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641N2522Garella Craig W · Edwardsville, ILBuilt 2020 · S/N 42006N25220Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13405N2522BRossman Brian · Valparaiso, INS/N 863N2522DMiller Stephen · St Louisville, OHS/N 872N2522PPfisters Helicopters Inc · Pasco, WABuilt 2014 · S/N 2352N2523ZBchr Aviation LLC · Boerne, TXBuilt 1977 · S/N 337-77N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196N2524ZEgan Brian M · Saint Charles, ILBuilt 1977 · S/N 338-77N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180N25259Miller Eric J · Mendocino, CAS/N 982N2525SJbird Aviation LLC · Elizabeth City, NCBuilt 2025 · S/N 1225-2025N2526SPlane Nutz LLC · Sugar City, IDBuilt 1979 · S/N R18201347N2527DSidders Michael E · Big Lake, AKS/N 20679N2527UDeljanovan Trucking LLC · Roaring Branch, PABuilt 1979 · S/N 28-8090050N2528Morrison Garrett B · Lodi, CABuilt 2016 · S/N 7149N2528EMr Dent Inc · Manheim, PAS/N 869N2528UPensacola Navy Flying Club · Pensacola, FLBuilt 1979 · S/N 28-8090051N252AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281185N252AXFrequency Change Aviation Services Inc · Nashville, TNBuilt 2004 · S/N 40.392N252CERegistration Pending · Springtown, TXRegistration pendingBuilt 2003 · S/N 4166N252CMRouse Peter L · Parkville, MOBuilt 1996 · S/N 4002N252CWNelson Shalom Z · Washington, DCBuilt 2004 · S/N 31N252DZBernardo Mark · Middleton, MABuilt 1978 · S/N AA5B0736N252EJJohnson Eldridge Jr · Chicago, ILBuilt 1997 · S/N 18280044N252EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13286N252MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881444N252PGHard Rock Milling LLC · Spring Branch, TXBuilt 2010 · S/N 60225N252PSFields Joseph H · Placerville, CABuilt 1999 · S/N 5334N252RWatkins John Jr · Summerfield, NCBuilt 1977 · S/N 32R-7780175N252SPSkysuite Aviation LLC · Tujunga, CAS/N 172S8228N252STEl-Li Copter Associates LLC · Spring Valley, WIBuilt 2007 · S/N 2116N252SZMitchell Jeff · Reno, NVBuilt 2006 · S/N 5705N252TTRex Ron · Ocala, FLBuilt 2015 · S/N 1208N252UWyatt Gregory P · Cheyenne, WYBuilt 2001 · S/N 2143N252WYWarner Robins Air Service Inc · Cochran, GABuilt 2016 · S/N 3252N252YUltimatetoweds LLC · Sedalia, MOBuilt 2018 · S/N 3309N2530WHeir Michael R · Clarksville, MDS/N 950N2531RMaierhoffer Henry F Jr · Sylvania, GAS/N 28-5642N2531YPremier Aviation LLC · Sioux Falls, SDBuilt 1985 · S/N 28-8590083N2532DSherlock William H · Greenbrae, CABuilt 1989 · S/N 868N2532MNolan John R · Colorado Springs, COS/N 897N2532WFrontier Flyers LLC · Anchorage, AKBuilt 1974 · S/N MC-207N2533WH&A Aircraft Services LLC · Omaha, ARBuilt 1973 · S/N MC-208
Back to AD 2006-10-21