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.

N870CDZugski LLC · Nederland, COBuilt 2002 · S/N 0305N870CHBuzz Light LLC · Baton Rouge, LABuilt 2024 · S/N 10009N870CVValiair Lc Trustee · Casper, WYBuilt 2021 · S/N 5000N870FSLindsey Norman A · Richardson, TXBuilt 1987 · S/N 4608051N870FVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 10087N870UOhio University · Albany, OHBuilt 2002 · S/N TH-2036N870VLCaribbean Flyers LLC · San Juan, PRBuilt 1981 · S/N 402C0616N870WPMartin Scot · Las Cruces, NMBuilt 2016 · S/N 1380N8711KGraham Thomas R · Bonita Springs, FLS/N 340A0627N8712KKirkmeyer Thomas · Kimberly, IDBuilt 1978 · S/N 340A0628N871ANWnd Aircraft Management LLC · Miami, FLBuilt 1993 · S/N TH-1678N871DLRegistered aircraftBuilt 2021 · S/N 2478N871JBAas Baron LLC · Houston, TXS/N TH-2038N871JKKafer John H Trustee · Troy, ILBuilt 2023 · S/N 9350N871TXNlmds Leasing LLC · Tierra Verde, FLBuilt 2006 · S/N 29-0449N871VLZee Enterprise Inc · Chicago, ILBuilt 1980 · S/N 402C0290N8720KZielinski John P · Queen Creek, AZBuilt 1978 · S/N 340A0631N87221Chester Darren Dw · Sioux Falls, SDS/N 310R0306N8725QN8725q LLC · Grand Junction, COBuilt 1976 · S/N U20603478N8727387273 LLC · Reno, NVBuilt 1975 · S/N 310R0330N8727KFrosty Acres LLC · Hailey, IDS/N 340A0633N87293Dinaland Aviation · Vernal, UTS/N 310R0505N872CDOmk Freedom LLC · Los Angeles, CAS/N 0364N872CPRohman Diane L · Vero Beach, FLBuilt 2015 · S/N 4204N872SRSteward Builders · Weatherford, TXBuilt 2007 · S/N 2780N872WHTheologos Charles · Waveland, MSBuilt 1993 · S/N TH-1679N872YHoward Donald · Farmington, NMS/N 41047N87356Kovacs Endre · Plant City, FLBuilt 1975 · S/N 310R0527N87393310 Amigos LLC · Stuart, FLS/N 310R0542N873MMInternational Air Services Inc Trustee · Carson City, NVBuilt 2023 · S/N 9532N873WHG & A Viation LLC · Miller, MOBuilt 1993 · S/N TH-1680N87443Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0562N87481Petersen Donald W · Bullhead City, AZBuilt 1976 · S/N 310R0587N874BHNsd Air LLC · Osage Beach, MOBuilt 2015 · S/N 4260N874CDEmerald Coast Pilots LLC · Panama City, FLS/N 0285N874CPRm Aviation LLC · Clarkrange, TNBuilt 2018 · S/N 4713N874DCFour Delta Charlie LLC · Fort Wayne, INBuilt 2022 · S/N 8804N874WBEndurrence Aviation LLC · Savannah, GABuilt 2007 · S/N 2424N874WHRed Oak Aviation LLC · Sunset, LABuilt 1993 · S/N TH-1681N87536Krull Jesse L · Bismarck, NDBuilt 1981 · S/N 340A1254N8756QTriple 2 LLC · Burlington, COBuilt 1976 · S/N U20603509N8758QBerge Christian · Mccall, IDBuilt 1976 · S/N U20603511N875JTCw Wings LLC · Sandy, UTBuilt 2021 · S/N 2305N875PLBenvenuti Darel · Newport Beach, CABuilt 1965 · S/N CD-875N8765TBluefin Water Solutions LLC · Purcell, OKBuilt 2007 · S/N 2582N876AAAwalt James Clinton · Lago Vista, TXFirst renewal noticeBuilt 2020 · S/N 4898N876AHMja Sr22t LLC · Belleville, ILBuilt 2023 · S/N 9135N876CPScg Consulting LLC · Myrtle Beach, SCBuilt 2008 · S/N 3271N876DYDak Aviation LLC · Lake Lotawana, MOBuilt 2017 · S/N 1528N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844
Back to AD 2012-10-13