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.

N310JGMarc Inc · Bolton, MSBuilt 1979 · S/N 310R1567N310JNAustin Baumgarten Inc · Tomah, WIFirst renewal noticeBuilt 1977 · S/N 310R0979N310JPBrock Kyle · Riverdale, CABuilt 1972 · S/N 310Q0648N310JWWharton Melissa P · Wise, VABuilt 1977 · S/N 310R0956N310KMStitt Consulting Inc · Titusville, FLBuilt 1979 · S/N 310R1675N310LDAbq 421 LLC · Albuquerque, NMBuilt 1977 · S/N 310R0922N310LPIsaacs W Bradford · Las Vegas, NVBuilt 1979 · S/N 310R1656N310LWMy Way Aviation LLC · Weston, FLS/N 310Q-0250N310MAustin Security Inc · Battleboro, NCS/N 310R0554N310MGGoroff Marc · Livermore, CABuilt 1976 · S/N 310R0724N310MWKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0823N310PPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2414N310PSRoe Fabricators Inc · Chester, PABuilt 1975 · S/N 310R-0559N310PZCardozo Armando J · Miami Gardens, FLBuilt 1976 · S/N 310R0726N310RGRome Aviation LLC · Lakeland, TNBuilt 1977 · S/N 310R0856N310RRWateractive43 LLC · Auburn, CABuilt 1974 · S/N 310R0014N310SATailwind LLC · Cameron, NCBuilt 2019 · S/N 4812N310SKAstroworld Travel LLC · Port Orange, FLS/N 310R1829N310SMRegistration Pending · Pocatello, IDRegistration pendingS/N 2046N310TNFarfalla Aviation LLC · Santa Rosa, CABuilt 2006 · S/N 2146N310TTTriple J Flying Inc · Wilmington, DEBuilt 1973 · S/N 310Q0810N310TWHowe Phillip T · Oro Valley, AZBuilt 1978 · S/N 310R1264N310VGGtc Services LLC · Ocala, FLBuilt 1977 · S/N 310R-0990N310VPN310vp LLC · Galena, OHBuilt 2001 · S/N 0054N310WDHernandez Jr Raymond Trustee · Burleson, TXBuilt 1969 · S/N 310Q0238N310WJAg N310wj LLC · South Salt Lake, UTBuilt 1976 · S/N 310R0721N310ZFlyin' Dog Air LLC · Niceville, FLBuilt 1979 · S/N 310R1573N3111DMonarch Air Services LLC · Ballwin, MOBuilt 1994 · S/N E-2874N31121Full Flaps 2 LLC · Peachtree City, GABuilt 1988 · S/N E-2428N3112KBeilman Charles C · Wallingford, CTBuilt 2021 · S/N 5123N3112YWykoff Donald W · West Chester, OHBuilt 1988 · S/N E-2410N31143Mjj Aircraft Inc · Wilmington, DEBuilt 1988 · S/N E-2443N3114W865 Aviation LLC · Knoxville, TNBuilt 2021 · S/N 5117N3114YN635v LLC · Nacogdoches, TXBuilt 1988 · S/N E-2441N3119TRiverwind Strategic Solutions LLC · Lewes, DEBuilt 1994 · S/N E-2878N311AVCane Associates Aviation Consultants LLC · Mount Pleasant, SCBuilt 2007 · S/N 2395N311CECirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11528N311CFHronkin Jessie G · Palmer, AKBuilt 1974 · S/N 18502496N311CHWings Of Eaglz LLC · Lamoni, IAS/N TK-149N311DBIts Plus Inc · Plano, TXBuilt 2013 · S/N 0474N311FSLunsford Group Inc · Weaverville, NCBuilt 2015 · S/N 1177N311GJ755 Aviation LLC · Lake Mary, FLBuilt 2023 · S/N 9498N311HN311h LLC · Vineyard, UTBuilt 2024 · S/N 10348N311JBJack Brain And Associates Inc · Castro Valley, CAS/N P21000539N311JLPoelking Theodore J · Dayton, OHBuilt 2017 · S/N 1616N311KMDream Flight Florida LLC · Wellington, FLBuilt 1979 · S/N 340A0757N311KNViking Aircraft Leasing LLC · Bethel, MNBuilt 2009 · S/N 3440N311LRegistered aircraftBuilt 2018 · S/N L2K-302N311MWS S Euroflyer III Ltd · Wilmington, DEBuilt 1987 · S/N CE-1155N311PDHaehnle Michael J · Milford, OHBuilt 1995 · S/N 29-0066
Back to AD 2012-10-13