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.

N70SBBlack Gumball Holding LLC · Arlington, TXBuilt 2017 · S/N 559 N70THAlliance Aviation Group LLC · Wilmington, DEBuilt 1998 · S/N 560-5007 N70VLBank Of Utah Trustee · Salt Lake City, UTS/N 30440 N710DNJetran LLC · Horseshoe Bay, TXBuilt 2010 · S/N 40560 N710EPLeonardo Helicopters US Corp · Philadelphia, PAS/N 41640 N710ETQuack Quack LLC · Portland, ORBuilt 1996 · S/N 38 N710FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7179 N710GTTitan Aviation Leasing Ltd - Americas Inc · Purchase, NYBuilt 2023 · S/N 67995 N710UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 1999 · S/N 1019 N71111Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5316 N711BH711 Holdings LLC · Oklahoma City, OKBuilt 2007 · S/N 2070 N711BSBlue Transport LLC · Columbia, SCBuilt 2009 · S/N 560-6015 N711EGG550 N711 LLC · Newport Beach, CABuilt 2009 · S/N 5231 N711FJBirner Aviation LLC · Earth City, MOBuilt 1989 · S/N 071 N711FPF A Peinado LLC · Frisco, TXBuilt 2005 · S/N 560-5565 N711FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7184 N711LXNational Education Loan Network Inc · Lincoln, NEBuilt 2021 · S/N 560-6300 N711LZBg22 LLC · Lewes, DEBuilt 2006 · S/N 560-5597 N711NXErf Flight Services LLC · Corpus Christi, TXBuilt 2017 · S/N 1711 N711RHouston Jet Direct Management And Charter Inc · Houston, TXBuilt 2014 · S/N 45-491 N711RWAuto & Otolar LLC · Lawrence, KSBuilt 1989 · S/N 69 N711SRSpur Aviation Services Lc · Twin Falls, IDBuilt 2015 · S/N 1547 N711UWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1033 N711WVRoss Airplane LLC · Parkersburg, WVBuilt 1997 · S/N 166 N712ABArcbest II Inc · Fort Smith, ARBuilt 2020 · S/N 560-6297 N712FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7204 N712GKKs Air 3-7-12 Vi LLC · Charlotte, NCBuilt 2021 · S/N 560-6312 N712GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 69787 N712JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3517 N712JNIp Aviation LLC · Saint Paul, MNBuilt 2022 · S/N 560-6332 N712LWWanderweg Holdings LLC · Salt Lake City, UTBuilt 2007 · S/N 5154 N712PVTacocat LLC · Omaha, NEBuilt 2005 · S/N 560-5556 N712SLAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 57374 N712USBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1038 N713FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7286 N713NGNiagara Mohawk Power Corp DBA · Syracuse, NYBuilt 2014 · S/N 57219 N713PEAllen Air LLC · Creola, ALBuilt 2017 · S/N 1713 N713TXZeplane LLC · Miami, FLBuilt 2000 · S/N 560-5063 N713UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1040 N714FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7294 N714JBOjw LLC · Wilmington, DES/N 18 N714USUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1046 N714WAMustang Interests LLC · Fort Worth, TXBuilt 2016 · S/N 560-6217 N715AFWalking Rock Corp · Portsmouth, NHBuilt 2017 · S/N 1715 N715ASHerzog Roofing Inc · Detroit Lakes, MNBuilt 2009 · S/N 1185 N715FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7313 N715JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3554 N715MNCohasp Aero Ventures LLC · Overland Park, KSBuilt 2009 · S/N 560-6048 N715UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1051 N716EMReve Air LLC · Encinitas, CABuilt 2024 · S/N 2410

Back to AD 2012-26-15 R1