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.

N999SJInfinity Commercial And Industrial Concrete LLC · New Braunfels, TXBuilt 2025 · S/N 10873N999SKWkqm LLC · Wilmington, DEBuilt 1997 · S/N TH-1815N999TFSpencer Brett · Kila, MTS/N 2500N999XGL&W Holdings And Trust Inc · North Fort Myers, FLBuilt 2006 · S/N 2018N99BYAirria Holdings LLC · BerlinBuilt 2004 · S/N 0825N99CDPapa'S Hatchn Enterprises Inc · Wilmington, DEBuilt 2002 · S/N 0283N99CPEight One Whiskey LLC · Orinda, CABuilt 2018 · S/N 1670N99CWSurf & Summit Aviation LLC · Jupiter, FLBuilt 2025 · S/N 10844N99GWWatson Green Energy LLC · Alamogordo, NMBuilt 2025 · S/N 10974N99HJMf Property Management LLC · Hattiesburg, MSBuilt 1978 · S/N 414A0041N99HSSpecialty Stainless Installations Inc · Chino, CABuilt 2019 · S/N 1909N99JTNunavat Aviation LLC · Edmond, OKBuilt 2022 · S/N 8783N99JZUnadventurous LLC · Amarillo, TXBuilt 1984 · S/N TJ-474N99KESedrak Michael · Corona, CABuilt 2006 · S/N 2303N99MSLubell Daniel R · Bothell, WABuilt 1998 · S/N 29-0157N99MUGooney Aviation LLC · Camden, DEBuilt 2021 · S/N 5144N99PAMckelvey Jeffrey R · Dadeville, ALBuilt 1978 · S/N TJ-179N99PYR&R 22t2 LLC · Wilmington, DEBuilt 2024 · S/N 9769N99RKNorth Shore Flying Club · Libertyville, ILBuilt 1992 · S/N TH-1649N99SL99sl LLC · Boston, MABuilt 2015 · S/N 4181N99TDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1991 · S/N TH1641N99UK99 Air Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11146N99UWTaz Aviation LLC · Middleton, WIBuilt 2017 · S/N 1551N99VBC&S Aviation Partners LLC · Thibodaux, LABuilt 1980 · S/N EA-154N99VMDaniel M Skotte Do Pc · Sunriver, ORBuilt 1980 · S/N EA-140N99WWu Lei · San Marino, CABuilt 2024 · S/N 9962N99WTSudick Daniel · Dadeville, ALBuilt 2000 · S/N TH-1959N99XLSeawind LLC · Newport, RIBuilt 2010 · S/N 0018N99YZEdwal Aviation LLC · Reno, NVBuilt 1981 · S/N 21064608N99ZDAir Helmuth LLC · Statesville, NCBuilt 2007 · S/N 2423N9AWRegistered aircraftBuilt 2024 · S/N 9827N9BHBeh Aviation Group LLC · Port Matilda, PABuilt 2007 · S/N 2374N9DMMaloney Leasing LLC · Tupelo, MSBuilt 2026 · S/N 11280N9DVNorwood Ronald Steven · Raleigh, NCBuilt 1981 · S/N EA-193N9EPMcavian LLC · Perryton, TXBuilt 1981 · S/N TJ-378N9GFApruda Andri Trustee · Nashville, TNBuilt 1988 · S/N 4608127N9JBRgpe Consulting LLC · Wilmington, DEBuilt 1999 · S/N 29-0199N9JRBringle Cory · North Liberty, IABuilt 2020 · S/N 2061N9LSAmsprop USA Holding Inc · Boca Raton, FLBuilt 2023 · S/N 9164N9LTRegistered aircraftBuilt 2001 · S/N TH-1989N9MPYen Albert S · Hermosa Beach, CABuilt 2002 · S/N E-3471N9MWPoint Of Rocks LLC · Lakewood Ranch, FLBuilt 2026 · S/N 11301N9NCEmpresas Marex Inc · Mayaguez, PRBuilt 1978 · S/N 414A0202N9NSTs&L Aircraft LLC · Alexandria, MNBuilt 1979 · S/N TJ-238N9PJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 3240N9RYDpr Capital LLC · Farmington, UTS/N 340A0211N9SHSenza Limiti LLC · Park City, UTBuilt 1980 · S/N EA-52N9SZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1232N9TFBender Glenn Steven · Lovell, MEBuilt 1948 · S/N NAV-4-1396N9TRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 21059846
Back to AD 2012-10-13