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.

N17ADOlear Daniel J · Warren, MIBuilt 1968 · S/N 690008N17AFRolle Caraine A · Cypress, TXBuilt 1973 · S/N 27-7405291N17AJJohnson Vernon G · Fort Worth, TXBuilt 2000 · S/N 589N17AKFrancis Joseph · Kure Beach, NCBuilt 1978 · S/N 27-7854103N17ARDer Kazarian Peter · Holden, MABuilt 1976 · S/N 32R-7780077N17AUHyatt Roy P · Coeur D Alene, IDBuilt 1998 · S/N 3257040N17AVWestchester Flying Club Inc · Purchase, NYBuilt 1983 · S/N 28-8390078N17BMNavigation Leasing LLC · Castle Rock, COBuilt 2023 · S/N 172S12978N17BYSudac Ivan · Boise, IDBuilt 2004 · S/N 945-2004N17CGOtt Kevin Dean · Orange Park, FLBuilt 1995 · S/N 3133N17CLRaymond Justin E · Descanso, CAS/N 28-7790444N17CRDawn Aviation LLC · Pierce City, MOBuilt 1965 · S/N 24-4093N17DKDiamond B Farm Inc · Gamaliel, KYBuilt 1961 · S/N 1712N17DLPonderosa Aviation LLC · Safford, AZBuilt 1969 · S/N 1866-42N17DSHilty Robert W · Wheatland, WYBuilt 1982 · S/N 461N17EMSegerstrom Ricky G Trustee · Grandview, TXBuilt 2006 · S/N 1580N17FRNoe Aviation Ok LLC · Watonga, OKBuilt 1998 · S/N 25020CN17FVStoltzfus Shawn D · Lancaster, PABuilt 1977 · S/N 28R-7737089N17GCDavis Michael D · Danville, VABuilt 1974 · S/N 409-HN17GEJet Nance LLC · Saline, MIBuilt 2002 · S/N GW-101N17GMNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12769N17GTBarnes Albert A · Jupiter, FLBuilt 1975 · S/N AA5B-0011N17HDAlcorn Margaret Aven · Simpsonville, KYBuilt 1998 · S/N 3246102N17HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2004 · S/N 18281436N17HYMorong William G · Lincolnville, MEBuilt 1999 · S/N 1454N17JFWorley William N IV · Ormond Beach, FLBuilt 1979 · S/N 14503N17KHHubatch Kenneth A · West Bend, WIBuilt 1991 · S/N 646-91N17MCMaplecross Wealth Management LLC · Cookeville, TNBuilt 1968 · S/N 32-40523N17MDMoyer David · Katy, TXBuilt 1966 · S/N 32-552N17MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12598N17NJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274527N17NLAerospatial Systems LLC · Boulder, COBuilt 1995 · S/N 014N17PFlying M LLC · Reno, NVBuilt 2008 · S/N 23106CN17PDSelph William D · Broxton, GABuilt 1994 · S/N 1675N17PEEberle Paul R · Topanga, CABuilt 1996 · S/N PE001N17PQStory Brian J · Noblesville, INS/N 1611N17PWPastron Willard P · Camano Island, WABuilt 1988 · S/N 5148N17PZPro-Air Of Oakland Inc · Birmingham, MIBuilt 1981 · S/N 28-8190255N17RABrisbin Robert · Melbourne, FLBuilt 1999 · S/N 27-0282N17RNOgopogo Foundation · Sonora, CAFirst renewal noticeBuilt 1976 · S/N 28-7790162N17SEcho Sierra LLC · Lawrenceburg, TNBuilt 1998 · S/N 3246N17SLTastad Joel M · Hager City, WIBuilt 1997 · S/N 1368N17TARetired Aviators Flying Club LLC · Oklahoma City, OKBuilt 1961 · S/N 24-2652N17TGGeesman John T · Mason City, IAS/N 1373N17WAKaestner Henry Todd · Franklin, TNBuilt 2020 · S/N 92284N17WEMckinney Joe M · Tuscumbia, ALBuilt 1978 · S/N 27-7854118N17WJAngel Wings Flyers LLC · Wilson, NCBuilt 1964 · S/N 2881N17WKOhnigian Steven P · Castle Rock, COS/N 2158N17XCState University Of Iowa · Iowa City, IABuilt 2018 · S/N CC19-0028N17YSJoslyn Larry J · Las Vegas, NVBuilt 1992 · S/N S1619
Back to AD 2006-10-21