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.

N458BTBtr Aviation LLC · Somerset, PABuilt 2025 · S/N 11031N458CAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2002 · S/N 0388N458CPEagle Aviation LLC · Hawarden, IABuilt 2008 · S/N 3255N458CTAratow Michael · Mountain View, CABuilt 2000 · S/N EA-661N458DGIron Street Aviation LLC · North Kansas City, MOBuilt 1973 · S/N TH-296N458DJSurvey America Inc · Rancho Cordova, CABuilt 1980 · S/N U20605833N458EMEchomike Aviation LLC · Las Vegas, NVBuilt 2024 · S/N 9874N458JHVliegtuig Holdings LLC · Kalispell, MTBuilt 1996 · S/N E-3037N458RHHamil Robert D · Houston, TXBuilt 2005 · S/N 1688N458TTTurner George T · Alpharetta, GABuilt 2004 · S/N 0801N458TWFirst Aviation Co · Prospect Heights, ILBuilt 2003 · S/N 0697N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569N4599FCcs Flight Services LLC · Benton Harbor, MIS/N 340A0652N459CDUrsine Teleportation LLC · Redmond, WABuilt 2005 · S/N 1535N459CPCal Poly Corp · San Luis Obispo, CABuilt 2022 · S/N 8759N459JAThundercock Industries Worldwide LLC · Las Vegas, NVBuilt 2024 · S/N 10357N45BKTwo Six Ventures LLC · Fort Lauderdale, FLBuilt 2025 · S/N 10410N45BVGrinberg Dmitry · Austin, TXBuilt 2004 · S/N 1007N45CXRobin Aviation LLC · Plymouth, MIBuilt 2021 · S/N 5145N45DMRaolji Mahendra · Florida City, FLBuilt 2018 · S/N 4634N45FDFox Trot Delta LLC · Indianapolis, INBuilt 2017 · S/N 1641N45GLOptimal Aircraft Management Nc LLC · Sanford, MIBuilt 2006 · S/N 1870N45JNSpotts Marcus P · Nora Springs, IABuilt 2003 · S/N 0489N45KLOrloff Kenneth L Trustee · Groveland, CABuilt 2002 · S/N LIV-158N45KPColvin Clu D DBA · Big Cabin, OKBuilt 1971 · S/N 401B0201N45KSRentals Deltona 2 LLC · Orlando, FLBuilt 2025 · S/N 11080N45MEHarman Aviation LLC · Rockingham, VABuilt 2026 · S/N 11115N45MSBeech Flyers Inc · Champaign, ILBuilt 2001 · S/N E-3384N45PWEralet Inc · Middletown, DEBuilt 2019 · S/N 4841N45PZPaxton Aviation Inc · Cambridge, MABuilt 2024 · S/N 10324N45TFWave Transportation LLC · Middletown, DEBuilt 1982 · S/N 340A1507N45TRAltivian Holdings LLC · Camden, DEBuilt 2025 · S/N 10444N45WTMccarthy Brothers Aviation LLC · Albany, KYBuilt 2010 · S/N 3709N45XDSubstation Air LLC · Midvale, UTBuilt 1981 · S/N 21064495N45ZTCourter Industries Inc · Tampa, FLBuilt 2023 · S/N 9516N4600UDlw Aviation LLC · Missoula, MTBuilt 1983 · S/N 21064789N4601WMike Papa LLC · Newton, KSBuilt 1980 · S/N P21000622N4604NS O W Aviation LLC · Crystal River, FLBuilt 1980 · S/N 340A1016N4604QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 21059504N4607QSerrano Lynn A · Casa Grande, AZBuilt 1971 · S/N 21059507N4609UJerden Corp · Overland Park, KSBuilt 1979 · S/N U20605000N460CABravogolf Aviation LLC · San Jose, CABuilt 2024 · S/N 10352N460JPNewman Charles · Petaluma, CABuilt 2003 · S/N L2K-204N460SRBuchman Barry Joseph · Atlanta, GABuilt 2008 · S/N 3093N460WWMalibu Ww LLC · Fayetteville, GABuilt 1986 · S/N 46-8608022N4610KAvag Inc · Richvale, CABuilt 1979 · S/N P21000235N4612KChitiea Andrew D · Centennial, COBuilt 1979 · S/N P21000236N4617WSavoldelli Steven · Los Angeles, CABuilt 1980 · S/N P21000623N4618MBedrock Siteworks LLC · Coatesville, PABuilt 1978 · S/N TJ-150
Back to AD 2012-10-13