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.

N827MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29705 N827NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1716 N827QDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 0827 N827UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1022 N827ZFtfh LLC · Atlanta, GABuilt 2013 · S/N 5395 N828AWUS Bank Na Trustee · Boston, MAS/N 1552 N828CAAc Spe 13 LLC · Orlando, FLBuilt 2012 · S/N 1279 N828DRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 560-5774 N828JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5723 N828MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29699 N828NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1720 N828SATw Leasing LLC · Oxford, CTBuilt 2015 · S/N 1525 N828UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1031 N829AWU S Bank Na Trustee · Boston, MAS/N 1563 N829MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29700 N829NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1721 N829SASet Sail Air LLC · Elkhart, INBuilt 2015 · S/N 1533 N829UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1211 N82BULacore Adventures LLC · Melissa, TXBuilt 1988 · S/N 51 N82GTTextron Financial Corp · Wichita, KSBuilt 2011 · S/N 560-6068 N82HESummers-Taylor Inc · Johnson City, TNBuilt 2009 · S/N 560-6020 N82JKPlane Crazy LLC · Addison, TXBuilt 2007 · S/N 2072 N82KWRegistered aircraftBuilt 2011 · S/N 560-6094 N82NGVcpc12 LLC · San Francisco, CABuilt 2014 · S/N 1482 N82NYLeonardo Helicopters US Corp · Philadelphia, PAS/N 41631 N82SBAirborne Wake Riders LLC · Albany, NYBuilt 2011 · S/N 1281 N830AWU S Bank Na Trustee · Boston, MAS/N 1565 N830GRGwrg450 LLC · Atlanta, GABuilt 2012 · S/N 4259 N830JGGlflights LLC · San Antonio, TXBuilt 2012 · S/N 560-6107 N830JSRoss Advisors LLC · Naples, FLBuilt 2002 · S/N 560-5274 N830KWAlta 777 LLC · Salt Lake City, UTS/N 30870 N830MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29701 N830NRCalico G550 LLC · North Miami, FLBuilt 2008 · S/N 5201 N830NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1769 N830RRKenmore Air Harbor LLC · Kenmore, WABuilt 2009 · S/N 1149 N830UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1243 N831AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1576 N831GLFw Equipment Leasing LLC · Batesville, ARBuilt 2024 · S/N 560-6357 N831MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29702 N831MPD-Flat LLC · Monterey, CABuilt 2014 · S/N 1487 N831NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1783 N831TCRegistered aircraftBuilt 2011 · S/N 1311 N831UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1291 N832AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1643 N832MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29704 N832UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1321 N833AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1844 N833JSFe 5107 LLC · Kinston, NCBuilt 2000 · S/N 5605107 N833KWAlta 777 LLC · Salt Lake City, UTS/N 30868 N833MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29706

Back to AD 2012-26-15 R1