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.

N645DCDfj LLC · Denver, COBuilt 2016 · S/N 4351 N645EARegistered aircraftN-number assigned (import), not yet registeredS/N 5590 N645FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 227 N645GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27393 N645JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2900 N645LHL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5606 N645NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7008 N645PEBimco LLC · Wilmington, DEBuilt 2016 · S/N 1645 N645PMPag Management LLC · White Plains, NYBuilt 2006 · S/N 14500974 N646JBJetblue Airways Corp · Long Island, NYBuilt 2006 · S/N 2945 N646NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7062 N646TXKeystone Air LLC · Miami, FLBuilt 2002 · S/N 560-5246 N646UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25283 N647AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3647 N647AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1997 · S/N 762 N647MKLodge At Park Falls LLC · Reno, NVBuilt 2001 · S/N 560-5188 N647NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7635 N647UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25284 N648JBJetblue Airways Corp · Long Island, NYBuilt 2006 · S/N 2970 N648JSTress Aviation LLC · Camden, DEBuilt 2019 · S/N 1903 N648NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7656 N648UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25285 N649AWBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 803 N649JBJetblue Airways Corp · Long Island City, NYBuilt 2006 · S/N 2977 N649JPSeaguard Aviation LLC · Kalispell, MTBuilt 2015 · S/N 514 N649NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7679 N649UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25286 N64MJM J Electric LLC · Iron Mountain, MIBuilt 2001 · S/N 136 N64YCW G Yates & Sons Contruction Co · Philadelphia, MSBuilt 2018 · S/N 560-6261 N650AWU S Bank N A Trustee · Boston, MABuilt 1998 · S/N 856 N650CNCorporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 560-5294 N650GTUmb Bank N A Trustee · Salt Lake City, UTBuilt 1982 · S/N 22566 N650JFWasatch Aviation Group Six LLC · Sandy, UTBuilt 2015 · S/N 14501215 N650LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 4174 N650LYValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 14500825 N650MLValiair Lc Trustee · Casper, WYS/N 14500967 N650NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7724 N650RJTvpx Aircraft Solutions Inc Trustee · Salt Lake City, UTBuilt 2013 · S/N 14501174 N650TBBorland Caryn H Trustee · Prescott, AZBuilt 2017 · S/N 14501204 N651AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 866 N651JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 2992 N651NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 8018 N651UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25389 N652AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 0953 N652CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2003 · S/N 560-5326 N652GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1983 · S/N 22571 N652JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3029 N652NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 8021 N652UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25390 N653AFRigi Inc · Portsmouth, NHBuilt 2016 · S/N 1653

Back to AD 2012-26-15 R1