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.

N3232WKilgallen Keith S · Stuart, FLBuilt 1995 · S/N E-2932N3233GMach Aviation Pilot Services LLC · Andover, KSBuilt 1995 · S/N E-2933N3233JZebcon Inc · Russellville, ARBuilt 1999 · S/N E3233N3233LMann Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA633N3235DMdb Ventures LLC · Wausau, WIBuilt 1995 · S/N E-2935N3235TBhatia Kabir · Lake Oswego, ORBuilt 1995 · S/N EA-577N3236QBo'S Investments LLC · Amarillo, TXBuilt 1997 · S/N E3110N3236THg Aviation LLC · Helena, MTBuilt 1995 · S/N E-2936N3236ZJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1991 · S/N EA-526N3238YKorff Aviation LLC · Leesburg, VABuilt 1995 · S/N E-2938N3239WHaidlen Ford Inc · Oakdale, CABuilt 1995 · S/N E-2939N323BMMav-Cat Aero LLC · Bremerton, WABuilt 2010 · S/N 0069N323CDMesibov Steven · Deland, FLBuilt 2004 · S/N 1020N323CLHoge John · Setauket, NYBuilt 2002 · S/N 40054N323DASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064753N323DCFlymax Aircraft LLC · Ball Ground, GAS/N P21000384N323DMWard Frank J · N Richland Hills, TXBuilt 1998 · S/N 29-0155N323FLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1985 · S/N 468508096N323KCBig Blessing LLC · Saint Louis, MOBuilt 2015 · S/N 4273N323KGN1234 LLC · Costa Mesa, CABuilt 2020 · S/N 4879N323LMSandcastle Jwm Properties LLC · Paradise Valley, AZBuilt 1992 · S/N TH-1667N323MFFla Capital LLC · Newark, DEBuilt 2023 · S/N 9426N323PMSrc Property LLC · Alpine, TXS/N EA-161N323RBAvion Flight Services LLC · Rome, GABuilt 2012 · S/N 3906N323RCTigers Aviation LLC · Wasilla, AKBuilt 1980 · S/N EA-87N323TJGuardian Wings LLC · Fredericksburg, VABuilt 1983 · S/N T30300243N323TLPrime Aviation Leasing LLC · Westlake, TXBuilt 2014 · S/N 4035N323WWhitewings Aviation LLC · Milton, GABuilt 2005 · S/N 1509N323WDDurand Paul C · Osceola, WIBuilt 2006 · S/N 2085N323YManthei Kurt E · Jacksonville, FLBuilt 2006 · S/N 42539N3240NAir Services Of Mississippi Inc · Mccomb, MSBuilt 1995 · S/N E-2980N3243BKcirro LLC · Portland, ORBuilt 1999 · S/N E-3243N3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CABuilt 1995 · S/N EA-575N3246BRb3246b LLC · La Follette, TNBuilt 1995 · S/N TH-1746N3246RRegistered aircraftBuilt 1995 · S/N E-2946N3247PCary Leasing & Management LLC · Boerne, TXBuilt 1999 · S/N EA-647N3247XExcalibur Aviation LLC · Spencer, IABuilt 2000 · S/N E-3347N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748N3248TBrydon Robert J · Austin, TXBuilt 1995 · S/N E-2948N3249DBielanski Allan · Larkspur, COBuilt 1995 · S/N E-2949N3249JSelge Leasing Inc · Niles, MIS/N E-3349N324ABLightning Aviation LLC · Parrish, FLBuilt 2015 · S/N 0999N324AJ324 Aj LLC · Roseville, CABuilt 2024 · S/N 9963N324BRBlue Ridge Aviation Holdings LLC · Boone, NCBuilt 2015 · S/N 4194N324CDWalker Synergy Partners 367 Inc · Encinitas, CABuilt 2026 · S/N 11419N324GEGreat Aviation LLC · Michigan City, INBuilt 2025 · S/N 10956N324GT324 Aviation LLC · Cavour, SDBuilt 1979 · S/N EA-38N324QLove Charles Keith · Asheville, NCBuilt 1999 · S/N TH-1909N324RDGood Voyage LLC · Sullivans Island, SCBuilt 2021 · S/N 5134N324SRThree Bell Aviation LLC · Dallas, TXBuilt 2007 · S/N 2458
Back to AD 2012-10-13