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.

N927WABradford J Thompson · Blacklick, OHBuilt 2006 · S/N 1807N9281YSharp Darren J · Musselshell, MTBuilt 1986 · S/N 46-8608027N9284CCaptain Caroline LLC · Bismarck, NDBuilt 2024 · S/N 10218N928CRCasas De Colores Inc · Santa Fe, NMBuilt 1977 · S/N 340A0434N928CSLeatherman Eric · Lincoln, NES/N 0636N928DHHolt Runway Group LLC · Fayetteville, TNBuilt 2024 · S/N 10189N928KMSchmoker William C · Eden Prairie, MNBuilt 2001 · S/N EA-672N928LTBig Money Management LLC · Greenville, SCBuilt 2022 · S/N 8879N928MWMontana Skies LLC · Kalispell, MTBuilt 2022 · S/N 8947N928PCBayou Self Aviation LLC · Covington, LABuilt 2008 · S/N 411003N928PMSilver Star LLC · Beverly Hills, CABuilt 2007 · S/N 2712N928RSEzskies Air Service LLC · Hayden, IDBuilt 1978 · S/N TJ-138N928SDGrace Aviation LLC · Kalispell, MTBuilt 2025 · S/N 10979N928SK0928 Aviation Inc Trustee · Wilmington, DEBuilt 2014 · S/N 0928N928ZTAa Aviation LLC · Peachtree City, GABuilt 2023 · S/N 9491N929Gentle Ben 2 LLC · Rome, GABuilt 2022 · S/N 8706N92903Nalle W B · Austin, TXBuilt 1981 · S/N 310R2140N9295YSln Aviation LLC · Salina, KSBuilt 1986 · S/N 46-8608032N929AMM&M Flying LLC · Boston, MABuilt 2021 · S/N 5024N929BLFactora Property Management LLC · Bloomington, INBuilt 2008 · S/N 2898N929BRDarvis Enterprises LLC · Dallas, TXBuilt 2017 · S/N 1606N929CPSpark Aviation LLC · Shreveport, LAS/N 0856N929DCPremier Flight LLC · El Cajon, CABuilt 1979 · S/N 340A0934N929DEDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 0293N929DRAir Force Two LLC · Superior, WIS/N 4441N929GKCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11512N929HBSaratoga Transporation LLC · Encino, CAS/N 414-0509N929JDMake Aviation Great Again LLC · Kalispell, MTBuilt 1987 · S/N E-2387N929MBRock Aviation LLC · Ankeny, IABuilt 2025 · S/N 10456N929MGAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2006 · S/N 1792N929RSchneider Franz · Bacliff, TXBuilt 2001 · S/N 0133N929SEHogge William Edward · Pageland, SCBuilt 2006 · S/N 2244N929WSecond Star To The Right Aviation LLC · Atlanta, GABuilt 2025 · S/N 11050N929ZABearcat Aviation LLC · Chester, NJBuilt 2011 · S/N 3818N92BKJf Investments LLC · Port Orange, FLBuilt 2022 · S/N 8870N92BMNugent James S · Diamondville, WYS/N P21000557N92BZWhelan Holdings LLC · Howardstown, KYBuilt 2004 · S/N 0908N92CDZeneski Andrew J Sr · Wake Forest, NCBuilt 2002 · S/N 0299N92CKKingsborough James D · Carlisle, PABuilt 1978 · S/N P21000160N92DKruckeberg John R · Sanford, NCS/N DUNHAM 0002N92DEDesert Eagle Operating LLC · Dallas, TXBuilt 2022 · S/N 8521N92DLDavis Air LLC · Phoenix, AZBuilt 1976 · S/N 340A0204N92DSBooty Bill · Idaho Falls, IDBuilt 1975 · S/N 21060847N92HJWoolley Air LLC · Kilgore, TXBuilt 1991 · S/N TH-1621N92HWWinners Church Inc · Edmond, OKBuilt 1999 · S/N 30-0012N92JFBarnstormer Leasing LLC · Newark, DEBuilt 2021 · S/N 2246N92LBThree Js Aviation LLC · Mattapoisett, MABuilt 2023 · S/N 9430N92NFPlane Xtc LLC · Gualala, CABuilt 2016 · S/N 1425N92PAMarz Richard F · Statesboro, GABuilt 2003 · S/N 29-0304N92PF1954 Aviation Holdings LLC · Dover, DEBuilt 2020 · S/N 2126
Back to AD 2012-10-13