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.

N56JTNovak Jack · Dallas, TXBuilt 2024 · S/N 10101N56LLLegacy Leasing Group Inc · Wilmington, DEBuilt 2007 · S/N 2788N56LRSpeed And Angels LLC · Kalispell, MTBuilt 2019 · S/N 1-5N56MAMinuteman Aviation Inc · Missoula, MTBuilt 1976 · S/N 340A0067N56PEHart Everett T · Frederick, MDBuilt 2010 · S/N 3634N56PFLucero John · Long Key, FLBuilt 2002 · S/N 0274N56PNNorth Breakenridge Farm LLC · Burlington, WIBuilt 2016 · S/N 1444N56RMSchulte Aviation LLC · Donnellson, IABuilt 2023 · S/N 9628N56RRValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11490N56TJTrue North Aviation LLC · Leclaire, IABuilt 1981 · S/N 414A0804N56TLAviation Manpower Solutions Inc · Nashville, TNBuilt 1990 · S/N TH-1597N570CDDelta Zulu Air Ventures LLC · Charleston, SCBuilt 2005 · S/N 1340N570CPAces Hangar LLC · Bentonville, ARBuilt 2008 · S/N 3340N570RJEos Cirrus LLC · Las Vegas, NVBuilt 2016 · S/N 1446N570TBTbbs Aviation LLC · Kirkland, WABuilt 2025 · S/N 10770N570TPPaul Wallner LLC · Missoula, MTBuilt 2025 · S/N 10498N570WEStella Polaris LLC · Charlottesville, VABuilt 2025 · S/N 10757N571CDN&I Skies LLC · Leesburg, VABuilt 2005 · S/N 1659N571JCJc Aviation LLC · Smithville, TNBuilt 2019 · S/N 2005N571SKLong Ryan S · Auburn, CABuilt 2018 · S/N 1818N571TARegistered aircraftBuilt 2018 · S/N 1668N572CAValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 10301N572CDWaite Aviation LLC · Xenia, OHBuilt 2005 · S/N 1663N572CPCots Partners LLC · Saint Augustine, FLBuilt 2009 · S/N 3327N572CTDawson Aero LLC · Fayetteville, ARBuilt 2008 · S/N 3200N572GTBcg Aviation LLC · Nashville, ARBuilt 2007 · S/N 2448N573CDF R E Investments LLC · Enterprise, ALBuilt 2004 · S/N 1038N573CPThib Rentals LLC · Huntington Beach, CABuilt 2008 · S/N 3328N573DSDebrey Thomas M · Hilton Head Island, SCBuilt 2015 · S/N 0981N573JRHispania LLC · Camarillo, CABuilt 2006 · S/N 2305N573SRS & S Bridge Painting Inc · Kerrville, TXBuilt 2006 · S/N 2230N573TTHansa Capital LLC · Wilmington, DEBuilt 2016 · S/N 4344N573WBKinney Aviation LLC · Columbia, MOBuilt 2022 · S/N 8971N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643N574CDMassingale Harold L · Lenoir City, TNBuilt 2005 · S/N 1554N574CPLaunchpad Properties LLC · Corpus Christi, TXBuilt 2008 · S/N 3336N574CSNomic Air LLC · Vienna, VABuilt 2024 · S/N 9837N574HALow Approach LLC · Wilmington, NCBuilt 2001 · S/N TH-1975N574KKurz Douglas · Houston, TXS/N TH-1901N574RKHorn Aviation LLC · Hartland, WIFirst renewal noticeBuilt 2016 · S/N 4423N574RMCardinal Enterprises LLC · Denver, COBuilt 2004 · S/N 41007N574SBristol Aircraft Leasing LLC · Willoughby, OHBuilt 2002 · S/N 0343N574TBTransportation Air Services LLC · Fair Oaks Ranch, TXBuilt 2014 · S/N 0909N574WDLathrop Frederic W · Dayton, OHBuilt 1997 · S/N TH-1831N5754MJ & A Aviation LLC · Danvers, MABuilt 2020 · S/N 4945N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975N575CDG2 Aero LLC · Chattanooga, TNBuilt 2004 · S/N 0936N575CPHka Flying Club LLC · Hoover, ALBuilt 2008 · S/N 3341N575GWNeuse Aviation LLC · Smithfield, NCBuilt 2001 · S/N E-3390N575JPJpr Aviation LLC · Hillsdale, INBuilt 2024 · S/N 10350
Back to AD 2012-10-13