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.

N87RJNorris Aviation LLC · Mansfield, TXBuilt 1976 · S/N 310R0676N87RRBahnair LLC · Oklahoma City, OKS/N TJ-34N87SM10269 Flight LLC · Bainbridge Island, WABuilt 1990 · S/N TH-1587N87TUThree Eagles LLC · Kalispell, MTBuilt 2021 · S/N 2320N87URElemet Equipment Leasing LLC · Camden, DEBuilt 2020 · S/N 2186N8801GAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 340A0986N880AMj Aviation LLC · Denham Springs, LABuilt 1973 · S/N 414-0397N880CDAl Batross Air LLC · Guntersville, ALS/N 0300N880MSSkylane Cirrus LLC · Sarasota, FLBuilt 2023 · S/N 9136N8817MUniversal Aircraft Holdings LLC · Waterford, MIBuilt 2006 · S/N 2064N8818MCapitol Flyers LLC · Jefferson City, MOBuilt 2004 · S/N 0901N881CHl Air LLC · Scottsdale, AZBuilt 2021 · S/N 2280N881CAPechts Contracting LLC · Church Road, VABuilt 2012 · S/N 0275N881JVVoss James S · Boulder, COBuilt 2004 · S/N 1032N881PGPlane Pro Aviation LLC · Shelby, NCBuilt 2018 · S/N 1683N881PJJohnson Patrick Allen · Olive Branch, MSBuilt 1973 · S/N 310Q0754N881PMG5 Partners LLC · Reno, NVBuilt 2014 · S/N 0883N881RTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 10955N881SRCjc Design Inc · Yorba Linda, CABuilt 2007 · S/N 2722N881TCBrait Aviation LLC · Edina, MNBuilt 2005 · S/N 1649N881TJBarron Eddie T · Amarillo, TXBuilt 1972 · S/N 414-0259N881WCSale Reported · Gainesville, FLSale reportedBuilt 2011 · S/N 0125N881WD306kc LLC · Hockley, TXBuilt 2004 · S/N 1215N881XPKusenberger Don L · Little Rock, ARS/N 2077N8822G22g LLC · San Jose, CABuilt 2020 · S/N 2227N8823HBowers Phillip P · Clayton, NCBuilt 1970 · S/N 21059314N882BCTechnology Aviation Services LLC · Covington, GABuilt 1973 · S/N 414-0470N882CJkz Properties LLC · Port Orange, FLBuilt 2016 · S/N 1278N882CDRegistered aircraftBuilt 2002 · S/N 0295N882CTCharlie Tango Aviation LLC · Rocklin, CABuilt 1990 · S/N E-2566N882SL882 Aviation Inc · Tarrytown, NYBuilt 2018 · S/N 4736N882SRAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 2384N882WBWright Bros Flying Club LLC · Lewes, DEBuilt 2002 · S/N 0360N8837ZPepple Tom · Medford, ORBuilt 2012 · S/N 0418N883CBBraly Capital Management LLC · Seal Beach, CABuilt 2020 · S/N 4874N883ELEcho Lima LLC · Irvine, CABuilt 2016 · S/N 4322N883ESAustin J Ma M D Pc · Los Angeles, CAS/N 2124N883JPGemis Paul · Nantucket, MABuilt 2002 · S/N 0363N883TFWhamola Inc · San Rafael, CABuilt 2018 · S/N 4609N884Patronus Wings LLC · Scottsdale, AZBuilt 2021 · S/N 5062N884CN884c LLC · Georgetown, SCBuilt 2003 · S/N 0446N884CDBcd Aviation LLC · Waleska, GABuilt 2005 · S/N 1567N884LMVc Travel LLC · Fairport, NYBuilt 2024 · S/N 10377N884SRBt Aviation LLC · Monclova, OHBuilt 2006 · S/N 2080N884SWMountain Lion Aviation LLC · Truckee, CABuilt 2017 · S/N 1562N884TLT Lo Airways LLC · Mesquite, TXBuilt 2025 · S/N 10533N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239N8851LHong Yun Ji LLC · Traverse City, MIBuilt 2017 · S/N 4457N88521Godfrey Pharis · Missouri City, TXBuilt 1981 · S/N 340A1260N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240
Back to AD 2012-10-13