OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,307

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.

N136PFlying Daze · Batavia, OHS/N E-3029N136RFAltitude Flight Solutions LLC · Glasgow, MTBuilt 1995 · S/N E-2940N136TWilliams Jack K · Big Bear Lake, CABuilt 2018 · S/N 32-0005N136TBColwell Paul · Scottsdale, AZBuilt 2001 · S/N E-3419N136TCWeis Samuel K · Madera, CABuilt 1979 · S/N EA-15N136TTTyulyaev Vitaly N · Chesterfield, MOBuilt 2010 · S/N 411161N1379C79 Charlie LLC · Knoxville, TNS/N 0541N1379GTwo Golf Tango LLC · Albuquerque, NMBuilt 1976 · S/N 340A0078N137GBCalm Air Aviation · Nunica, MIBuilt 2006 · S/N 42538N137LUAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1021N137PEB & C Aero LLC · San Luis Obispo, CABuilt 2001 · S/N 0008N137SRForeman Guy W · Valparaiso, INS/N 1916N137TMFlyin 2 LLC · Hyde Park, UTBuilt 2020 · S/N 2202N1382CBerman Aviation LLC · Tulsa, OKBuilt 2003 · S/N 0534N1383GKuper Carl J II · Dalhart, TXBuilt 1976 · S/N 340A0082N1383ZFrancis Rick Trustee · Pleasanton, CABuilt 2020 · S/N 2224N1384MGolfestate Flyer LLC · Winter Garden, FLBuilt 2023 · S/N 9178N1385V303 Tango Charlie LLC · Newark, DEBuilt 1984 · S/N T30300266N138AHuff Air LLC · Uvalde, TXBuilt 2002 · S/N L2K-138N138CDN138cd LLC · Boca Raton, FLBuilt 2026 · S/N 11179N138CKMako Medical Laboratories LLC · Raleigh, NCBuilt 2009 · S/N 3492N138CRValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1584N138LACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11499N138MCCherington Cirrus LLC · Belmont, MABuilt 2019 · S/N 4755N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362N1393WWvl Aviation Inc · Wilmington, DEBuilt 2006 · S/N 42531N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712N139JMPegasus Medical Management LLC · Wilmington, DES/N 2742N139LCAmedeo Flight Ops Limited · Dublin 2Built 2018 · S/N 1769N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083N13ETRp Aviation LLC · East Troy, WIBuilt 2017 · S/N 1633N13KSNolt Ivan · Mount Solon, VABuilt 1974 · S/N 21060202N13LJLs Leasing LLC · Franklin, TNBuilt 2020 · S/N 2135N13MEMoonshine High LLC · Midland, TXBuilt 2025 · S/N 10661N13MLM3l LLC · Smyrna, TNBuilt 2007 · S/N 2573N13PCGj Aviation LLC · Mountain Lakes, NJBuilt 1984 · S/N 46-8408081N13PECamm Air · Spencer, IAS/N TJ-50N13PYMartinez De Garcia Linda M · Miami, FLBuilt 2012 · S/N 3872N13QAConscient LLC · Menlo Park, CABuilt 2020 · S/N 2099N13TNMcdaniel Robert M · Tonasket, WABuilt 1977 · S/N 21062428N13TWSouthern Aerial Service LLC · Douglas, GABuilt 1985 · S/N TH-1468N13URQualitair LLC Trustee · MichelstadtBuilt 2025 · S/N 11039N13XSRegistered aircraftBuilt 2007 · S/N LIV-516-SFB-DON1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277N1403CPinger Kevin · Palo Alto, CABuilt 2003 · S/N 0519N1408WLate10air LLC · Fullerton, CABuilt 2015 · S/N 4243N140BVGlobal Jetcare Inc · Brooksville, FLBuilt 2011 · S/N 3780
Back to AD 2012-10-13