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.

N6CACra Aviation LLC · Dickerson, MDBuilt 2021 · S/N 5073N6CDAviator One LLC · Holly Springs, NCBuilt 2001 · S/N 0037N6DMNorthstar Aviation Services LLC · Lake Havasu City, AZBuilt 2021 · S/N 2348N6ED3 Rivers Inc · St George, UTS/N TJ-9N6EYCsh Aviation LLC · Sheridan, WYBuilt 2004 · S/N 41005N6GFFrodel Greg W · Pasco, WABuilt 1991 · S/N E-2657N6HGBagwell Harold G · Garner, NCBuilt 1978 · S/N 21062624N6JSSures Jonathan Jason · Los Angeles, CABuilt 2025 · S/N 10975N6MKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 340-0322N6MPTilt Up Air LLC · Middleboro, MABuilt 2017 · S/N 4497N6NTNevada Defense Group LLC · Henderson, NVBuilt 1978 · S/N P21000109N6PPMechanics Ltd LLC · Wilmington, DEBuilt 2013 · S/N 5N6PVCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11517N6RWMagee Creek Wings & Things LLC · Rice, WABuilt 1973 · S/N 310Q0751N6SAMlg Enterprises Ltd LLC · Wilmington, DEBuilt 2022 · S/N 8651N6SQTate Thomas E · Glendale, CABuilt 1972 · S/N 310Q0625N6VWRegistered aircraftBuilt 1998 · S/N 29-0147N6WCDymaxion LLC · Cheyenne, WYBuilt 2024 · S/N 9760N6XZKahler Automation Corp · Fairmont, MNBuilt 1982 · S/N E-2047N6ZMStauf Air LLC · Germantown, TNBuilt 1990 · S/N E-2574N6ZQHarrelson William C · Port Saint Lucie, FLBuilt 2012 · S/N SB2N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553N7007VTurk James H · Mesa, AZBuilt 2001 · S/N 0082N700DKFlysix Oregon LLC · Salem, ORBuilt 1980 · S/N 340A1038N700FCSandlapper Aviation Of De Inc · Bennington, VTS/N 1986N700HBLucky7 Air LLC · Lenoir, NCBuilt 1982 · S/N 414A0810N700HGAerosphere LLC · Cedar City, UTBuilt 2005 · S/N 1506N700PGoree John A · Iowa City, IABuilt 2004 · S/N 0791N700RCUniversal Aviation LLC · Decatur, ARBuilt 1991 · S/N E-2606N700RSTransavia LLC · Wilmington, DEBuilt 1981 · S/N P21000716N700RTLipton Jack · Cottonwood, AZBuilt 1996 · S/N 29-0097N700STStella Raye LLC · Little Rock, ARBuilt 2022 · S/N 8629N700VRMountain & Vine LLC · Park City, UTBuilt 1979 · S/N TJ-194N701BTVgfs Aviation LLC · Naples, FLBuilt 2020 · S/N 4959N701CDQualitair LLC Trustee · MichelstadtBuilt 2001 · S/N 0006N701CJCenturion Aviation Ltd · Salina, KSBuilt 1968 · S/N 401A0022N701GMBell Air LLC · Valdosta, GABuilt 2021 · S/N 2401N701LWJeppson Family Investments LLC · St George, UTBuilt 2022 · S/N 8854N701MBBoot Keith Jason · Des Moines, IABuilt 2012 · S/N 3859N701MDDel Mar Aviation LLC · Algona, IABuilt 1980 · S/N 21064007N701PMJedi Flight Training LLC · Boerne, TXBuilt 2001 · S/N 0007N701PSLucky US LLC · Merrill, WIBuilt 1977 · S/N 21062339N701SGMach Aviation LLC · Ocklawaha, FLBuilt 2004 · S/N 0963N701SMKopcsay James · Corning, NYS/N ES-108-FBN7022GSamarth Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0695N70279Sh Th LLC · Miami Beach, FLS/N ES-159SFBN702DDJoyce Consulting LLC · Black Hawk, SDBuilt 1999 · S/N EA-644N702DSYaviation LLC · Burns, TNBuilt 2004 · S/N 0989N702ECBriggs Roofing Co · Rigby, IDBuilt 2016 · S/N 1301N702FCFlight Inc · Concord, NCBuilt 2001 · S/N 0018
Back to AD 2012-10-13