OpenAirDocs.org
AD 2012-21-05

Registered aircraft · 186

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-21-05')
    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-21-05')
  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.

N100ERMid-South Aviation LLC · Caruthersville, MOBuilt 2016 · S/N TH-2461N102CZMap Services Group Inc · West Palm Beach, FLS/N TH-2465N110GBBaron North G58 LLC · Orchard Park, NYBuilt 2023 · S/N TH-2543N122EEAir-Burt LLC · Rochester Hills, MIBuilt 2013 · S/N TH-2382N130PRPuerto Rico Police Department · San Juan, PRS/N TH-2338N158DGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2016 · S/N TH-2460N158EAElevation Air Capital LLC · Janesville, WIS/N TH-2542N158LFPro Tech Track & Tennis Management Lp · Bullard, TXBuilt 2014 · S/N TH-2425N158MRT-Bird LLC · Byron Center, MIBuilt 2011 · S/N TH-2312N158MST Hiers LLC · Barney, GABuilt 2017 · S/N TH-2492N158PCSewalt Steve · Victoria, TXBuilt 2018 · S/N TH-2500N158RWHeartfield J Thad · Beaumont, TXBuilt 2008 · S/N TH-2221N158YBCommercial Bank Aviation LLC · Harrogate, TNBuilt 2014 · S/N TH-2410N164MDehaan David J · San Diego, CABuilt 2010 · S/N TH-2295N169LALee Arnold Management Services Inc · Clearwater, FLBuilt 2017 · S/N TH-2494N16BKWc Aviation LLC · Forest, VABuilt 2012 · S/N TH-2335N16PVAlign Aviation LLC · The Woodlands, TXBuilt 2006 · S/N TH-2144N1710ABald Mtn LLC · Modesto, CABuilt 2016 · S/N TH-2462N172DHSanta Lucia 930 LLC · Greenwich, CTBuilt 2014 · S/N TH-2403N1756SRed Rocket LLC · Greenville, NCS/N TH-2301N176RKY-12 Investments LLC · Alexandria, VABuilt 2020 · S/N TH-2532N19LPZelta LLC · Wilmington, DEBuilt 2016 · S/N TH-2473N206BKGo Best Inc · Richmond Hill, GABuilt 2014 · S/N TH-2413N215GTInsulation By Cohens LLC · Moncks Corner, SCS/N TH-2439N215MBEta Flyers Aviation LLC · Florida, NYS/N TH-2133N218KAR3 Aviation LLC · Miami Lakes, FLBuilt 2009 · S/N TH-2267N219TBAir Fins LLC · Wilmington, DEBuilt 2007 · S/N TH-2197N224CAGas Aviation LLC · Elk City, OKBuilt 2010 · S/N TH-2279N225KMD&L Leasing Montana LLC · Kalispell, MTBuilt 2020 · S/N TH-2536N226LPLetourneau Plastics Inc · Oconto, WIBuilt 2014 · S/N TH-2409N228CENamrac Aviation LLC · Hazard, KYBuilt 2014 · S/N TH-2407N2315RLisse Vol Davion LLC · Baton Rouge, LAS/N TH-2438N23PRTaunton Skies LLC · Dover, DEBuilt 2008 · S/N TH-2243N241WB1rk Ltd · Winston Salem, NCS/N TH-2246N2448AAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2015 · S/N TH-2448N244EBanyan Aircraft Sales LLC · Fort Lauderdale, FLBuilt 2008 · S/N TH-2226N2458BTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N TH-2458N249DKK-Air Inc · Egg Harbor, WIBuilt 2017 · S/N TH-2487N24EKMurphree Bridge Corp · Troy, ALBuilt 2008 · S/N TH-2248N2503XDm Aviation LLC · Lexington, SCBuilt 2018 · S/N TH-2503N2554BTextron Aviation Inc · Wichita, KSS/N TH-2554N256PTBaron Aviation Inc Trustee · Wilmington, DEBuilt 2013 · S/N TH-2350N258SAEmv Properties LLC · Ponce, PRBuilt 2008 · S/N TH-2224N260KKingsboro Industrial Park LLC · Rocky Mount, NCBuilt 2012 · S/N TH-2331N265DBKlw Coastal Equipment LLC · Destin, FLBuilt 2008 · S/N TH-2241N265KBCedaron Medical Inc · Davis, CABuilt 2019 · S/N TH-2523N26LJN26lj LLC · Oklahoma City, OKBuilt 2012 · S/N TH-2352N28FXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N TH-2126N291CMAutorific High Performance Carwash Inc · Roxboro, NCBuilt 2007 · S/N TH-2195N294DWStenographer Aviation LLC · Aiken, SCBuilt 2017 · S/N TH-2478
Back to AD 2012-21-05