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.

N97JKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0052N97JYLancair 1074 Inc · Lewes, DEBuilt 1997 · S/N 1074N97LTWallace James R Jr · Oneonta, ALBuilt 2003 · S/N 0768N97LXWhy Knot Fly LLC · Naples, FLBuilt 2013 · S/N 0544N97MKEquity Estates LLC · Lexington, KYBuilt 2024 · S/N 10029N97PPMlk Holdings LLC · Newark, DEBuilt 2019 · S/N 1855N97PWKelley Larry A Jr · Port Arthur, TXBuilt 1994 · S/N 29-0013N97RJN97rj Airplane LLC · Leesburg, VABuilt 2004 · S/N 1151N97STRegistration Pending · Hubertus, WIRegistration pendingBuilt 1996 · S/N 29-0101N97VCSababa Aviation LLC · West Palm Beach, FLBuilt 1985 · S/N TJ-495N97VKMore Less 7vk LLC · Lewes, DEBuilt 1997 · S/N LIV-247N97VTDelta Mike LLC · Blacksburg, VAFirst renewal noticeBuilt 2020 · S/N 4884N980AMC&P Aircraft Holdings LLC · Nacogdoches, TXS/N 340-0518N980MLBluegreene Skies LLC · Brentwood, TNBuilt 2024 · S/N 10041N980RJCirrus 0980 Aviation Inc Trustee · Wilmington, DEBuilt 2015 · S/N 0980N980SCSky Horse LLC · Santa Cruz, CABuilt 1982 · S/N 21064774N981AKState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606248N981ARCloud Nine Adventures LLC · Jupiter, FLBuilt 2015 · S/N 1159N981BKBmk-Sy LLC · Clarkston, MIBuilt 2022 · S/N 8962N981CDThumb Aero LLC · Sandusky, MIBuilt 2006 · S/N 1896N981DMMartin David E · Dallas, TXBuilt 1975 · S/N 340A0028N981JN 981 J LLC · San Antonio, TXBuilt 2022 · S/N 8784N981JWWill Tucker Aviation LLC · Wilmington, DEBuilt 2018 · S/N 1731N981KCumberland Aviation LLC · Corbin, KYBuilt 2020 · S/N 2129N981PSunderman Randy D · Norfolk, NEBuilt 2015 · S/N 4293N981PGJam Cellars Investments LLC · Napa, CABuilt 2021 · S/N 2393N981WBFlying Fortress Of Swfl LLC · Fort Myers, FLS/N U20606221N982CDLeon Arnaldo · Las Vegas, NVBuilt 2006 · S/N 1853N982JMMiller Aviation LLC · Fort Mill, SCBuilt 1999 · S/N 30-0016N982PWValley Wide Cooperative Inc · Nampa, IDBuilt 2010 · S/N 3641N9836PTurbo Property LLC · Clovis, CABuilt 1998 · S/N E-3169N9836SForest Kevin · Langdon, NDBuilt 1998 · S/N E-3210N983CDN983cd LLC · Chattanooga, TNBuilt 2006 · S/N 1899N983DBBunke Jim Bradley · Denver, COBuilt 2000 · S/N EA-657N983JBConstellation Aviation LLC · Rock Springs, WYBuilt 1978 · S/N 340A0453N983WPHallows Hc Holdings LLC · Salina, UTBuilt 2005 · S/N 1671N9843YCavu Solutions LLC · Renton, WABuilt 1981 · S/N 21064616N9848MCovington Aircraft Engines Inc · Okmulgee, OKBuilt 1978 · S/N U20604575N984JPPerry Christopher J · Chicago, ILBuilt 2024 · S/N 10315N984KCT4 Equipment LLC · Boone, NCBuilt 2015 · S/N 4226N984VBHorton Aviation LLC · Greensboro, NCBuilt 2026 · S/N 11453N984WMFly Mah LLC · Durham, NCBuilt 2025 · S/N 10587N98533Bla Holdings LLC · Mcminnville, TNBuilt 1976 · S/N 340A0022N9853COregonian Flying Club · Wilmington, DEBuilt 1983 · S/N T30300220N98554Hawke Air Corp · Helena, MTBuilt 1976 · S/N 340A0030N98579Bailey Switch Rentals LLC · Bluefield, VABuilt 1976 · S/N 340A0041N98590Tuc-Mex LLC · Nogales, AZBuilt 1976 · S/N 340A0049N985BWCr Aviation LLC · Budd Lake, NJBuilt 2021 · S/N 2406N985EKQualitair LLC Trustee · MichelsladtBuilt 2015 · S/N 4262N98613Aero Innovations LLC · Tempe, AZBuilt 1976 · S/N 340A0057
Back to AD 2012-10-13