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.

N961AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3961 N961BHSierra Pacific Industries · Redding, CABuilt 2013 · S/N 57146 N961CBAnderson Bryan Trustee · Mesa, AZS/N 1065 N961JFAha Aviation LLC · Somerset, NJS/N 5349 N961JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6930 N961MMImmi Aviation LLC · Westfield, INS/N 356 N961NXKnollwood Navigation LLC · Hunt Valley, MDBuilt 2025 · S/N 2466 N962JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6988 N963ADDgcac Holding LLC · New Canaan, CTBuilt 2021 · S/N 560-6299 N963CBAnderson Bryan Trustee · Ogden, UTBuilt 2008 · S/N 1072 N963DPGreenrock Company LLC · Panama City Beach, FLBuilt 2022 · S/N 2234 N963LKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 2242 N964JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7018 N965JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 6512 N965KTWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 57020 N965LATrey Aviation LLC · North Oaks, MNBuilt 2023 · S/N 41584 N965SPLouisiana State Police · Baton Rouge, LABuilt 2022 · S/N 57445 N966ADBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1966 N966ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1241 N966JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7230 N966WADelta Holdings LLC · Meridian, IDBuilt 2019 · S/N 1911 N967BKBlack Knight Aviation Services LLC · Whitefish, MTBuilt 2011 · S/N 57074 N967JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7257 N968AVAircol 5 · Wilmington, DEBuilt 2009 · S/N 1009 N968BSInterair LLC · Sioux Center, IABuilt 2001 · S/N 560-5193 N968JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7305 N969JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7353 N96NBBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 560-6337 N96TERegistered aircraftBuilt 1999 · S/N 560-5029 N96UAThree Diamond Flyers LLC · Glen Burnie, MDBuilt 2012 · S/N 5367 N970JBJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7415 N970JDFalcon Fawzi II LLC · Fort Lauderdale, FLBuilt 1992 · S/N 119 N970SJKnc Equipment LLC · Jupiter, FLBuilt 2008 · S/N 5194 N970UYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3924 N971JA725ja Capital Holdings LLC · Newark, DEBuilt 1999 · S/N 104 N971JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7390 N971UYAmerican Airlines Inc · Fort Worth, TXS/N 6249 N972JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7455 N972TPRegistered aircraftBuilt 2017 · S/N 1736 N972UYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4123 N973ACAlcamo Aviation LLC · Jupiter, FLS/N 5215 N973JTJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8581 N973MNRltcd LLC · Corona, CABuilt 2014 · S/N 5478 N973UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4893 N974HRTj Aviation LLC · Reidville, NCBuilt 1996 · S/N 33 N974JTJetblue Airways Corp · Long Island City, NYBuilt 2016 · S/N 7448 N974SZUS Bank Na Trustee · Hartford, CTBuilt 2016 · S/N 5545 N974UYAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4898 N975APFlying Farmers LLC · Vista, CABuilt 2022 · S/N 560-6331 N975DMSan LLC · Knoxville, TNBuilt 2007 · S/N 2073

Back to AD 2012-26-15 R1