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.

N668EMBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 4299 N668LFLife Flight Network LLC · Aurora, ORBuilt 2019 · S/N 1893 N668NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7135 N668SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 963 N668TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5268 N668UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30024 N669AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1792 N669NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7296 N669QSNetjets Sales Inc · Columbus, OHBuilt 2007 · S/N 560-5689 N669TN600ty LLC · Plainview, TXBuilt 2010 · S/N 4186 N669UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30025 N66CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5375 N66MTManatts Inc · Brooklyn, IABuilt 2007 · S/N 348 N66SGNorth Coast Aviation · Orchard Lake, MIBuilt 2000 · S/N 073 N67052United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29447 N67058United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29453 N670JDAmber Services Inc · Chicago, ILBuilt 1988 · S/N 45 N670JMRemlat Aircraft LLC · Atlanta, GABuilt 2003 · S/N 2005 N670KF2012 Leasing Inc · Saint Paul, MNBuilt 2002 · S/N 560-5306 N670LFLife Flight Network LLC · Aurora, ORBuilt 2017 · S/N 1695 N670MWDg Financial Consulting Inc · Longview, TXBuilt 2004 · S/N 560-5511 N670NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7106 N670RRTvpx Trust Co LLC · North Salt Lake, UTBuilt 2010 · S/N 5281 N670UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29240 N671HSEvans Aviation Holdings LLC · College Grove, TNBuilt 2002 · S/N 194 N671LEGreen Sky Aviation LLC · Jupiter, FLBuilt 2006 · S/N 5130 N671NGVolanding LLC · Miami Springs, FLBuilt 2016 · S/N 1671 N671NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7246 N671UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30026 N672ARKarma Air LLC · Lighthouse Point, FLBuilt 2014 · S/N 1467 N672NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7522 N672SCGlacier Flying Service LLC · Helena, MTBuilt 2008 · S/N 2099 N672UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30027 N673AWBank Of Utah Trustee · Salt Lake City, UTS/N 2312 N673AZAmazon.Com Services LLC · Seattle, WABuilt 2022 · S/N 67025 N673BASale Reported · Xxx, OKSale reportedBuilt 2014 · S/N 1496 N673CPHigh Hills LLC · Clinton, NCBuilt 2013 · S/N 57167 N673NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7395 N673UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29241 N674BPTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 4093 N674NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7462 N674UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29242 N675NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7668 N675UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29243 N675WBWrbc Transportation Inc · Greenwich, CTBuilt 2015 · S/N 41504 N676TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 560-5367 N676UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30028 N677UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30029 N678MBErf Flight Services LLC · Corpus Christi, TXBuilt 2022 · S/N 2175 N678MKKhairy Mohammed Al Trustee · San Diego, CAS/N 415

Back to AD 2012-26-15 R1