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.

N59PJTad Holdings LLC · Little Falls, MNBuilt 1987 · S/N E-2395N59PXWaypoint Aviation Group LLC · Lenoir City, TNBuilt 2007 · S/N 2576N59SBLearson LLC · Tarpon Springs, FLBuilt 2002 · S/N 0196N59WVSanders Graham · State College, PABuilt 2013 · S/N 0516N59ZZN59zz LLC · Croton On Hudson, NYBuilt 2025 · S/N 10692N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441N5APOver The Airway LLC · Missoula, MTBuilt 2014 · S/N 0759N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315N5CCMoon Ape LLC · Las Vegas, NVBuilt 2018 · S/N 1701N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073N5DSCirrus Flying Professionals LLC · Hollywood, FLBuilt 2016 · S/N 4321N5DVJ4 Aviation LLC · Winter Haven, FLBuilt 2019 · S/N 2020N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137N5EVAndersen Tyler · Las Vegas, NVBuilt 2014 · S/N 0780N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295N5KBCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11376N5KMB & B Aviation LLC · Vineyard, UTBuilt 2003 · S/N 0458N5MKTysam Aero LLC · Graford, TXBuilt 2002 · S/N 0329N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042N5PAFinal Design Group LLC · Hurricane, UTBuilt 1981 · S/N EA-251N5PR3rd Season LLC · Carrollton, TXBuilt 2025 · S/N 10913N5PVBlack Hills Aviation LLC · Saint Cloud, MNBuilt 2010 · S/N 3469N5QETroutman Shawn L · Johnson, KSS/N 15N5SSterling David M · El Cajon, CABuilt 2006 · S/N 222N5SVPlane Metrics LLC · Fort Worth, TXBuilt 2000 · S/N LIV-375N5TTRoosa John · Tucson, AZBuilt 2014 · S/N 0693N5WFMociva Inc · Del Mar, CABuilt 1994 · S/N E-2892N5XNHuddart Martin · Farmington, CTBuilt 2006 · S/N 1975N5YVVasilik Kenneth E · St George, UTBuilt 2017 · S/N 1491N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002N60034Jpb Holdings Inc · Kalispell, MTBuilt 2003 · S/N 0596N6005CWings And Wedges LLC · Fort Lupton, COS/N 0597N6005LPeairs Gregory Ross · Sacramento, CABuilt 2003 · S/N 0563N6006NFraser Shane · San Marcos, TXBuilt 1978 · S/N 21062875N600BZCirrus Design Corp · Duluth, MNBuilt 2018 · S/N 4606N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025N600KG600kg LLC · Middletown, DEBuilt 2025 · S/N 10782N600KTAtaraxia Aircraft Holdings LLC · Greenville, SCS/N 3086N600LBSas Cirrus Vannes Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 1693N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250N600RVAero-Tech Services Inc · Lititz, PABuilt 1998 · S/N TH-1854N600SKMorin Aviation LLC · Accident, MDBuilt 2005 · S/N 1495N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668N600WLMoore Stan D · Amarillo, TXBuilt 1979 · S/N P21000409N6012BQualitair LLC · MichelstadtBuilt 2003 · S/N 0598N6012SWhaley Carl S · Shelby, NCS/N TJ-15N6013BFrost Sean D · Lovell, WYS/N 21062664N6013UGideon Aero LLC · Dayton, OHBuilt 2003 · S/N 0603
Back to AD 2012-10-13