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.

N826JKMmv Holding LLC · Indianapolis, INBuilt 2021 · S/N 5077N826KENorthern Renegade Properties LLC · Duluth, MNBuilt 2011 · S/N 0170N826MGOrten Symer Enterprises Inc · East Hampton, NYBuilt 1993 · S/N E2782N826MMCavu Flying LLC · Kohler, WIBuilt 2007 · S/N 2359N826MTG T Acft Inc · Franklin Square, NYBuilt 1979 · S/N TK-109N826TWHartland Aviation LLC · New Smyrna Beach, FLBuilt 2022 · S/N 9032N8272BAndy-Oxy Co Inc · Asheville, NCBuilt 1990 · S/N TH-1601N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135N8275ASigillito Michael A · Vero Beach, FLBuilt 1993 · S/N E-2803N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136N8277DValiair Lc Trustee · Casper, WYS/N E-2798N8277FFletcher Holdings Of Nc 2.0 LLC · Winston Salem, NCBuilt 2026 · S/N 11259N8277MBlalock Paul T · Longview, TXBuilt 1970 · S/N 21059277N8278TRegistered aircraftBuilt 1992 · S/N TH-1672N827APelican Flyers LLC · Metairie, LABuilt 2002 · S/N 40050N827CDSwiss Wings Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0169N827CTN44uk Partners LLC · Burlington, WABuilt 2015 · S/N 1115N827DJStorm Horse Systems LLC · Bedford, NYBuilt 2024 · S/N 10292N827EAElite Air LLC · Wilmington, DEBuilt 2024 · S/N 9949N827HELocke Ventures LLC · Southaven, MSBuilt 2023 · S/N 9052N827LLHotel Mike LLC · Dayton, OHBuilt 2020 · S/N 2143N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541N827SStamp Jeffrey · Little Rock, ARBuilt 2002 · S/N 0362N827TCDecker Tobin James · Avon, INS/N 1304N827URJoby Aero Inc · Santa Cruz, CABuilt 2016 · S/N 4403N827WFCarlton Paul K Jr · College Station, TXBuilt 2003 · S/N 0667N8285CBonanza Enterprise LLC · Tucson, AZBuilt 1993 · S/N E-2810N8285MCohen Aviation LLC · Rolla, MOBuilt 1993 · S/N E-2815N828ABChasen Dreams LLC · Hurricane, WVBuilt 2005 · S/N 1419N828BPHot Wings Aviation Ltd · Wilmington, DEBuilt 2005 · S/N 29-0399N828CCoriolis Inc · Brooklyn, NYBuilt 2002 · S/N 0396N828DTTspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1648N828ECPrescient Aviation LLC · Los Angeles, CAS/N 1200N828EXHorizon Strategies Aviation LLC · Dover, DEBuilt 2013 · S/N 3927N828GFrancis Rick Trustee · Pleasanton, CABuilt 2026 · S/N 11216N828GGOrtho Hand Aviation LLC · Lewes, DEBuilt 2015 · S/N 4294N828JHDonnelly Mark A · San Jose, CABuilt 2025 · S/N 10714N828KGGray Enterprises Investing LLC · Wentzville, MOBuilt 2026 · S/N 11253N828KMSjr Holdings LLC · Raleigh, NCBuilt 2001 · S/N TH-1999N828KPKapa International · Santa Monica, CABuilt 2005 · S/N 1456N828LPentacrown Svr Clr LLC · Little Rock, ARBuilt 2019 · S/N 2044N828LEKnights Templar Aviation LLC DBA · Rossville, TNBuilt 2008 · S/N 3178N828LLOlsen Leasing LLC · Hendricks, MNBuilt 2021 · S/N 2368N828LMSletten Mark W · Saint Jacob, ILBuilt 2019 · S/N LS-206N828MBBel Aviation LLC · West Bloomfield, MIBuilt 2022 · S/N 8655N828MEHungerford Properties LLC · Cockeysville, MDBuilt 2006 · S/N 1943N828MRLooking Beyond LLC · Burlington, VTBuilt 2012 · S/N 3885N828MWCoop Michael P Sr · Sylva, NCBuilt 2025 · S/N 10813N828PMRobinson Shannon D · Fair Oaks Ranch, TXBuilt 1987 · S/N 4608057N828PSCampbell Terry G Trustee · San Francisco, CABuilt 2024 · S/N 10020
Back to AD 2012-10-13