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.

N931UPBoeing Co · Renton, WAS/N 70806 N932AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7419 N932UPBoeing Co · Renton, WAS/N 70807 N933AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7564 N933HHoneywell Aerospace US LLC · Phoenix, AZBuilt 2005 · S/N 5077 N933JJTeam J&J Aircraft Leasing LLC · Brandon, FLBuilt 2016 · S/N 1658 N933MRMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2012 · S/N 560-6126 N933UPBoeing Co · Renton, WAS/N 70808 N934AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7500 N934JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6130 N934NGSeley Candra H Trustee · Wellington, FLBuilt 2008 · S/N 1034 N935BBWells Enterprises Inc · Le Mars, IABuilt 2014 · S/N 560-6180 N935JBJet Blue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6185 N935PFPentagon Federal Credit Union · Mclean, VABuilt 2020 · S/N 560-6293 N935RKKing Air LLC · Oak Brook, ILBuilt 2007 · S/N 318 N936EASeven Hills 5260 LLC · Lynchburg, VABuilt 2006 · S/N 560-5670 N937JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6245 N939AJContinental 678 Fund LLC · Leesburg, VABuilt 2005 · S/N 14500939 N939AVAircol 24 · Wilmington, DEBuilt 2011 · S/N 4939 N939BGBristow LLC · Lake Charles, LABuilt 2010 · S/N 41234 N939HEAir Monadnock LLC · Dublin, NHBuilt 2008 · S/N 1005 N939PCBad Ass Pilatus LLC · Des Moines, IAS/N 2264 N939ZIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2006 · S/N 31061 N93NXBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1393 N940TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5198 N941FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2483 N941KAKag Leasing Inc · North Canton, OHBuilt 2004 · S/N 560-5510 N941MBUmb Bank Na Trustee · Salt Lake City, UTS/N 0941 N942FKForty Er LLC · Bethany, OKBuilt 2001 · S/N 145 N942JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6279 N942JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 5487 N942NGWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 1042 N943FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2518 N943JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6326 N944AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4730 N944GTRegistered aircraftBuilt 2025 · S/N 2467 N944JDAirport Equipment Rentals Inc · Fairbanks, AKBuilt 2020 · S/N 2059 N944JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6359 N945AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4733 N945EJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 2108 N945HCFloundering Four LLC · Anchorage, AKBuilt 2000 · S/N 109 N945JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6390 N945TMAvpro Inc · Annapolis, MDBuilt 2005 · S/N 5086 N946AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4924 N946JLJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6425 N946RBKm Aviation LLC · Houston, TXBuilt 2009 · S/N 1137 N946RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 575 N947DTTkr Aviation LLC · Ballwin, MOBuilt 1992 · S/N 117 N947JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6448 N947TRBell Textron Inc · Fort Worth, TXS/N 57560

Back to AD 2012-26-15 R1