AD 2012-10-13

Registered aircraft · 13,306

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:2012-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
  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.

N817AMDiversified Air Services LLC · Edmond, OKBuilt 2023 · S/N 9092N817BGBcac Air Ventures LLC · Weatherford, TXBuilt 2025 · S/N 11062N817BJMax Flight LLC · Amherst Junction, WIBuilt 2025 · S/N 10653N817BKChase Aviation Co LLC · Jamestown, NYS/N 1255N817CVAltier Aviation LLC · Throop, PABuilt 2025 · S/N 10902N817DGAuto Mark Inc · Bismarck, NDBuilt 2019 · S/N 4786N817DLAltidudes LLC · Atlantic Beach, FLBuilt 2018 · S/N 1762N817GCMountain View Aeromotive Inc · Del Norte, COBuilt 1975 · S/N 310R0264N817GFHarvey Michael · Coppell, TXBuilt 2020 · S/N 2117N817HHS&M Partners LLC · Carmel, INBuilt 2019 · S/N 4756N817JPOdom Johnny C · Fredericksburg, TXBuilt 1976 · S/N 414-0850N817LAUnger William · Missouri City, TXBuilt 1994 · S/N E-2852N817NMWest Bound Hound LLC · Sheridan, WYBuilt 1979 · S/N EA-27N817PHPhh Family Equipment Holdings LLC · Fort Worth, TXBuilt 2023 · S/N 9555N817RMOmega Metals Inc · Douglasville, GABuilt 1981 · S/N EA-203N817SEChh Aviation Inc · Tyler, TXBuilt 2006 · S/N 2209N817SRMarsh Aviation LLC · Old Lyme, CTBuilt 2007 · S/N 2514N817TAAspen Aviation Inc · Crown Point, INBuilt 2023 · S/N 9553N817TMHorn Associates LLC · Brookline, MABuilt 2020 · S/N 4988N817WTN817wt LLC · Omaha, NEBuilt 2013 · S/N 4017N8181VPebble Alternative LLC · Harahan, LABuilt 1991 · S/N E-2610N8183EGuardado Rodolfo · Sun Valley, CABuilt 1991 · S/N E-2612N8183MHaman Peter A · Douglas, WYBuilt 1977 · S/N 21062033N8184NB & S Holdings LLC · Augusta, GABuilt 1991 · S/N E-2648N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638N8188RRepka Michael Jeffrey · Glenbrook, NVBuilt 2024 · S/N 9784N8189Doan Aviation LLC · New Hope, PABuilt 2026 · S/N 11122N818AB818ab LLC · Gainesville, FLBuilt 2006 · S/N 1953N818ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0501N818CSSands Christopher W · Chandler, AZBuilt 2009 · S/N 313N818DLTt1 Marine LLC · Key Largo, FLBuilt 2002 · S/N 0284N818ELN22tq LLC · Lehi, UTBuilt 2024 · S/N 10186N818GMDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 0256N818HWHannah Mary Aviation LLC · Camden, DEBuilt 2025 · S/N 10792N818JECbft LLC · Mobile, ALBuilt 2025 · S/N 10944N818JPN818jp LLC · Los Angeles, CABuilt 1984 · S/N 46-8408047N818LARegistered aircraftBuilt 1994 · S/N E-2868N818LMTop Flight Holdings LLC · Bluffdale, UTBuilt 2018 · S/N 1778N818LTAirworthy LLC · Scottsdale, AZBuilt 2016 · S/N 4354N818PDesmet Paul F · Mercersburg, PABuilt 1986 · S/N E-2352N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803N818PKAdamant Hangars LLC · Erie, COBuilt 2024 · S/N 10338N818PRMalus Flyers LLC · Henderson, NVBuilt 2001 · S/N E-3397N818TBSmith Av LLC · Kalispell, MTBuilt 2021 · S/N 2453N818WKTennessee Wk LLC · Wappingers Falls, NYBuilt 2024 · S/N 10299N8190GSchubert Jackie E Jr · Jamestown, TNS/N E-2658N8191KSummerfields Animal Hospital Pllc · Fort Worth, TXBuilt 1991 · S/N E-2662N8195QD&M Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 414-0095N8198MGokul LLC · Landrum, SCBuilt 1993 · S/N E-2787N819BWCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11611
Back to AD 2012-10-13