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.

N28053Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881379N2805RMurphy Tyson L · Greensboro, NCS/N 1138N28065Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881380N28069Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881381N2806MCondor Aero Club Inc · Zelienople, PABuilt 1977 · S/N 28-7890270N2806TN2806t Leasing Company LLC · Mason, MIBuilt 1972 · S/N 28-7205223N28079Abadir Peter · South River, NJS/N 1140N2807RHayzan Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28R-35294N2807TSale Reported · Broxton, GASale reported, canceledBuilt 1972 · S/N 28-7205224N28086Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881392N28088Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881393N2808WParker David G · Sedona, AZS/N 1083N2809Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010051N28090Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881394N28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2020 · S/N 2881395N28096Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881405N28098Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881406N2809ENorth Marin Air LLC · Petaluma, CAS/N 1141N280AL2e2 Corporation · Menlo Park, CABuilt 1980 · S/N 1210N280AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496511N280ASBravo Aviation Club LLC · Cary, NCBuilt 1977 · S/N 32R7780155N280CSYolo Farms LLC · Raleigh, MSBuilt 1999 · S/N 18280511N280DABouffard Marcel · Flowery Branch, GABuilt 1977 · S/N 28R-7737154N280ERNew Course Aviation Co · Golden, COBuilt 2005 · S/N 2110N280FGFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496525N280FSAirflight LLC · Wilmington, DEFirst renewal noticeBuilt 2003 · S/N 2094N280GACavanaugh Flying Service Inc · Minden, NEBuilt 1998 · S/N 2009825FN280HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2843733N280HRMussen Gary L · Exeter, CABuilt 1995 · S/N 32N280JAFlying Tigers Flight School Ltd · Houston, TXBuilt 2000 · S/N 172S8620N280JBS & S Properties Inc · N Kansas City, MOBuilt 1998 · S/N 3257043N280JSStefanini Joseph M · Akron, OHS/N 1510N280KCMccarty Anthony O · Saint Augustine, FLBuilt 1999 · S/N 4636219N280KTGetchell Investments LLC · Dallas, TXBuilt 2002 · S/N 4636329N280LASeipp Stephen C · Laurel, DEBuilt 1999 · S/N 2085N280MMrr Spraying LLC · Shelby, MTFirst renewal noticeS/N 749N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004N280MBWeber Donald E · St David, AZBuilt 1975 · S/N 3255N280MHGulf Coast Helicopters Inc · Pearland, TXBuilt 1988 · S/N 2022N280MLLundy Michael · Stephenville, TXS/N 2032N280NARohner Harlan G · Willmar, MNS/N 2058N280PEBravo Leasing LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10834N280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 11070CN280SHRottor Aviation LLC · Jasper, INBuilt 2003 · S/N 2095N280SMAirpark Aviation LLC · Manchester, NHBuilt 1999 · S/N 2083N280SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12432N280UOhio University · Athens, OHBuilt 2003 · S/N 172S9464N280WLWalloon Air LLC · Oakwood, OHBuilt 2025 · S/N 3450N28103Hawksyntketics LLC · Jacksonville, FLS/N 78-31150N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137
Back to AD 2006-10-21