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.

N135PFPeco Foods Inc · Tuscaloosa, ALBuilt 2017 · S/N 1752N135SCBallator Equipment Leasing LLC · Beech Mountain, NCBuilt 2006 · S/N 14500972N135SGValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 145706N135SKZed Aerocapital LLC · Dover, DEBuilt 2007 · S/N 14500989N135SLZed Aerocapital LLC · Dover, DEBuilt 2003 · S/N 145711N135SPCit Xl LLC · Naples, FLBuilt 2000 · S/N 560-5089N136ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6532N136FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64058N136FXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 5193N137AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6647N137ARWyatt Aerospace LLC · Chandler, AZS/N 362N137BRCimarron Aviation LLC · El Paso, TXBuilt 2007 · S/N 45-2068N137SHDream Global Parts LLC · Lawrence, KSS/N 137N1381AMsn 27615 LLC · Purchase, NYBuilt 1997 · S/N 27615N138ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6650N138FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42723N138FJEthox Chemicals LLC · High Point, NCBuilt 2005 · S/N 222N138PSEncore Asset Mgmt LLC · Newton, ILBuilt 2016 · S/N 1646N138TTTtd Travel LLC · Terre Haute, INBuilt 2022 · S/N 2192N139Eurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2009 · S/N 31229N1392CRegistered aircraftBuilt 2025 · S/N 41602N13999Zeit2019 LLC · Salt Lake City, UTBuilt 2014 · S/N 5494N1399AAndromeda Leasing I LLC · Purchase, NYBuilt 1996 · S/N 27959N139AKTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 41565N139ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6687N139BAgustawestland Philadelphia Corp · Philadelphia, PAS/N 41628N139DERegistered aircraftBuilt 2013 · S/N 41334N139EXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31851N139FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43538N139HHoneywell Aerospace US LLC · Phoenix, AZBuilt 2007 · S/N 31101N139PHPhi Aviation LLC · Lafayette, LAS/N 41253N139TPBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41409N139WTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 41612N139XLBoard Of Regents · Austin, TXBuilt 2013 · S/N 560-6139N13ERCircle E Aviation LLC · Florence, TXBuilt 2005 · S/N 560-5541N13PJcngx LLC · New York, NYBuilt 2022 · S/N 2156N13QCJetran LLC · Horseshoe Bay, TXS/N 36306N13UARegistered aircraftBuilt 2022 · S/N 2205N1409AMsn 27959 LLC · Purchase, NYBuilt 1996 · S/N 27960N140ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6667N140FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43541N140FJM Investments LLC · San Diego, CABuilt 1995 · S/N 140N140HMHarbert Aviation 40 LLC · Birmingham, ALBuilt 2008 · S/N 2103N140PHPhi Aviation LLC · Lafayette, LABuilt 2010 · S/N 41254N140UCosmos Holdings Group LLC · Newark, DEBuilt 1999 · S/N 560-5032N141FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42724N141JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4115N141JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 2010N141NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6656N141PHPhi Aviation LLC · Lafayette, LAS/N 41266
Back to AD 2012-26-15 R1