AD 2012-13-12

Registered aircraft · 1,192

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-13-12')
    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-13-12')
  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.

N197BDAfc Management LLC · Englewood, NJBuilt 1996 · S/N 1284N1986RRts Administrative Service Inc · Overland Park, KSBuilt 2012 · S/N 4263N198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1098N198RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 5588N199THTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5113N1AMMeruelo Group LLC · Downey, CABuilt 2000 · S/N 623N1BBBollinger Enterprises LLC · New Orleans, LABuilt 2001 · S/N 660N1BGGlobal Empire Trust LLC · Dover, DEBuilt 2001 · S/N 1436N1CCTonkawa Inc · Minnetonka, MNBuilt 2013 · S/N 5419N1DWac I LLC · Fort Lauderdale, FLBuilt 1992 · S/N 1209N1DCBlue Star Management Services Corp · Frisco, TXBuilt 2001 · S/N 651N1HCHardesty-Gulfstream LLC · Tulsa, OKBuilt 2003 · S/N 5009N1HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 1534N1JMWhiskey Uniform LLC · Wichita Falls, TXS/N 682N1NKBase Aviation LLC · Jupiter, FLBuilt 2015 · S/N 5534N1RPPts As LLC · Reading, PABuilt 2013 · S/N 5458N1TDThreshold Ventures Inc · Scottsdale, AZBuilt 1990 · S/N 1133N1TMMarsico Aviation LLC · Denver, COBuilt 2002 · S/N 1490N200CKMacs Aviation LLC · Columbus, INBuilt 2014 · S/N 4304N200KPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5170N200LCSn 1067 LLC · Wilmington, DEBuilt 1988 · S/N 1067N203RCWcs Inc · Troy, ALBuilt 2010 · S/N 4211N204AMercury International Holdings LLC · Salt Lake City, UTBuilt 2011 · S/N 5341N20GGoodyear Tire & Rubber Co · Akron, OHBuilt 2010 · S/N 4212N2107ZAir Prestigio LLC · Aliso Viejo, CAS/N 1211N210AMShamrock Aviation LLC · Miami, FLBuilt 2010 · S/N 4207N21112Ihgh LLC · Salt Lake City, UTS/N 4282N211DHHagadone Aviation LLC · Coeur D Alene, IDBuilt 2000 · S/N 1432N2120Wilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 5468N212VZNapleton Aviation Group LLC · Sugar Grove, ILBuilt 2014 · S/N 4325N213EFMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1996 · S/N 1283N213TGBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4219N215BBBl Charter LLC · Pittsfield, MABuilt 2000 · S/N 610N218HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5587N218KDMojave Jet LLC · Wilmington, DEBuilt 1991 · S/N 1164N218MDNe-2 LLC · Houston, TXBuilt 2003 · S/N 1515N219TFMaple Holdings LLC · Kansas City, MOBuilt 2013 · S/N 4292N21EHRegistered aircraftBuilt 2007 · S/N 5141N21UGiven To Fly Holdings LLC · West Chicago, ILS/N 5379N21UCUnited Co · Bristol, VABuilt 2014 · S/N 5484N220TDRegistration Pending · Rantoul, KSRegistration pendingBuilt 1988 · S/N 1070N221EAGlobal Acquisition Holdings LLC · Oklahoma City, OKBuilt 2002 · S/N 1476N221FFGayas LLC · Lowell, MABuilt 2009 · S/N 5221N221JRNorthview Aviation LLC · The Woodlands, TXBuilt 2012 · S/N 4257N221MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4038N222GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5222N222GYSpec Air LLC · Miami, FLBuilt 1990 · S/N 1142N222LXTrans Exec Air Service Inc · Van Nuys, CABuilt 2001 · S/N 633N222ZZMissaglia Aviation LLC · Rochester, NYBuilt 2008 · S/N 4137N223AEmmanuel Group · North Wilkesboro, NCS/N 5583
Back to AD 2012-13-12