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.

N900JJetran LLC · Horseshoe Bay, TXS/N 5200N900KDThird Rockmar LLC · Denton, TXBuilt 2004 · S/N 560-5523N900KUFalcon 900-91 LLC · Lewes, DEBuilt 1991 · S/N 91N900KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 53N900LCMid Central Leasing LLC · Waukegan, ILBuilt 2000 · S/N 186N900LPDoctair Inc · Mclean, VABuilt 1987 · S/N 20N900MKRacer X LLC · Chicago, ILBuilt 1988 · S/N 40N900MWGlobal Jet Partners LLC · Scottsdale, AZS/N 78N900RHRite Hite Holding Corp · Milwaukee, WIBuilt 2015 · S/N 5507N900SBBg Air LLC · Hobbs, NMBuilt 1991 · S/N 107N900SFFalcon 900 LLC · Mount Laurel, NJBuilt 1987 · S/N 16N900TEFalcon 900 LLC · Ocala, FLBuilt 1986 · S/N 12N900TNRegistered aircraftBuilt 1996 · S/N 158N900TVN900tx LLC · Austin, TXBuilt 2000 · S/N 560-5097N900UWAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7617N900VCFalcon-121 LLC · Salem, ORBuilt 1992 · S/N 121N900VPJdr 194 LLC · Woody Creek, COBuilt 2002 · S/N 194N900XLMonroe Aviation LLC · Columbus, MSBuilt 2005 · S/N 560-5544N900YBBold Access LLC · Leawood, KSBuilt 1987 · S/N 18N900YYBbps Aviation LLC · Mckinney, TXBuilt 1991 · S/N 101N9010RUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5789N9011PWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5798N9012American Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5810N9013AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5827N9015DUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5327N9016Umb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6040N9017PUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6085N9018EUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6150N9019FUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6154N901AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7636N901CBBravo 997 LLC · Grand Rapids, MIBuilt 2022 · S/N 560-6334N901CRCxlo Enterprises LLC · Cincinnati, OHBuilt 2001 · S/N 560-5141N901GOwens Illinois General Inc · Swanton, OHBuilt 2009 · S/N 4163N901HDN27ax LLC · Tulsa, OKBuilt 2001 · S/N 149N901KRAvatar Wings LLC · Dallas, TXBuilt 1994 · S/N 146N901XBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 5603N9021HUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6277N9022GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6310N9023NUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6349N9025BUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6393N9026CAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6429N9029FAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6491N902AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7519N902AMBslcc-III LLC · Renton, WABuilt 2002 · S/N 206N902FHCcbcc Operations LLC · Charlotte, NCBuilt 2019 · S/N 560-6280N902JJetran LLC · Horseshoe Bay, TXBuilt 2004 · S/N 214N902SMJacobs Aviation II LLC · Pompano Beach, FLS/N 2027N903AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7566N903ASRegistered aircraftBuilt 2009 · S/N 5256N903JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5783
Back to AD 2012-26-15 R1