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.

N948AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4933 N948JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6560 N948MRTulsa Pc 12 LLC · Tulsa, OKBuilt 2009 · S/N 1098 N949FFPacifico 949 LLC · Dover, DEBuilt 2013 · S/N 5423 N949FRUmb Bank N A Trustee · Salt Lake City, UTBuilt 2006 · S/N 2857 N949GMFour Fourteen Holdings LLC · Wilmington, DEBuilt 2006 · S/N 5120 N949JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6575 N94CKConsolidated Pipe & Supply Co Inc · Birmingham, ALBuilt 2010 · S/N 410 N94JLBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4205 N94LFCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 5039 N950AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3545 N950JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6609 N950RLR L R Investments LLC · Wilmington, OHBuilt 2005 · S/N 221 N950SFTsl 2 LLC · Jackson, WYBuilt 1988 · S/N 50 N950WBOakley 75 LLC · Fairburn, GABuilt 2012 · S/N 1329 N951AVWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 3574 N952JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6663 N952RBBest Advantage LLC · Kittitas, WABuilt 2008 · S/N 560-6006 N953PCPacific Coast Jet Charter Inc · Rancho Cordova, CABuilt 2020 · S/N 560-6294 N954AFRigi Inc · Portsmouth, NHBuilt 2020 · S/N 2054 N954AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3699 N954JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6725 N955AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3835 N955CNChildrens Hospital & Medical Center · Omaha, NEBuilt 2011 · S/N 1296 N955JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6757 N955MCJtm Industries LLC · Visalia, CABuilt 2010 · S/N 1195 N955SLN920md LLC · Oklahoma City, OKS/N 52 N956AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6050 N956JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6791 N957AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6057 N957BJExcel 957 Holdings LLC · Indianapolis, INBuilt 2000 · S/N 560-5086 N957JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6809 N957NLRim 4 Group LLC · Waterford, MIBuilt 2002 · S/N 560-5223 N958AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6103 N958JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6859 N959AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6110 N959CCChriscor Air LLC · Center Valley, PABuilt 2008 · S/N 560-5759 N959JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6903 N959RPOrlando Plane Partners LLC · Orlando, FLBuilt 2013 · S/N 2136 N95BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 2030 N95FMWhiskey Bravo Leasing LLC · Alpine, UTBuilt 2020 · S/N 2006 N95GJTouch And Go LLC · Darien, CTBuilt 2013 · S/N 1395 N95KHVole Vite LLC · Southfield, MIBuilt 2009 · S/N 1171 N95MJLfcm LLC · Dover, DEBuilt 2009 · S/N 5250 N95NBBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 560-6323 N95NPN95 Services LLC · Chicago, ILBuilt 2009 · S/N 560-6031 N95RSMod Hd1 LLC · Grand Rapids, MIBuilt 1999 · S/N 105 N960ASNolan Aviation LLC · Dover, DEBuilt 2010 · S/N 408 N960AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6125 N960CLDigital Interstate Management Inc · Keller, TXBuilt 1991 · S/N 094

Back to AD 2012-26-15 R1