AD 2012-25-07

Registered aircraft · 251

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-25-07')
    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-25-07')
  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.

N703BGTen Point Tours Inc · Nashville, TNBuilt 2009 · S/N 4169N716WRTrans Texas Jet Transport Inc · Realitos, TXBuilt 2005 · S/N 4034N717LSN717ls LLC · Miami Beach, FLBuilt 2008 · S/N 4109N728MHM/I Homes Of Delaware LLC · Columbus, OHBuilt 2015 · S/N 4346N76THBellevue N76th LLC · North Kingstown, RIBuilt 2007 · S/N 4071N771LN157bc LLC · Winnetka, ILBuilt 2005 · S/N 4033N773LMAlko 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 4070N7RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4017N803AGTextile Aviation LLC · Dalton, GABuilt 2010 · S/N 4194N817AFArcadia 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 4160N844SJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4281N847RCRac Transcorp LLC · Lake Forest, ILBuilt 2011 · S/N 4215N850LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 4036N85MXBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4228N865JMDragonfly Holding LLC · Carmel, INBuilt 2007 · S/N 4078N868BBBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 4051N868BSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4080N882DEEco Aviation LLC · Coral Gables, FLBuilt 2011 · S/N 4233N884WEKe O Mele Flight Co LLC · Santa Barbara, CABuilt 2008 · S/N 4143N888NDNpm Equipment Leasing LLC · Dallas, TXBuilt 2015 · S/N 4343N88999Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 4362N8VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4161N901GOwens Illinois General Inc · Swanton, OHBuilt 2009 · S/N 4163N906MMM6 Carson LLC · Las Vegas, NVBuilt 2008 · S/N 4136N908CCTeton Trails LLC · Helena, MTBuilt 2010 · S/N 4195N913MKTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N 4075N915TBBmc Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4039N918CCAstor Street Asset Management Inc · Chicago, ILBuilt 2006 · S/N 4052N918LBBva Operations LLC · Miami Beach, FLBuilt 2010 · S/N 4199N918LLSienna Services Inc · Wilmington, DEBuilt 2009 · S/N 4177N91GVAir Lake Lines IV Inc · Saint Paul, MNBuilt 2006 · S/N 4053N92709Ashla Equipment Holdings LLC · Dallas, TXBuilt 2014 · S/N 4315N931DCCdt Ventures Group LLC · Riverside, CABuilt 2005 · S/N 4013N94JLBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4205N986SPAndie Kate LLC · Dover, DEBuilt 2008 · S/N 4140N989KMDouble X LLC · Palo Alto, CABuilt 2009 · S/N 4183N990SPGd Investments II LLC · Hingham, MABuilt 2012 · S/N 4260
Back to AD 2012-25-07