Skip to content

AD 2012-26-15 R1

Registered aircraft · 5,537

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

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-26-15-R1') 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-26-15-R1') ORDER BY n_number

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-26-15-R1')
    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-26-15-R1')
  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.

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-26-15-R1')
  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-26-15-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N626NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5999 N626RAMavir LLC · Albany, NYBuilt 2007 · S/N 5176 N626TNSt Simons Aviation LLC · St Simons Island, GABuilt 2002 · S/N 560-5254 N627JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2577 N627LGLive Mas Enterprises LLC · Greenwood Village, COBuilt 1995 · S/N 14 N627NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6082 N628NGEagle Rock Management LLC · Yarrow Point, WABuilt 2016 · S/N 1628 N628NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6193 N628SRKing Air Partners LLC · Turlock, CABuilt 2008 · S/N 1069 N628VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 2993 N628VTMrm Services LLC · Phoenix, AZBuilt 2016 · S/N 1594 N629BKKeselowski Transportation LLC · Statesville, NCBuilt 2002 · S/N 198 N629BTHbc Aviation LLC · Dallas, TXFirst renewal noticeBuilt 2007 · S/N 560-5696 N629JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2580 N629KAPhillips Avenue Holdings LLC · Virginia Beach, VABuilt 2012 · S/N 1335 N629NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6300 N629RTIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 31269 N62GXSouthport Air LLC · Coos Bay, ORBuilt 2020 · S/N 2062 N62KWCricket Creek LLC · Springfield, MOBuilt 2016 · S/N 560-6205 N62NG7r Enterprises LLC · Westwood, KSBuilt 2014 · S/N 1462 N630CGCcgx LLC · Lexington, KYBuilt 2023 · S/N 560-6339 N630FBCity Of Phoenix · Phoenix, AZBuilt 2024 · S/N 2360 N630JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2640 N630NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 6304 N630VABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3101 N630VCAnanim LLC · Lincolnwood, ILBuilt 1998 · S/N 071 N631JDGoodwyn Partners LLC · Mobile, ALBuilt 2006 · S/N 560-5631 N631NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2014 · S/N 6327 N632AVBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5632 N632JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2647 N632JSRms Flight Services LLC · Wilmington, DEBuilt 1999 · S/N 061 N632PBModern Transportation Company Inc · Owensboro, KYBuilt 1995 · S/N 17 N632TXExcel Aviation LLC · Waukesha, WIBuilt 2004 · S/N 560-5358 N632XLCerulean II LLC · Wilmington, DEBuilt 2006 · S/N 560-5632 N633JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2671 N633NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6345 N633VAAj Aviation Holdings LLC · Miami Springs, FLBuilt 2007 · S/N 3230 N634BE4 Solt LLC · Atlanta, GABuilt 2009 · S/N 560-6034 N634JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2710 N634NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6370 N635EPla Aircraft LLC · Detroit, MIBuilt 2016 · S/N 4355 N635JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2725 N635NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6383 N635XLHorizon Group Services LLC · Millersburg, OHBuilt 2017 · S/N 560-6235 N636EJJk Air LLC · Fayetteville, ARBuilt 2002 · S/N 560-5304 N636JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2755 N636NKUmb Bank Na - Trustee · Salt Lake City, UTBuilt 2015 · S/N 6424 N636SJHrm Aviation LLC · Chesterfield, MOS/N 104 N637AMTwo Wingz Charter LLC · Newport Beach, CABuilt 2000 · S/N 560-5137 N637JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2781

Back to AD 2012-26-15 R1