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.

N28BSamsen Andrew · Danville, INBuilt 2023 · S/N 9165N28BKMooster Aviation LLC · Niceville, FLBuilt 2023 · S/N 9199N28BRFlying Rock Aero LLC · Sunnyvale, CABuilt 1986 · S/N 468608045N28BXBoyle Brendan C · Apex, NCBuilt 2025 · S/N 10904N28CCGulf Airbatics Ltd · Jennings, LABuilt 1979 · S/N 414A0226N28FNValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10834N28HWRuthie 54 LLC · Logan, UTBuilt 2022 · S/N 8663N28JGStrathy Gregg M Trustee · Eugene, ORBuilt 2015 · S/N 1130N28JMWestern Aviation Services LLC · Cheyenne, WYBuilt 1979 · S/N P21000431N28KGValiair Limited Co Trustee · Casper, WYBuilt 2023 · S/N 9067N28KYSoldo Joseph Peter · Chattanooga, TNBuilt 1984 · S/N 468508015N28LVCactus Clover Inc · El Paso, TXBuilt 1979 · S/N 340A0754N28MGHudson Equipment LLC · Camden, DEBuilt 1988 · S/N TH-1535N28NWFixed Gear Sportsman LLC · Seattle, WABuilt 2017 · S/N 4540N28RLTbda LLC · Wilmington, DEBuilt 2019 · S/N 1965N28RSElohim Airparts Sales LLC · Naples, FLBuilt 1970 · S/N 21059316N28SNAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2018 · S/N 1729N28SPCactus Aviation LLC · Pleasanton, CABuilt 2025 · S/N 10704N28TDGravity2 LLC · Ramsey, NJBuilt 2025 · S/N 10733N28TKLos Cielos Flyers LLC · San Antonio, TXBuilt 2002 · S/N 0263N28UMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9798N29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLS/N 21059778N2902VArnold Thomas E · Casper, WYBuilt 1947 · S/N 118N29084D E C Holdings · Hansen, IDBuilt 1972 · S/N 21059798N290CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0297N290JCirco Industries 2 LLC · Belle Chasse, LABuilt 2006 · S/N 1920N290SGinter Aviation LLC · Oakland, MDBuilt 1971 · S/N E-292N290SRAvodah Management LLC · Kalispell, MTBuilt 2006 · S/N 2276N290WABlue Yonder LLC · Paris, TNBuilt 2017 · S/N 4494N29113Figueroa Angel Lara · Winfield, ALBuilt 1973 · S/N 21059806N2912TKrahling Jeffrey B · Redding, CABuilt 1966 · S/N 318N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815N2914YBol Aero LLC · Beverly Hills, CABuilt 2004 · S/N 0859N2915BRobble Group LLC · Center Valley, PABuilt 1986 · S/N E-2314N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153N291RBAbbott Air Inc · Hydro, OKBuilt 1982 · S/N 414A0836N2920GStevenson Taylor A · Dallas, TXBuilt 1980 · S/N 340A0115N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165N292BBFrench Cap Consulting LLC · West Palm Beach, FLBuilt 2025 · S/N 10521N292CDContrails Aviation LLC · Minneapolis, MNBuilt 2004 · S/N 1130N292DRDouble R Aviation LLC · Dallas, TXBuilt 2024 · S/N 10027N292GSSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2018 · S/N 1707N292KWHunnewell Willard · Edina, MNBuilt 2024 · S/N 10187N292MWGroth Greg · Cookeville, TNBuilt 1994 · S/N E-2862N292RSValiair Limited Company Trustee · Casper, WYBuilt 1980 · S/N 414A0482N292SRFogle & Sons Electric LLC · Columbia, SCBuilt 2007 · S/N 2852N292WSRegistered aircraftBuilt 2018 · S/N 1763N293LMDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 2015 · S/N 4227N293SMKemp Aviation LLC · Hiram, GABuilt 1982 · S/N EA-329
Back to AD 2012-10-13