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.

N903PPAir Pacific LLC · Salem, ORBuilt 2009 · S/N 1172 N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613 N904FLFlight Options LLC · Cleveland, OHS/N 145780 N904GBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 5101 N904JYB&D Aviation LLC · San Jose, CABuilt 2018 · S/N 5577 N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700 N905FJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 1986 · S/N 5 N905FLCorporate Flight Management Inc DBA · Smyrna, TNS/N 145775 N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854 N905LBLima Bravo Aviation LLC · Portola Valley, CABuilt 2023 · S/N 2330 N905WMValiair Lc Trustee · Casper, WYS/N 57347 N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651 N906ACBabs Air LLC · Georgetown, TXBuilt 2005 · S/N 560-5596 N906DKLangdale Industries Inc · Valdosta, GABuilt 2009 · S/N 560-6016 N906FSBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 5521 N906KAKrist Transportation LLC · Iron River, MIBuilt 2023 · S/N 2262 N906MMM6 Carson LLC · Las Vegas, NVBuilt 2008 · S/N 4136 N90705Qualitair LLC Trustee · MichelstadtS/N 685 N907AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7732 N907JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5865 N907WTCj Blue LLC · Little Rock, ARBuilt 1999 · S/N 560-5049 N908AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7775 N908CCTeton Trails LLC · Helena, MTBuilt 2010 · S/N 4195 N908KBWintrust Asset Finance Inc · Frisco, TXBuilt 2021 · S/N 57433 N909ADDac Aviation LLC · Saratoga Springs, NYBuilt 2006 · S/N 5135 N909AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7756 N909GCMw Air LLC · Lincoln, NEBuilt 1999 · S/N 560-5067 N909MVXcel Jet Management Inc · Newark, DEBuilt 2006 · S/N 2067 N909NGDhf LLC · Valentine, NEBuilt 2019 · S/N 1909 N909TTTranscon International Inc · Wilmington, DEBuilt 2008 · S/N 14501044 N90BTB & G Aviation Inc · Miami, FLS/N 45-2054 N90FDStonewall Aviation LLC · Oklahoma City, OKBuilt 2010 · S/N 560-6049 N90FJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 1998 · S/N 75 N90GMNiviem Farm Management LLC · Kalispell, MTBuilt 2021 · S/N 2132 N90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 29 N90GSG & S Aviation II LLC · Jackson, MSS/N 534 N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180 N90VLBank Of Utah Trustee · Salt Lake City, UTS/N 39091 N90XRInternational Aviation Technical Services Inc · Torrance, CABuilt 2007 · S/N 2090 N910AUWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7876 N910FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 1781 N910NMTriangle Real Estate LLC · Saint Peters, MOS/N 95 N910SCSunchasing LLC · Newark, DEBuilt 1994 · S/N 144 N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172 N910UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67980 N911AMEstado Libre Asociado De Puerto Rico · San Juan, PRS/N 57284 N911ARMiami Dade Fire Rescue · Miami, FLBuilt 2020 · S/N 41567 N911AZState Of Arizona · Phoenix, AZS/N 57301 N911DXAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 57377 N911EDAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 57006

Back to AD 2012-26-15 R1