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.

N727PWSteven Bennett Trustee · Boise, IDBuilt 2004 · S/N 1196N727SPinnacle Aviation Services LLC · Key Largo, FLS/N 1316N727SHCjt Cirrus LLC · Boston, MABuilt 2014 · S/N 0758N727SLRegistered aircraftBuilt 2006 · S/N 1773N727SRMid-Way Regional 2023 LLC · Columbia Falls, MTBuilt 2007 · S/N 2613N727VGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2446N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140N728United States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606877N728BJBarefoot Boats LLC · Greensboro, GABuilt 2016 · S/N 4320N728CTBerns Ridge Service LLC · Whittier, CABuilt 1982 · S/N 340A1533N728DSTebeaux William Jene · College Station, TXBuilt 1986 · S/N 4608047N728SMMasters In Flight LLC · Friday Harbor, WABuilt 2005 · S/N 41087N728SRSouthside Tire Co Inc · Antigo, WIBuilt 2007 · S/N 2546N728STV-Star Holdings LLC · West Lafayette, INBuilt 2012 · S/N 0378N728TFLopez Noel · Mcallen, TXBuilt 2011 · S/N 0190N729AJEdwards 729aj LLC · Dublin, OHBuilt 2015 · S/N 4208N729BFox Air LLC · Canton, OHBuilt 2024 · S/N 10393N729CDOmega Skyways LLC · North Bethesda, MDBuilt 2001 · S/N 0025N729CWWright Matthew J · Bowling Green, OHBuilt 1987 · S/N E-2390N729JRJbj Air Services LLC · Virginia Beach, VABuilt 2007 · S/N 2344N729JWJ Dubb Air LLC · Cordele, GABuilt 2025 · S/N 10618N729KXShrago Daniel A · Springfield, VABuilt 2013 · S/N 0527N729LJArcher Matthew · Houston, TXBuilt 2025 · S/N 10535N729MHAc Aircraft Holdings LLC · Dallas, TXBuilt 2026 · S/N 11455N729MRFlanagan Brian F · Roseville, CAS/N 29-0017N729SASierra Alpha Leasing LLC · Naples, FLFirst renewal noticeBuilt 2020 · S/N 4890N729TGKimbrell Todd Jr · Itasca, TXS/N 1347N729TXAcross America Aviation LLC · Moreno Valley, CABuilt 2017 · S/N 1508N729UMCuthbertson Air LLC · Apison, TNBuilt 2024 · S/N 10035N729WMRiller David P · Bothell, WABuilt 2023 · S/N 9220N72ADMcguire Transportation LLC · Murfreesboro, TNBuilt 2012 · S/N 0429N72BKUpper Airways LLC · Kalispell, MTBuilt 2002 · S/N 0172N72CGGarvin Carroll E · Scottsdale, AZBuilt 1980 · S/N TJ-264N72CUKuhlke K Lee · Englewood, COBuilt 2001 · S/N EA-673N72DFCirrus Design Corp · Knoxville, TNBuilt 2013 · S/N 0526N72DTMalibu Aviation Inc · Wichita, KSBuilt 1985 · S/N 46-8508084N72DVStirling Motors LLC · Kalispell, MTBuilt 2006 · S/N 2144N72EGM Group Aviation LLC · Medford, ORBuilt 2018 · S/N 1706N72ETCirrwest Ltd · Grand Junction, COBuilt 2007 · S/N 2522N72GGHall Joel · Nashville, TNBuilt 2007 · S/N 2328N72JAOtter Air LLC · Fishers, INBuilt 1979 · S/N 414A0333N72JESkyward LLC · Fort Smith, ARBuilt 2005 · S/N 1654N72JVMatrix Commerce Solutions LLC · Point Pleasant Bch, NJBuilt 2000 · S/N 05N72KDN72kd LLC · Wilson, WYBuilt 2022 · S/N 8896N72KGM & P Aviation LLC · Byhalia, MSBuilt 1980 · S/N 414A0513N72KMIntrepid LLC · Helena, MTBuilt 2023 · S/N 9340N72LEBarbee Mark E · Cody, WYBuilt 2015 · S/N L2K-175N72LLKusy LLC · New Rochelle, NYBuilt 2018 · S/N 4633N72LRSchnell Michael L · Spearman, TXBuilt 2001 · S/N EA-676N72MJValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10652
Back to AD 2012-10-13