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.

N91183Hatch Hyrum G · Gilbert, AZBuilt 1969 · S/N 20700106N911ADHerr Allison · Union, CTBuilt 2017 · S/N 1585N911KESr Aviation LLC · Shady Shores, TXBuilt 2008 · S/N 3187N911KJRosie Aircraft Leasing LLC · Naples, FLBuilt 2014 · S/N 0849N911KMWeckbacher Robert K · Mount Pleasant, SCBuilt 1997 · S/N 29-0125N911SPScott & Patty Aviation LLC · St Pete Beach, FLBuilt 2022 · S/N 8924N911TKAbsolute Precision Chiropractic Inc · Jesup, GABuilt 2004 · S/N 1001N911TWStepp Dave A · Ruidoso, NMBuilt 2008 · S/N 3172N9120YEast West Aviation LLC · Joaquin, TXBuilt 1985 · S/N 46-8608010N9121XCarter Associates Inc · Burr Oak, MIBuilt 1987 · S/N 4608094N9122LBerman Joshua E · Nashua, NHBuilt 1987 · S/N 4608096N9122NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1987 · S/N 4608097N9122YCook Auction Co Inc · Clinton, MOBuilt 1985 · S/N 46-8608011N9123VEschenbach Ralph F · Woodside, CAS/N 4608060N91242Nsi Aviation LLC · Ozark, MOFirst renewal noticeBuilt 2000 · S/N 29-0236N9124MBertini Tony B · Du Bois, PABuilt 1994 · S/N 29-0007N9124YAerobox LLC · Seattle, WABuilt 1985 · S/N 46-8608012N9125BStockton Aviation Group LLC · Stockton, CABuilt 1987 · S/N 4608068N9125YKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N U20603324N9127ZPalmy LLC · Lander, WYBuilt 1987 · S/N 4608059N912BJKaluco Enterprises LLC · El Paso, TXBuilt 2006 · S/N 2259N912DTTd Enterprise LLC · Lewes, DEBuilt 2015 · S/N 4203N912GLFtg 929 LLC · Carlsbad, CABuilt 2005 · S/N 1336N912MH James & Sons Inc · Fennimore, WIBuilt 2001 · S/N E-3379N912SCCrest Five Associates Inc · Breinigsville, PABuilt 1991 · S/N TH-1646N912TACirrus Design Corp · Duluth, MNBuilt 2023 · S/N 9621N912VVTvpx Aircraft Solutions Inc · North Salt Lake, UTBuilt 2023 · S/N 9043N912WTNew Tech Construction LLC · Wilmington, DEBuilt 1977 · S/N 340A0353N912YZBorders Fairskies LLC · Atlanta, GABuilt 2023 · S/N 9450N9131QTanlin LLC · Chicago, ILBuilt 1987 · S/N 4608082N9131XWomack Equipment Leasing LLC · Terre Haute, INBuilt 1987 · S/N 4608083N91324Hasty Benjamin R Jr · Lynn Haven, FLBuilt 1997 · S/N 29-0119N9132BAijaz Ahsan · Dallas, TXBuilt 1995 · S/N 29-0062N9133GConsolidated Consulting Inc · Norfolk, NEBuilt 1988 · S/N 4608111N9133VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1988 · S/N 4608112N913ADPatriot Freight LLC · Pewaukee, WIBuilt 2005 · S/N 1520N913AGAgfg LLC · Millsboro, DEBuilt 2014 · S/N 4065N913BTOutnumbered Pilot LLC · Spanish Fork, UTBuilt 2005 · S/N 1271N913CFBg Sr22 LLC · Greeley, COBuilt 2013 · S/N 0466N913CNLone Tree Island Aviation LLC · Winter Park, FLBuilt 2004 · S/N 1217N913DBMerrell Mark Reid · Kennewick, WABuilt 2012 · S/N 0379N913GTParow Frederickb · Elizabethtown, PABuilt 2004 · S/N 1030N913KSPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 29-0423N913MTD & D Aviation Holdings LLC · Chelsea, ALBuilt 2005 · S/N 1597N913PMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2006 · S/N 42524N913RJWall Bernardo · Seminole, TXBuilt 2008 · S/N 3023N913SEHill Capital Leasing LLC · Phoenix, AZBuilt 1978 · S/N P21000038N913TJFly Happy LLC · Linden, MIBuilt 2023 · S/N 9036N9143Origin Property Group LLC · Brookline, MABuilt 2019 · S/N 1842N9146RZoll Ross H · Glen Allen, VABuilt 1988 · S/N 4608138
Back to AD 2012-10-13