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.

N649SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2017 · S/N 1592N64CHAnnsec Corp · Wilmington, DEFirst renewal noticeBuilt 2007 · S/N L2K-234N64CPC&A Capital Holdings LLC · Moore, OKBuilt 2018 · S/N 1695N64EGWhite Pine Two LLC · Park City, UTBuilt 2014 · S/N 0793N64GAEagles Soar LLC · Lewes, DEBuilt 2014 · S/N 0783N64JUSpace Goose LLC · Newark, DEBuilt 2024 · S/N 10241N64KTKlute Jordan · Omaha, NEBuilt 1976 · S/N 340A0045N64LLReagan Ronald J · Litchfield Park, AZBuilt 2005 · S/N L2K-240N64LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N TH-1749N64MROne Mike Romeo Leasing LLC · Las Vegas, NVBuilt 2003 · S/N 0724N64NWSanderson Bradley Troy · Nashville, TNBuilt 2023 · S/N 9643N64RHLandmark Aviation LLC · Hayden, IDBuilt 2025 · S/N 10716N64RPCoe Administrators LLC · Oshkosh, WIBuilt 1978 · S/N TJ-169N64RUCardinal Air LLC · Kentfield, CABuilt 2023 · S/N 9205N64SGCamp Illahee Inc · Brevard, NCBuilt 2006 · S/N 42549N64TGWilliamson Russell Haire Jr · Memphis, TNBuilt 2012 · S/N 3845N64VRVictor Romeo Aviation LLC · Hillsborough, CABuilt 2023 · S/N 9158N64WRAlesia Holdings LLC · Beaumont, TXBuilt 2001 · S/N TH-1981N6500BAndrews Aviation LLC · Spartanburg, SCBuilt 2002 · S/N 40043N6500GConsultant Services LLC · Stillwater, MNBuilt 2004 · S/N 42045N6500LApsis Aviation LLC · Kentfield, CABuilt 2001 · S/N 40027N6500VBlue Marble Aviation LLC · Center Valley, PABuilt 2003 · S/N 42033N6501MByrne William J · Davis, CABuilt 2001 · S/N 40023N6501UMoses Hunter K · Georgetown, TXBuilt 2004 · S/N 42040N6501ZJ&M Aviation Enterprises LLC · Greendale, WIBuilt 2003 · S/N 42007N65029Woodberry Robert A · Mineral, VABuilt 2004 · S/N 41024N6502ABelair Two LLC · Lancaster, PABuilt 2004 · S/N 42048N6502HSimpson Equipment Leasing LLC · Hays, KSBuilt 2004 · S/N 42037N6502XFalcon Way Partners LLC · East Helena, MTBuilt 2004 · S/N 42039N65031Miller Lewis W · Setauket, NYBuilt 2004 · S/N 42060N65035Vimco Aviation LLC · El Paso, TXBuilt 2004 · S/N 42052N6503CPotts Phillip G · Chattanooga, TNBuilt 2003 · S/N 42015N6503TRussell Construction Co · Douglas, WYBuilt 2002 · S/N 40039N65042Blueventure LLC · Morganton, NCBuilt 2004 · S/N 42042N6504DAirmart Aircraft Holdings Inc · Oak Ridge, NCS/N 42035N6504HPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 41010N6504KQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 40062N6504XMarc Pauls · Charlotte, NCBuilt 2004 · S/N 42056N6504ZAlbertson Robbie H · Easley, SCBuilt 2003 · S/N 42024N6505CLancair Leasing LLC · Greensboro, NCBuilt 2003 · S/N 40066N6505LTheriot Conchita F · Anderson, SCBuilt 2001 · S/N 40033N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075N6505VElg Air LLC · Birmingham, ALS/N 42053N6505ZJames Bryan C · Fredericksburg, TXBuilt 2004 · S/N 42044N6506VHarper Dreams LLC · New Smyrna Beach, FLBuilt 1976 · S/N 21061633N6506ZAf Auto Group · San Jose, CABuilt 1981 · S/N U20606301N6507VBrown Steven K · Tucson, AZBuilt 1982 · S/N EA-309N6507YJudge Allen · Lebanon, ILBuilt 2004 · S/N 41008N6508ALynch John Z · Elon, NCBuilt 2004 · S/N 42038N6508BTechnology Farm Inc · Tewksbury, MABuilt 2002 · S/N 40053
Back to AD 2012-10-13