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.

N98616Le Loi · Baton Rouge, LABuilt 1976 · S/N 340A0059N9861YRichard I Bennett LLC · San Jose, CABuilt 1981 · S/N 21064619N98624Jensen Hans · Gig Harbor, WABuilt 1976 · S/N 340A-0064N9862FX7 Ranch Inc · Merino, COFirst renewal noticeBuilt 1973 · S/N 340-0160N98649Dodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 402B1030N986CBMap Leasing LLC · Greenleaf, WIBuilt 1974 · S/N 340-0328N986CDDe Aguiar Sebastiao Fogaca · Miami, FLBuilt 2006 · S/N 1862N986DTHolroyd Aviation Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1630N986GMGospel Ministries International Inc · Collegedale, TNBuilt 1978 · S/N 414A0089N986JTDirect Sight Aviation Inc Trustee · Wilmington, DEBuilt 2014 · S/N 0937N986MSRush Aviation LLC · Hayden, IDS/N 340A0902N986SAscend Partners Funding LLC · Sacramento, CABuilt 2023 · S/N 9278N986WLLeggett Consulting LLC · Brookhaven, MSBuilt 2005 · S/N 1721N9870YDejong Arie H · Maricopa, AZFirst renewal noticeBuilt 1981 · S/N 21064621N98725First Flight Corp · San Diego, CABuilt 1976 · S/N 414-0824N98747American Skyways Inc · Corning, NYBuilt 1976 · S/N 340A0065N9876ZGv Air Inc · Medford, ORBuilt 1983 · S/N U20606721N987CARed Bird Partners LLC · Newark, DEBuilt 2011 · S/N 0251N987CDTrike Industries LLC · Draper, UTBuilt 2005 · S/N 1310N987JSAmerican Star Aviation LLC · Ithaca, NYBuilt 1999 · S/N TH-1923N987KCAsberry Gregg J · Sidney, ARBuilt 1990 · S/N E-2556N987PLColestine Holdings LLC · Ashland, ORBuilt 1985 · S/N 21064960N987TMRgm Aviation LLC · Brentwood, TNBuilt 2009 · S/N 3531N987TTEllison Thomas Andrew · Parker, TXBuilt 1993 · S/N E-2776N987WEstrada Alfonso · Santa Teresa, NMBuilt 2004 · S/N 1062N987WTRangerair LLC · Melbourne, FLBuilt 2006 · S/N 2125N98869Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0625N988CBDrill Pro LLC · Wilmington, DEBuilt 2016 · S/N 1313N988CDKading Kevin · Tucson, AZBuilt 2004 · S/N 0889N988DMHart Paul E · El Macero, CABuilt 1981 · S/N 340A1244N988JGSaratoga Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA-638N988JLL 3 Air LLC · Weston, WIBuilt 2010 · S/N 3639N988SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2038N988TJGossman Aviation LLC · Bloomfield Hills, MIBuilt 2023 · S/N 9056N988YTMdf Ventures LLC · Los Angeles, CABuilt 2001 · S/N EA-685N9890YValiair Lc Trustee · Casper, WYS/N 21064630N9894YRaymond Andy · Council Bluffs, IABuilt 1981 · S/N 21064632N98952Jim Leasco LLC · Ottawa Hills, OHBuilt 2022 · S/N 8845N989AAMouat Brian · Trent Woods, NCS/N 401A-0042N989BHookey Aviation LLC · Jackson, WYBuilt 2025 · S/N 10419N989BDGlacier Aircraft 3 LLC · Orlando, FLBuilt 2024 · S/N 9902N989BEPerformance Air LLC · Hobbs, NMBuilt 2022 · S/N 8907N989CAircraft Partner Holdings Inc Trustee · BerlinBuilt 2007 · S/N 2445N989DValiair Lc Trustee · Casper, WYBuilt 2016 · S/N 1295N989DFKearns Floyd M · Houston, TXBuilt 2003 · S/N 0554N989ECHagan Aaron Kirk · Park City, UTBuilt 2008 · S/N 3099N989HKTailwinds Aviation LLC · New Orleans, LABuilt 2019 · S/N 4859N989MBBhasin Monica · Holtsville, NYBuilt 2026 · S/N 11462N989MPSgl LLC · Dubuque, IABuilt 2023 · S/N 9251N989PSReliable Property Solutions LLC · Stockbridge, GABuilt 2014 · S/N 4104
Back to AD 2012-10-13