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.

N731NXCarey Richard · Dallas, TXBuilt 1980 · S/N P21000515N731NZWoodgrain Millwork Transportation LLC · Fruitland, IDBuilt 1980 · S/N P21000517N731PCapital Dental Management · Medford, ORBuilt 2001 · S/N TH-1997N731PDInvisible Angels · Washington, DCBuilt 1980 · S/N P21000519N731PJBreckenridge Interests Ltd · Corpus Christi, TXBuilt 1980 · S/N P21000523N731PPPoli Poli Inc · Sausalito, CABuilt 2012 · S/N 3829N731QGMowbray Jerry H · Reno, NVBuilt 1980 · S/N P21000525N731QHK17 Corp · Alamosa, COBuilt 1980 · S/N P21000526N731QNOkeeffe William Trustee · San Francisco, CABuilt 1980 · S/N P21000529N731QRAir Rosa LLC · Tupelo, MSBuilt 1980 · S/N P21000531N731RRAviation Inventions LLC · Windsor, COBuilt 1980 · S/N P21000538N731RWAdvanced Products Sales LLC · Tempe, AZBuilt 1980 · S/N P21000540N731SCMoore Scott A · Longview, TXBuilt 1980 · S/N P21000543N731STTimmbertrek LLC · Cedar Rapids, IABuilt 2025 · S/N 10899N731TPHangar 28 LLC · Littleton, COBuilt 1980 · S/N P21000546N731TWRegistered aircraftBuilt 2025 · S/N 10957N731VCCuster Joseph A Jr · League City, TXBuilt 2023 · S/N 9529N731WCCross Wayne Trustee · Novato, CABuilt 2001 · S/N E-3404N731WF29 Aviation LLC · Granite Falls, MNBuilt 2016 · S/N 4421N731XXGrimm John H II · Driftwood, TXBuilt 1980 · S/N P21000559N731ZBVanderwaal Shane J · Junction City, WIBuilt 1980 · S/N P21000565N731ZFTuggle James L Jr · Scottsdale, AZBuilt 1980 · S/N P21000566N732ABJohn L Dolan Consulting LLC · Vienna, VABuilt 2018 · S/N 4615N732ADDavis Billy E · Castlewood, SDBuilt 1976 · S/N 21061355N732AQGold Star Air · Portland, MEBuilt 1976 · S/N 21061366N732BASparks Steve · Hamilton, OHBuilt 1976 · S/N 21061376N732BKJones Mark A · Johnson City, TXBuilt 1976 · S/N 21061385N732CBAire Flight Systems Inc · Midwest City, OKBuilt 1976 · S/N 21061400N732CDK9 Aviation LLC · Tyler, TXBuilt 2005 · S/N 1685N732CRGlobal Energy Werks LLC · Ely, MNBuilt 1976 · S/N 21061414N732CXEvans Terry W · Corning, IABuilt 1976 · S/N 21061420N732DKMckay Donald E · White City, ORBuilt 1976 · S/N 21061432N732DMFlying Knights LLC · Farmington, NMS/N 21061434N732DQAcme Do It Yourself Tornado Kits LLC · Draper, UTBuilt 1976 · S/N 21061437N732ECPompa Oliver · Tucson, AZBuilt 1976 · S/N 21061448N732ETCaudill Jimmy L · Grove, OKBuilt 1980 · S/N P21000575N732EWFiller Leslie Trustee · Emerald Hills, CABuilt 1976 · S/N 21061466N732FPLancair Of Texas DBA · Snyder, TXBuilt 1976 · S/N T21061482N732GK3jc LLC · Phoenix, AZBuilt 1976 · S/N 21061500N732HDMgp Investments LLC · Woods Cross, UTBuilt 1976 · S/N 21061518N732HRBowdle Ricke H · San Dimas, CABuilt 1978 · S/N U20604680N732JFSpeed Of Light Aerospace LLC · Lompoc, CABuilt 1976 · S/N 21061543N732JJCj Air LLC · Escondido, CABuilt 1976 · S/N 21061546N732JMGarcia Victor C · Cameron Park, CABuilt 1978 · S/N U20604685N732JS732js Partners Ltd · Batavia, ILBuilt 1976 · S/N 21061554N732JWSunniland Ranch Airport LLC · Okeechobee, FLS/N 21061558N732KBTadco Equipment Inc · Laveen, AZBuilt 1976 · S/N 21061563N732KCKing Daddy Aviation LLC · Madison, MSBuilt 1976 · S/N 21061564N732KPB&M Aviation LLC · Montgomery, TXBuilt 1976 · S/N 21061575N732KQPerea Rudolph A · Dayton, NVBuilt 1976 · S/N 21061576
Back to AD 2012-10-13