AD 2012-14-15

Registered aircraft · 832

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-14-15')
    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-14-15')
  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.

N23GMMain Line Executive Travel LLC · Haverford, PABuilt 2018 · S/N 1827N240PWOak Street Aviation LLC · Wichita, KSBuilt 2015 · S/N 1550N242NGPanhandle Telecommunication Systems Inc · Guymon, OKBuilt 2010 · S/N 1242N242SGReppert Capital Management LLC · Houston, TXBuilt 2009 · S/N 1108N243TXTexas Department Of Public Safety · Austin, TXBuilt 2012 · S/N 1328N244Eight Hills LLC · Seattle, WABuilt 2011 · S/N 1307N245HCHillsborough County Sheriffs Office · Tampa, FLBuilt 2025 · S/N 2450N245PEReack Aviation LLC · Wilmington, DEBuilt 2010 · S/N 1245N246ELTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 2224N246SJSparkjoy Air LLC · Boulder, COBuilt 2018 · S/N 1826N247AMRegistered aircraftBuilt 2023 · S/N 2308N247CU283cu LLC · Gilcrest, COBuilt 2020 · S/N 2047N247MKOoooia LLC · Marshalltown, IABuilt 2022 · S/N 2196N247SHUS Government · Washington, DCBuilt 2024 · S/N 2367N248LMPilatus Aircraft USA Ltd · Broomfield, COBuilt 2024 · S/N 2362N248MSPilatus Aircraft USA Ltd · Broomfield, COBuilt 2011 · S/N 1287N249GXWildcat Aviation LLC · South Salt Lake, UTBuilt 2023 · S/N 2249N24XZ31dodge Air LLC · Kernersville, NCS/N 1657N250KKNeed For Speed Aerospace LLC · Downers Grove, ILBuilt 2024 · S/N 2383N251NGJa Investments Inc · Toledo, OHBuilt 2010 · S/N 1251N254DLCrimson Phoenix LLC · Kalispell, MTBuilt 2019 · S/N 1917N256BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 1648N256TWTw Leasing LLC · Oxford, CTBuilt 2008 · S/N 1056N257TWTw Leasing LLC · Oxford, CTBuilt 2024 · S/N 2377N257WBRoyal Gorge Management Consulting LLC · Canon City, COBuilt 2023 · S/N 2309N259PCNew Mfis Holdings LLC · Topeka, KSBuilt 2010 · S/N 1259N259TWTw Leasing LLC · Oxford, CTBuilt 2025 · S/N 2446N25MTMiss Liberty LLC · West Hartford, CTBuilt 2024 · S/N 2338N25NGWood River Aviation Partners LLC · Hailey, IDBuilt 2013 · S/N 1425N25NXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 1125N25UCHarns Pc-12 LLC · Perris, CABuilt 2025 · S/N 2473N25XMMccluer Aviation LLC · North Las Vegas, NVBuilt 2019 · S/N 1896N261HBChamonix Air LLC · Boulder, COBuilt 2010 · S/N 1261N261NXCitizens National Bank Of Texas · Waxahachie, TXBuilt 2020 · S/N 2061N264SGAdventaire LLC · Minot, NDBuilt 2021 · S/N 2149N265NXCmr3 Holdings LLC · Newark, DEBuilt 2011 · S/N 1265N266NGBlue Horizon Ventures LLC · Gadsden, ALBuilt 2011 · S/N 1266N267PTBlades & Bars LLC · Montrose, COBuilt 2022 · S/N 2169N269NGRebel One LLC · Dover, DEBuilt 2010 · S/N 1243N26NGAgb Warranty Services LLC · Warrenton, VABuilt 2013 · S/N 1426N26WRWonderful Orchards LLC · Shafter, CABuilt 2022 · S/N 2181N26XMAm Aviation LLC · Henderson, NVBuilt 2023 · S/N 2312N270AFRigi Inc · Portsmouth, NHBuilt 2023 · S/N 2270N2710BDrglfg LLC · Denver, COBuilt 2018 · S/N 1809N272NGCactus Land Development LLC · Fountain Hills, AZBuilt 2011 · S/N 1272N276HDRussoms Cloud Server LLC · Montgomery, ALBuilt 2023 · S/N 2276N278JMJlm Aviation LLC · Winthrop, MEBuilt 2012 · S/N 1367N27KNStuckey Connections LLC · Magnolia, TXBuilt 2011 · S/N 1282N27NXValiair Lc Trustee · Casper, WYBuilt 2021 · S/N 2117N283AFJ3b LLC · Portsmouth, NHBuilt 2023 · S/N 2283
Back to AD 2012-14-15