OpenAirDocs.org
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
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.

N884HBAsilo Operations LLC · Pearsall, TXBuilt 2024 · S/N 2375N884SGRegistered aircraftBuilt 2011 · S/N 5319N884UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2579N884WEKe O Mele Flight Co LLC · Santa Barbara, CABuilt 2008 · S/N 4143N885AREssseaeff Aviation LLC · Jericho, NYBuilt 2008 · S/N 5224N885BHWest Star Construction Inc · Kingsburg, CABuilt 2007 · S/N 560-5717N885BMBtga LLC · Brent, ALBuilt 2011 · S/N 1312N885NGWildcat Aviation LLC · South Beach, ORBuilt 2019 · S/N 1885N886LFLife Flight Network LLC · Aurora, ORBuilt 2016 · S/N 1616N886WFWynalda Aviation LLC · Belmont, MIBuilt 2021 · S/N 2136N887MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5321N887PCPcj LLC · Carmel, INBuilt 2018 · S/N 560-6252N887SGN45ax LLC · Tulsa, OKBuilt 2001 · S/N 174N887TMTai Leasing Inc · Mckinney, TXBuilt 2010 · S/N 5294N887WPPack Force One LLC · Raleigh, NCBuilt 2001 · S/N 560-5147N8888Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 28N888AAAbbett Air LLC · La Crosse, INBuilt 2018 · S/N 1797N888ATAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2004 · S/N 14500802N888DSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2001 · S/N 165N888FDFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42704N888JELeone Management Inc · Camden, DEBuilt 2005 · S/N 5070N888KZKz Partners Inc · Dover, DEBuilt 2010 · S/N 5309N888LDJlssaa LLC · Foothill Ranch, CABuilt 2012 · S/N 5372N888NAIdeavillage Products Corp · Wayne, NJBuilt 1999 · S/N 77N888NDNpm Equipment Leasing LLC · Dallas, TXBuilt 2015 · S/N 4343N888NSRegistered aircraftBuilt 2012 · S/N 5377N888RTOrlando Plane Partners LLC · Orlando, FLBuilt 2009 · S/N 560-6033N88999Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 4362N889CAGracon Express LLC · Lafayette, COBuilt 2001 · S/N 132N889CJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5449N889MSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2008 · S/N 5190N889MUGf Aircraft LLC · Tampa, FLBuilt 2002 · S/N 160N889UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2667N88AFRair LLC · Chicago, ILBuilt 2008 · S/N 560-6004N88AQAdvanced Air LLC · Hawthorne, CABuilt 2008 · S/N 1029N88AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 5337N88CSTelepak Networks Inc · Ridgeland, MSBuilt 2023 · S/N 560-6351N88DWUS Trinity Equipment LLC · Argyle, TXBuilt 2014 · S/N 57247N88GForum Aviation LLC · Portage, OHBuilt 2016 · S/N 1660N88GDKamali Aviation LLC · Great Neck, NYBuilt 1996 · S/N 30N88HPNlp Leasing LLC · North Adams, MABuilt 1999 · S/N 560-5050N88MFDmjg Holdings LLC · Wallace, NCBuilt 2010 · S/N 14501117N88NTDover Aviation LLC · Dover, DEBuilt 2009 · S/N 1170N88SGdb 8 LLC · Oklahoma City, OKBuilt 2015 · S/N 1583N890DACite Aviation LLC · Wilmington, DEBuilt 2005 · S/N 5079N890JSDtfa LLC · Kinston, NCBuilt 2010 · S/N 560-6065N890TGGriffin Gin LLC · Helena, ARBuilt 2008 · S/N 1033N890UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2815N890WALife Flight Network LLC · Aurora, ORBuilt 2010 · S/N 1189N891FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 41440
Back to AD 2012-26-15 R1