AD 2012-06-17

Registered aircraft · 284

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-06-17')
    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-06-17')
  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.

N58AJSe Sfj LLC · Great Neck, NYBuilt 2010 · S/N 4188N592FCJuno Aviation LLC · Juno Beach, FLBuilt 2008 · S/N 4144N59APComputer Sciences Corp · Tysons, VABuilt 2008 · S/N 4127N59CFTailwind Holdings LLC · San Ramon, CABuilt 2007 · S/N 4097N606PSWorldwide Option LLC · Lewes, DEBuilt 2002 · S/N 1477N607DDominion Energy Services Inc · Richmond, VABuilt 2017 · S/N 4365N609EZYates Aviation LLC · Texarkana, TXS/N 4165N609STWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 4153N611JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4256N612AFAmeriprise Financial Inc · Oxford, CTBuilt 2006 · S/N 4069N615TT17 South Briar Hollow Lane LLC · Brookshire, TXBuilt 2016 · S/N 4348N622GKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2009 · S/N 4164N635EPla Aircraft LLC · Detroit, MIBuilt 2016 · S/N 4355N645DCDfj LLC · Denver, COBuilt 2016 · S/N 4351N650LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 4174N663CBCb Aviation Inc · Ogden, UTBuilt 2006 · S/N 4058N668EMBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 4299N669TN600ty LLC · Plainview, TXBuilt 2010 · S/N 4186N674BPTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 4093N675RWHighlands Group LLC · Lahaina, HIBuilt 1989 · S/N 1046N67JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4092N6857FCudlob 4087 LLC · South Miami, FLBuilt 2007 · S/N 4087N6JGJg Leasing LLC · Bradenton, FLBuilt 2011 · S/N 4218N700MVMira Vista Aviation Inc · Irvine, CABuilt 2005 · S/N 4026N701WCKalihiwai Aviation LLC · Aspen, COBuilt 2011 · S/N 4224N703BGTen Point Tours Inc · Nashville, TNBuilt 2009 · S/N 4169N705KBRegistered aircraftBuilt 2000 · S/N 1429N717LSN717ls LLC · Miami Beach, FLBuilt 2008 · S/N 4109N719SASr Administrative Services LLC · Van Nuys, CABuilt 1990 · S/N 1155N728MHM/I Homes Of Delaware LLC · Columbus, OHBuilt 2015 · S/N 4346N741VETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1404N74GGDwm Logistics LLC · San Luis Obispo, CABuilt 1998 · S/N 1331N76THBellevue N76th LLC · North Kingstown, RIBuilt 2007 · S/N 4071N773LMAlko 250 LLC · San Francisco, CABuilt 2014 · S/N 4311N776BTHilltop Asset Holdings LLC · Saratoga Springs, NYBuilt 2009 · S/N 4170N778CRCmr LLC · Chicago, ILBuilt 2006 · S/N 4056N779AZPittco Aviation LLC · Memphis, TNBuilt 2007 · S/N 4089N787JSRegistered aircraftBuilt 2010 · S/N 4189N790DCTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N 4070N803AGTextile Aviation LLC · Dalton, GABuilt 2010 · S/N 4194N808CFBoss 8 LLC · Fort Worth, TXBuilt 1991 · S/N 1176N817AFArcadia Leasing LLC · Arcadia, WIBuilt 2016 · S/N 4352N817DEDouble Eagle Aviation LLC · Fort Worth, TXBuilt 2012 · S/N 4253N818BKAir Maui LLC · Oakland, CABuilt 2006 · S/N 4047N81GKRegistered aircraftBuilt 2011 · S/N 4225N821CNNoble Legacy Leasing LLC · Newark, DEBuilt 2007 · S/N 4085N824FMN824fm LLC · New York, NYBuilt 2011 · S/N 4222N830GRGwrg450 LLC · Atlanta, GABuilt 2012 · S/N 4259N844CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 4350N844GFDiamond A Administration Company LLC · Dallas, TXBuilt 2009 · S/N 4160
Back to AD 2012-06-17