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.

N3206YN3206y Aviation LLC · Bloomfield Hills, MIBuilt 1994 · S/N E-2903N3209DCirrus 1jr LLC · Webster, NYBuilt 1994 · S/N TH-1735N3209JDennis John W · Mooresville, NCBuilt 2000 · S/N E-3299N320BVLaird Brian N · Monument, COBuilt 2005 · S/N 1N320CAArmstrong Resource Management Corp · Knoxville, TNBuilt 2014 · S/N 0822N320CDSimpulse Inc · Oregonia, OHBuilt 2004 · S/N 1248N320DFDfig Holdings LLC · Kalispell, MTBuilt 2025 · S/N 11068N320DGSrs 320 LLC · Houston, TXBuilt 2023 · S/N 9402N320DRMontgomery Machine LLC · Guilford, CTBuilt 2005 · S/N 42064N320EBKenmore Crew Leasing Inc · Bellingham, WABuilt 2025 · S/N 10744N320ETVdv Properties LLC · Bend, ORBuilt 2014 · S/N 0792N320MSConsulat Inc · Cheyenne, WYBuilt 1966 · S/N 320E-0065N320PCAom Aircraft LLC · Wilmington, DES/N 402B0621N320RLLast Flight Out LLC · Brentwood, TNBuilt 2006 · S/N 1854N320RMRd Harrison Inc · Lexington, NCS/N 340A0939N320RRHighway Aero LLC · Bristow, VABuilt 2002 · S/N 0358N320SKDevries James E · Bejou, MNBuilt 1967 · S/N 320E-0077N320SWEast West Investment Advisors LLC · Sandy Point, VABuilt 1980 · S/N 414A0451N320TJBlaylock Arthur S III · Pace, FLBuilt 1963 · S/N 320B0017N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027N3212DHalo Aviation Corp · Wilmington, DES/N EA-651N3212GGibby Aviation Inc · Wilmington, DEBuilt 1994 · S/N EA-569N3213DMountaingales LLC · Phoenix, AZBuilt 1998 · S/N E3213N3214ZYounger Aviation LLC · Poteau, OKBuilt 1994 · S/N E-2911N3215DSchlund James F · Chico, CABuilt 1994 · S/N E-2912N3215UAileron T LLC · Orlando, FLBuilt 1994 · S/N E-2915N3216MN3216m Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0826N3216ZMy Fly LLC · Wilmington, DES/N E-2922N3217EDavis Darren · Flint, TXBuilt 1995 · S/N E-2926N3217MN3217m LLC · Polson, MTBuilt 2000 · S/N E-3317N3218XMjm Flying LLC · Traverse City, MIBuilt 2000 · S/N E-3358N321AZBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0508N321BGItinerant Orl LLC · Columbia, SCBuilt 2005 · S/N 1311N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792N321CEGreen Eggs And Ham Aero LLC · Helena, MTBuilt 1981 · S/N 421C1225N321CFTekswork Aviation LLC · London, KYBuilt 2002 · S/N 0304N321DDGreene Jonathan U · Pompano Beach, FLBuilt 1980 · S/N TJ-278N321EKCielo Holdings Group LLC · Ormond Beach, FLBuilt 2024 · S/N 10172N321ETVlt Aviation LLC · Tampa, FLBuilt 2025 · S/N 10940N321FLSkywalker Aviation LLC · Saint Paul, MNBuilt 2009 · S/N 3392N321GKBrown Water Associates LLC · Monticello, FLBuilt 2015 · S/N 4290N321GSXenu Aircraft LLC · Hatfield, PABuilt 2018 · S/N 1675N321HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 414-0625N321HBYosemite Axe Throwing · North Fork, CABuilt 2015 · S/N 4257N321HTPartnairs LLC · Lake Charles, LABuilt 2015 · S/N 4246N321JAJa Consulting LLC · Delray Beach, FLBuilt 2025 · S/N 10674N321JHSkidmore Gary DBA · Terreton, IDBuilt 1978 · S/N 414A0063N321JJJayjet Private Aircraft Charter LLC · Swanton, OHBuilt 2004 · S/N 1113N321JMEo Liquidation Inc · Whitehouse Station, NJBuilt 2019 · S/N 1902N321JRAcademy Aviation Services LLC · Cedar Park, TXBuilt 1982 · S/N EA-289
Back to AD 2012-10-13