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.

N9612RBearnose II LLC · Edina, MNBuilt 1985 · S/N U20606901N9613GDavid W Easter Consulting Inc · Libby, MTBuilt 1972 · S/N U20601813N9614KPassmore Stephen B · Lacrosse, WABuilt 1983 · S/N T18803962TN961CDSouthpoint Development Inc · Jacksonville, FLBuilt 2006 · S/N 1824N961MCBig Rooster Aviation LLC · Coralville, IABuilt 2020 · S/N 2079N961TTLupia Raul H · Raleigh, NCBuilt 2004 · S/N 42054N9621J21 Juliet Aviation LLC · Carlsbad, CABuilt 2016 · S/N 1441N9624MWater Solutions Inc · Half Moon Bay, CABuilt 1995 · S/N 29-0037N962MBDouble A Aviation Group LLC · Harrison, NYBuilt 2019 · S/N 4866N962PWHamilton Jesse L · Aledo, TXBuilt 2004 · S/N 1125N962SRExploration Aviation LLC · San Antonio, TXBuilt 2007 · S/N 2669N962SYLatin Aviation LLC · Aventura, FLBuilt 2023 · S/N 9620N9632ZAngelone Inc · Elkhart, INS/N U20606585N96335Cysewski Roxanne Trustee · Rllng Hls Est, CABuilt 1983 · S/N EA-400N9635CAirmans Aviation Co Ltd · Fort Smith, ARBuilt 1983 · S/N T30300196N9636YCarranza Chris J · Stanfield, AZBuilt 1981 · S/N 21064566N963APJhmh Aeronautics LLC · Six Mile, SCBuilt 2014 · S/N 0729N963ARArtyair LLC · Cranberry Township, PABuilt 2025 · S/N 10756N963AWTesseract Aviation LLC · Colorado Springs, COBuilt 2013 · S/N 0482N963BBNc Aviation LLC · Missoula, MTBuilt 2020 · S/N 2093N963CDBraden Health LLC · Greensboro, NCBuilt 2005 · S/N 1470N963DBCommonwealth Aircraft Inc · Ashland, VABuilt 2005 · S/N 1575N963DMHaugen'S Hangar LLC · Williston, NDBuilt 2015 · S/N 4221N963RBAmerican Fine Art Inc · Scottsdale, AZBuilt 2008 · S/N 2928N963RTAppalachian Foothills Contracting Inc · Lexington, KYBuilt 2004 · S/N 1169N9643ZAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1982 · S/N U20606594N9649GAllen Todd N · Mccall, IDBuilt 1977 · S/N U20603819N964CDSolkshinitz Andrew · San Luis Obispo, CABuilt 2006 · S/N 1846N964HRAnderson Ridge Holdings LLC · Lewes, DEBuilt 2021 · S/N 5088N964SGWing Nuts Flying Club Ltd · North Chesterfield, VABuilt 2006 · S/N 42518N965GHHancock Aircraft Sales LLC · Baton Rouge, LAS/N 1666N965PWBeary Douglas Louis · Cary, NCBuilt 2017 · S/N 4546N965PZMc 81 LLC · Wellsville, UTBuilt 2019 · S/N 2042N965XML Merlo LLC · Rockville, MDBuilt 2019 · S/N 4848N966MGAirtrust LLC -6- Series 6 Trustee · Sheridan, WYBuilt 2008 · S/N 3155N966MPPerone Michael S · Fort Pierce, FLBuilt 2023 · S/N XRG-720N966TTClemmer Rodney Duane · Roanoke, VABuilt 2006 · S/N 2051N966UBTex Ark Air Corp · Melissa, TXBuilt 1977 · S/N TJ-120N9674GN1705r Inc · Cobb, CAS/N U20601874N9675RBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1989 · S/N E-2503N967CMoran Transport LLC · Westminster, MABuilt 2002 · S/N 0417N967KJHolland Willard T · Akron, OHBuilt 2012 · S/N 0396N967RBCrafter Aviation LLC · Park City, UTBuilt 2023 · S/N 9157N968BGValley Air LLC · Folsom, CABuilt 2004 · S/N 0968N968CCSun Auto Tire And Service Inc · Cape Girardeau, MOBuilt 2023 · S/N 9443N968CDSchultz James A · Folsom, CABuilt 2006 · S/N 1829N968PHArmstrong Aviation LLC · Nashville, TNBuilt 2005 · S/N 1372N968RAble Aviation LLC · Bolton, CTBuilt 2016 · S/N 1337N9691ZSouth America Mission Inc · Fort Mill, SCBuilt 1982 · S/N U20606611N9693ACavu LLC · Honolulu, HIBuilt 1991 · S/N TH-1627
Back to AD 2012-10-13