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.

N972SBTmacc Aviation LLC · Mooresville, INBuilt 2016 · S/N 1293N972SDSooner Sky Aviation LLC · Edmond, OKBuilt 2026 · S/N 11468N972TBLotane Troy Randall · Marathon, FLS/N 3778N973CDByrd Jack P · Cleveland, TNBuilt 2006 · S/N 1806N973KP898 Air LLC · Indianapolis, INBuilt 2007 · S/N 2697N973PCTennessee Beach Boyz LLC · Soddy Daisy, TNBuilt 1992 · S/N E-2698N973SThompson Peter L · Portales, NMBuilt 2001 · S/N EA-688N973SDCloud9 Aviation LLC · Wilmette, ILS/N 3755N973SNWiggins Hydroplanes LLC · Rainbow City, ALBuilt 2015 · S/N 0973N97435Wipaire Inc · South Saint Paul, MNBuilt 1979 · S/N 18267091N9746YAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1981 · S/N 21064585N9748ZKerr Kenneth E · Bakersfield, CAS/N 21060943N974DJNylund Enterprises LLC · Castle Rock, COBuilt 2017 · S/N 1623N974KSOscar Castrejon Md LLC · Las Cruces, NMBuilt 2015 · S/N 0974N974RCRafael Cisneros LLC · Wilmington, DEBuilt 1981 · S/N 21064459N974SRFishes And Loaves LLC · Helena, MTBuilt 2007 · S/N 2729N974WFVictory Aviation LLC · Winchester, VABuilt 2006 · S/N 42527N975CWMarvphanie Equipment LLC · Byron, GABuilt 2002 · S/N 0424N975MCChristopher Michael W · Nicholasville, KYBuilt 2007 · S/N 42560N975MSSherrett Ryan John · Lake Havasu City, AZBuilt 2008 · S/N 3001N975NEEliseian Lee Trustee · Reno, NVBuilt 2015 · S/N 0975N975PWBecker Equipment LLC · Omaha, NEBuilt 2002 · S/N 0425N975RAGo-Fly Productions LLC · Avondale, PABuilt 2001 · S/N L2K-123N975TCConstruct Air LLC · Osage Beach, MOBuilt 2026 · S/N 11449N976ATCloud Server II LLC · Montgomery, ALBuilt 2015 · S/N 0976N976CJValiair Limited Co Trustee · Casper, WYBuilt 2021 · S/N 2482N976JBClydesdale Aviation Holdings LLC · Thousand Oaks, CABuilt 2017 · S/N 1495N976JWWe...Goose LLC · Mukilteo, WABuilt 2004 · S/N 1018N976TMCoast To Coast Holdings LLC · Kalispell, MTBuilt 2023 · S/N 9575N9770CAnderson James M III · Atlanta, GABuilt 2022 · S/N ES-011N9770MStr Holdings LLC · Lafayette, INBuilt 1978 · S/N U20604564N977CMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 3037N977CPAirborne Properties LLC · Wilmington, DEBuilt 2024 · S/N 10203N977ERAquila Management Solutions LLC · Miami, FLBuilt 2012 · S/N 3873N977SRMedrosillo Pllc · Spring, TXBuilt 2007 · S/N 2779N978CBMgb Aviation LLC · Morristown, TNBuilt 2026 · S/N 11168N978GKFox Whiskey Inc · Wilmington, DEBuilt 1996 · S/N E-3047N978NSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2021 · S/N 2340N978SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2809N979SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N TH-1932N97AHKw Air LLC · Fallbrook, CABuilt 1980 · S/N EA-107N97BKA&D Machinery LLC · Hartsville, SCBuilt 1996 · S/N E-3064N97CKBlue Hornet Air LLC · Miami, FLBuilt 2009 · S/N 3419N97CTBarj Associates Co · Naples, FLBuilt 2001 · S/N 0128N97DFFlying G Aviation LLC · Elizabeth, COBuilt 1978 · S/N 340A0510N97DWWestphal Dana L · Broussard, LABuilt 2008 · S/N L2K-165N97EKern County Sheriffs Department · Bakersfield, CABuilt 1983 · S/N 21064788N97GVCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11633N97GWLeft Coast Transport LLC · Largo, FLBuilt 1977 · S/N E-1143N97HCAlpha Whiskey 1 LLC · Brandon, MSBuilt 1976 · S/N 310R0651
Back to AD 2012-10-13