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.

N512UTFrank G Davis Holding Company LLC · Lakeway, TXBuilt 2024 · S/N 10341N512XPilot Henry LLC · Big Prairie, OHBuilt 2004 · S/N 41041N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087N5131QLeavitt Craig S · Spicewood, TXBuilt 1972 · S/N 21059631N5134CEzrydr LLC · Huntsville, ALBuilt 1982 · S/N 414A0852N5134WPlane Fun Inc Tr Trustee · Snellville, GAS/N P21000643N513CRN513cr LLC · Redondo Beach, CABuilt 2023 · S/N 9489N513DWright Aero Inc · Saint Cloud, MNBuilt 1976 · S/N 340A0048N513DRSternhagen Richard · Sweetwater, TNBuilt 2005 · S/N 29-0407N513JPMcbutler Aviation LLC · Hutto, TXBuilt 2018 · S/N 1693N513PZSun Evergreen LLC · Lloyd Harbor, NYBuilt 2019 · S/N 1978N513SROdan Aero LLC · Alpharetta, GABuilt 2006 · S/N 2059N513STAllensworth Timothy Lee · Bladenboro, NCBuilt 2009 · S/N 421019N513TM7 Romeo Bravo LLC · Reno, NVBuilt 2005 · S/N 111N513TWGabriel Aviation LLC · Jacksonville, FLBuilt 2015 · S/N 4267N513UCPoint Breeze Aviation LLC · Vlg Of Lakewd, ILBuilt 2023 · S/N 9297N513WCayuga Aviation LLC · Ithaca, NYBuilt 2007 · S/N 2707N513WCWk&H Ventures · Dorchester, NEBuilt 2013 · S/N 0519N513XFarina Paul A · Liberty Twp, OHBuilt 2012 · S/N 3886N513YZCenturion Aviation LLC · Appleton, WIBuilt 2023 · S/N 9349N513ZPlain Nuts LLC · Dover, DEBuilt 2005 · S/N 1734N513ZMBullard Aerospace Corp · Boston, MABuilt 1999 · S/N 29-0202N5140JTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 340-0530N5141QImagination Publications Inc DBA · Saratoga, WYBuilt 1972 · S/N 21059641N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851N5147YN5147y LLC · Andover, MNBuilt 2004 · S/N 0848N514BRJmb Aviation LLC · Iowa City, IABuilt 2004 · S/N 1245N514CCResa Group LLC · Brunswick, GABuilt 2023 · S/N 9495N514DTNorth Shore Aviation Inc · Merrick, NYBuilt 2006 · S/N 1972N514EDFarris Stephen L · Hickory, NCBuilt 2005 · S/N 1420N514HRSethi Inderdeep Singh · Tracy, CABuilt 1980 · S/N EA-70N514LPInvader Aviation LLC · Tijeras, NMBuilt 1980 · S/N 414A0507N514NCHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0514N514PZBig Red Aviation LLC · Truckee, CABuilt 2022 · S/N 8505N514RJDoin Blue LLC · Seneca, SCBuilt 2025 · S/N 10901N514RTPanitz Law Group Apc · Cerritos, CABuilt 2022 · S/N 8990N514SGBorland Equipment Leasing LLC · Midland, TXBuilt 2000 · S/N 29-0257N514SLPurple Wings LLC · Denver, COBuilt 2020 · S/N 2175N514SMEleven Eleven Aviation LLC · Rockwall, TXBuilt 2005 · S/N 1303N514SRHarbor Aviation Ltd · Camarillo, CABuilt 2006 · S/N 1873N5150B5150 Aviation LLC · Broken Arrow, OKBuilt 2022 · S/N 9015N5150EM & M Aviation Enterprises LLC · Springfield, MOS/N E-3412N5151JHalverson Mechanical Inc · Ogden, UTBuilt 1975 · S/N 340-0541N5151QNotsa LLC · Morrison, COBuilt 1972 · S/N 21059651N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292N515BPBsport Enterprises LLC · Bonita Springs, FLBuilt 2024 · S/N 10384
Back to AD 2012-10-13