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.

N876RCAscent Air LLC · Destin, FLBuilt 2023 · S/N 9334N8777XN8777x LLC · Dodge City, KSBuilt 2004 · S/N 1011N877ACBuffalo Mountain Aviation LLC · Abilene, TXBuilt 2016 · S/N 1329N877AGHadar Philip · Ridgefield, WABuilt 2012 · S/N 0372N877CInternational Air Services Inc Trustee · Carson City, NVBuilt 2003 · S/N 0445N877CAHausman Benjamin · Merritt Island, FLBuilt 1994 · S/N TH-1727N877CCEuroaviation Inc Trustee · KematenBuilt 2025 · S/N 10982N877CDCharlie Bravo LLC · Lubbock, TXBuilt 2002 · S/N 0327N877CPValiair Limited Co Trustee · Casper, WYBuilt 2010 · S/N 3535N877EMHobble Creek Aviation LLC · Provo, UTFirst renewal noticeBuilt 2015 · S/N 1217N877GWBilson David L Trustee · Van Nuys, CABuilt 2006 · S/N 1908N877HLLeavitt Randall Stephen Trustee · San Diego, CABuilt 1991 · S/N E-2643N877LELuca Aviation LLC · Powder Springs, GABuilt 2025 · S/N 10660N877MSLepalo LLC · Spokane, WABuilt 2013 · S/N 0629N877PRCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11588N877TSpecialty Paving Inc · Lincoln, CABuilt 2001 · S/N E-3381N8787YStanyan Holdings LLC · Portland, ORBuilt 2005 · S/N 1589N8789BBearcat Aviation LLC · Joplin, MOBuilt 1980 · S/N 414A0605N878BBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N TH-1710N878CAKag Aviation LLC · Mc Carley, MSBuilt 1994 · S/N TH-1728N878CFHusker Aviation LLC · Tallahassee, FLBuilt 2021 · S/N 2398N878DTHeidenreich Justin M · Olathe, KSBuilt 2014 · S/N 0947N878LCdld Air LLC · San Angelo, TXBuilt 2018 · S/N ES-P-221-17N878PAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1488N878PCCheck Six LLC · Henderson, NVBuilt 2008 · S/N 3249N878SKAirwinc LLC · Boyce, VABuilt 2023 · S/N 9348N878VMJames Vincent M · Reading, PABuilt 2003 · S/N 0551N878WMortgage And General Investment Corp · Big Bear Lake, CABuilt 2002 · S/N E-3459N8792KRegistration Pending · Waco, TXRegistration pendingBuilt 1980 · S/N 340A0985N879CDRidgeland Partners LLC · Wilmington, DEBuilt 2002 · S/N 0292N879JPRebel Aircraft LLC · Rapid City, SDBuilt 2002 · S/N TH-2030N879SRAlpha Foxtrot Aviation LLC · Ira, MIBuilt 2007 · S/N 2850N87ABDark Horizon Holdings LLC · Moraga, CABuilt 2026 · S/N 11485N87AQPavan Aviation LLC · Lawrenceville, GABuilt 2017 · S/N 1531N87ATAirbrush Inc · Allenwood, NJS/N LIV-251N87BLAtlas Aviation Tampa Inc · Tampa, FLBuilt 2010 · S/N 3695N87CDNew River Spearos LLC · Ambrose, GABuilt 2022 · S/N 8658N87CGPro Aire Cargo & Consulting Co Inc · Oshkosh, WIBuilt 1975 · S/N 402B0883N87EBSocinski Austin · Sevierville, TNBuilt 2022 · S/N 8664N87FBN87fb LLC · Rockville, MDBuilt 2023 · S/N 9587N87HHJmh Roofing Co Inc · Indianapolis, INBuilt 2023 · S/N 9639N87HKCirrusly Indefensible LLC · Lincoln, NEBuilt 2021 · S/N 5023N87JSLvyqt LLC · Menlo Park, CABuilt 1988 · S/N EA-476N87LPSoutheastern Transportation LLC · Pelham, ALBuilt 2002 · S/N 0279N87LSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 1830N87MLMeak Playground Surfacing LLC · Wind Lake, WIBuilt 2026 · S/N 11147N87MMKing Randall · Palestine, TXBuilt 1980 · S/N 210-63980N87RDDougs Glass Shop Inc · Bridgewater, CTS/N 46-08069N87RFCider Mill Aviation LLC · Cape Elizabeth, MEBuilt 2022 · S/N 8621N87RGCannon William C Jr · Concord, NCBuilt 1998 · S/N TH-1886
Back to AD 2012-10-13