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.

N645CPRjgvb LLC · Shippensburg, PAS/N 3371N645KCCielos Capital LLC · Charlotte, NCBuilt 2024 · S/N 10154N645RSSlack Richard · Highland, UTBuilt 2024 · S/N 9856N645SRArcangel Aviation II LLC · Kansas City, MOBuilt 2007 · S/N 2645N645WCWest Louis G · Amity, ORBuilt 1975 · S/N 414-0645N646Texoma Industries Of Graham LLC · Graham, TXBuilt 2023 · S/N 9287N6460HWhitetail LLC · Anchorage, AKBuilt 1979 · S/N 20700530N6461ZJav Air Services LLC · Anchorage, AKBuilt 1981 · S/N U20606282N6464APerry Scott · Flower Mound, TXBuilt 1982 · S/N EA-330N6465GD Luckie LLC · Kalispell, MTBuilt 1982 · S/N EA-305N6466NHagan Joseph · Steward, ILBuilt 1978 · S/N 21063040N6467NDa Vinci Aero LLC · Lake Ozark, MOBuilt 1982 · S/N EA-310N6468Charlie Sierra Aviation LLC · Norwalk, IABuilt 2002 · S/N 0419N6469NKestrel Aviation LLC · La Center, WABuilt 1978 · S/N 21063043N646ABInternet Strategies LLC · Glenview, ILBuilt 2023 · S/N 9369N646ACZimmers Herbert J · Fox Point, WIBuilt 1994 · S/N 29-0006N646AFFlight1 Technical Training Services LLC · Myrtle Beach, SCBuilt 2026 · S/N 11355N646CDRegistered aircraftBuilt 1979 · S/N 21063402N646RBCantabria Air Inc · Rollingwood, TXBuilt 2026 · S/N 11398N6470YSkyhigh Enterprises LLC · Holland, MIBuilt 1981 · S/N 21064396N6476WWill Investments Inc · Englewood, COBuilt 1981 · S/N P21000784N6476ZVorlop Robert W · Delray Beach, FLBuilt 1982 · S/N EA-311N6479NSouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 21063053N6479YGv Air Inc · Medford, ORBuilt 1981 · S/N 21064399N647AGTlu Air LLC · Las Vegas, NVBuilt 2023 · S/N 9647N647CDGomez Enrique Jose · Pinecrest, FLBuilt 2005 · S/N 1724N647SBHyde Matthew L · Santa Cruz, CABuilt 1982 · S/N 21064743N6482YSky West Aviation Inc Trustee · Albuquerque, NMS/N 21064400N6484L6484l LLC · Denver, COBuilt 1982 · S/N EA-313N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785N648ACHey Clinic Pa · Raleigh, NCBuilt 2010 · S/N 3648N648CDurant Cecil John · Arlington, TXBuilt 2003 · S/N 0441N648CB648cb LLC · Columbus, OHS/N 0648N648DEShelby Kolby R · Comanche, OKBuilt 2022 · S/N 8559N648DMExpolity Aviation Holdings LLC · Sheridan, WYBuilt 2023 · S/N 9106N648RJUnderground Racing LLC · Helena, MTBuilt 2023 · S/N 9648N648VWYankee Flyers LLC · Mount Gilead, OHBuilt 2004 · S/N 200005-MN6491BTerrill Guy J · Dillon, MTBuilt 1978 · S/N 21062774N6491HBlue Air 3 LLC · Miami, FLBuilt 1979 · S/N 20700543N6492BPatno Delviny A · Daniel, WYBuilt 1978 · S/N 21062775N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067N6496NFisher Ranch Corporation · Blythe, CABuilt 1982 · S/N EA-314N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313N6499NHelgren Quentin C · Oakland, CABuilt 1978 · S/N 21063073N649CDSouthcap Brokerage Altanta Inc · Inlet Beach, FLBuilt 2005 · S/N 1709N649CHDemer Joseph L Trustee · Los Angeles, CABuilt 2023 · S/N 9649N649FABrown Charles R II · Dallas, TXBuilt 2016 · S/N 1433N649LCSmith Aviation LLC · Sitka, AKBuilt 1980 · S/N TJ-304
Back to AD 2012-10-13