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.

N473FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 502N473UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1469N474DMillard S Drexler Inc · Teterboro, NJBuilt 2005 · S/N 5083N474FTFaith Technologies Inc · Menasha, WIBuilt 2025 · S/N 2474N474FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 506N474KCSupreme Rental Services LLC · New Braunfels, TXBuilt 2014 · S/N 1474N474TTN474tt LLC · Atlanta, GABuilt 2021 · S/N 2097N474UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1475N4751KBartlett & West Inc · Topeka, KSBuilt 2013 · S/N 1429N475CWTeam Aero LLC · Shawnee, KSBuilt 2000 · S/N 560-5080N475LHLaboratory Corp Of America Holdings · Burlington, NCBuilt 2025 · S/N 2475N475LSDutchess Aviation LLC · Grand Rapids, MIBuilt 2021 · S/N 601N475MJG36 LLC · San Francisco, CABuilt 2014 · S/N 1475N475UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1495N476JCBas Part Sales LLC · Greeley, COBuilt 2011 · S/N 560-6095N476LALearjet 45 N476la LLC · Wilmington, DEBuilt 2000 · S/N 077N476UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1508N477AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5477N477FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 4118N477KROrchard Elms LLC · North Ogden, UTBuilt 2018 · S/N 1778N477MDAero 170 LLC · Park City, UTS/N 268N477UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1514N4787KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1874N478UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1533N479AWAirwerks Aviation Services LLC · Bentonville, ARBuilt 2008 · S/N 1035N479AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25450N479FARa Flies LLC · Owasso, OKBuilt 2000 · S/N 096N479FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 4139N479JSWest Lake Holdings Inc · Fort Smith, ARBuilt 2004 · S/N 2012N479LTRunway Group LLC · Bentonville, ARBuilt 2021 · S/N 2087N479SCRsc Aviation Company LLC · Atlanta, GABuilt 2006 · S/N 4057N479UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1538N47EKL J Associates Inc · Latrobe, PABuilt 2013 · S/N 560-6147N47HFCitation Msn 560-5153 LLC · Wilmington, DEBuilt 2003 · S/N 560-5347N47NGRegistration Pending · Shreveport, LARegistration pendingBuilt 2009 · S/N 1103N47NXRdi 1 Air Ab LLC · Cincinnati, OHBuilt 2009 · S/N 1116N47WDDe Haas Air LLC · Austin, TXBuilt 2019 · S/N 1871N480ESEagle Rock Air Inc · Dallas, TXBuilt 2008 · S/N 2097N480UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1555N481AVAircol 21 · Wilmington, DEBuilt 2010 · S/N 4381N481CMCargo Aircraft Management Inc · Wilmington, OHS/N 26992N481FXAviation Solutions LLC · Cleveland, OHBuilt 2013 · S/N 4277N481UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1559N482FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 4072N482UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1584N483FXJuststeven LLC · Cleveland, OHBuilt 2013 · S/N 4289N483SCBayside Unit LLC · Chicago, ILS/N 445N483UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1586N4840WGolden Ben Air LLC · Nashville, TNBuilt 2006 · S/N 228N484FMV1vr LLC · Wilmington, DES/N 81
Back to AD 2012-26-15 R1