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.

N577VAAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 067N578NGAcme Aviation LLC · Ankeny, IABuilt 2015 · S/N 1578N578UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6035N579BTBell Textron Inc · Fort Worth, TXS/N 57579N579JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2132N579MHJ1ap LLC · Naples, FLBuilt 2000 · S/N 560-5071N579QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5773N579UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6100N579WAPacific Crest Air LLC · Modesto, CABuilt 2015 · S/N 1579N57KWSchussboomer Systems Inc · Anacortes, WABuilt 2008 · S/N 1058N57MCMassman Construction Co · Overland Park, KSBuilt 2009 · S/N 2118N57SHSanford Health · Sioux Falls, SDBuilt 2014 · S/N 45-488N580JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2136N580QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5741N580TMTail Feathers LLC · Natchez, MSBuilt 2011 · S/N 1310N580UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6133N581DWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5353N581UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6152N5827KUmb Bank Na Trustee · Seatac, WABuilt 2010 · S/N 1081N582DWeidner Property Management LLC · Kirkland, WABuilt 2012 · S/N 5397N582MPPaladin Adventures LLC · Westlake, TXBuilt 2026 · S/N 560-6517N582UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6175N583JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2150N583PSConquest Express LLC · Libertyville, ILBuilt 2007 · S/N 331N583QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5812N583UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6181N5843KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 1071N584AAramco Associated Co · Houston, TXBuilt 2015 · S/N 4341N584JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2149N584UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6194N585DWColleen Corp · New Castle, DEBuilt 2014 · S/N 5485N585ESW G Yates & Sons Construction Co · Philadelphia, MSBuilt 2023 · S/N 560-6348N585JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2159N585UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6214N5861BSignature Air Inc · Canonsburg, PABuilt 2001 · S/N 182N5869KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1205N586ATHesswinds LLC · Caldwell, IDBuilt 2013 · S/N 1423N586DRDrp Aircraft Inc · Warren, MIBuilt 2012 · S/N 1292N586DZZeeco Inc · Broken Arrow, OKBuilt 2005 · S/N 560-5592N586GDGulfstream Aerospace Corp · Savannah, GABuilt 2014 · S/N 5486N586JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2160N586UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6230N586WDPilatex II LLC · Boerne, TXBuilt 2011 · S/N 1303N5879KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1226N587DVFs Leasing LLC · Newark, DEBuilt 2015 · S/N 4345N587GDGulfstream Aerospace Corp · Savannah, GABuilt 2015 · S/N 5520N587JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2177N587JFThunderhook Air Inc · Brentwood, TNBuilt 2012 · S/N 1358N587JJShasta Sky Works LLC · Redding, CABuilt 2021 · S/N 2118N587QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5805
Back to AD 2012-26-15 R1