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.

N462FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 4129N463FXFlexjet LLC · Cleveland, OHBuilt 2010 · S/N 4182N464FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 4105N465FXFlexjet LLC · Cleveland, OHBuilt 2010 · S/N 4208N466FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4173N467FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4156N468FXFlexjet LLC · Cleveland, OHS/N 4300N469FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4151N470QSNji Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 4084N477FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 4118N478GSIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1478N479FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 4139N479SCRsc Aviation Company LLC · Atlanta, GABuilt 2006 · S/N 4057N481FXAviation Solutions LLC · Cleveland, OHBuilt 2013 · S/N 4277N482FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 4072N483FXJuststeven LLC · Cleveland, OHBuilt 2013 · S/N 4289N484FXFlexjet LLC · Cleveland, OHBuilt 2010 · S/N 4203N485FXHohman Robert · Cleveland, OHBuilt 2014 · S/N 4305N486FXBci Flexjet LLC · Cleveland, OHBuilt 2016 · S/N 4359N486WMTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2007 · S/N 4086N487FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4176N488FXRegistered aircraftBuilt 2017 · S/N 4363N489FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 4360N48PLLdp Aviation LLC · Sarasota, FLBuilt 2009 · S/N 4181N490FXKern Rene · Cleveland, OHBuilt 2017 · S/N 4364N494ECEastman Chemical Co · Kingsport, TNBuilt 2011 · S/N 4226N495JSP&P Air LLC · Salem, NHBuilt 1998 · S/N 1336N495RSSugar Pine Aviation LLC · Merlin, ORBuilt 2006 · S/N 4049N496GAGulfstream Aerospace Corporation · Savannah, GABuilt 2013 · S/N 4296N499SCFlying Ace LLC · Danville, CABuilt 2008 · S/N 4135N49RFUnited States Department Of Commerce · Lakeland, FLBuilt 1994 · S/N 1246N500GQIntellectual Air LLC · Atlanta, GABuilt 2010 · S/N 4191N500RLBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4158N504GTBengal Investments LLC · San Francisco, CABuilt 2008 · S/N 4149N508WFTmw Aviation Partners LLC · Westport, CTBuilt 2008 · S/N 4142N509CQBwp Aviation LLC · Nashville, TNBuilt 1993 · S/N 1233N50LKTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 1994 · S/N 1252N510SPKitty Hawk LLC · Fort Worth, TXBuilt 1993 · S/N 1183N512PMEbts LLC · New York, NYBuilt 2009 · S/N 4167N512RJRegions Commercial Equipment Finance LLC · Birmingham, ALBuilt 2008 · S/N 4124N515RAA & E Hawker Lp · Santa Ana, CABuilt 2000 · S/N 1434N516MCPjk Aviation LLC · Great Neck, NYBuilt 2004 · S/N 1531N518GSG S Transport Inc · San Antonio, TXBuilt 2016 · S/N 4353N51PRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 1425N520CMOwl Hill Holdings LLC · Nashville, TNBuilt 2016 · S/N 4358N523JMJmac Air LLC · Columbus, OHBuilt 2009 · S/N 4150N53WGAlliance Aviation Group LLC · Lawrence, KSBuilt 2003 · S/N 1505N558APLmc Leasing LLC · Tallahassee, FLBuilt 2009 · S/N 4159N584AAramco Associated Co · Houston, TXBuilt 2015 · S/N 4341N587DVFs Leasing LLC · Newark, DEBuilt 2015 · S/N 4345
Back to AD 2012-06-17